Session I - Navigating the Updated Interface

Time - 2 hours

Description

This course provides information about the new user interface designed for the Microsoft Office 2007 applications.

Objectives

• This course provides information about the new user interface designed for the Microsoft Office 2007 applications.
• List and describe the features of the new Office 2007 user interface
• Change application settings in Office 2007 products
• Use the Live Preview feature

Topics

• Why the Big Change?
• The Ribbon: Command Tabs and Contextual Tabs
• The Ribbon: The Office Menu
• Galleries and Live Preview
• Other New Interface Features

Session II - Common Features in Office 2010

Time - 3 hours

Description

This course explores the new features that the major Office 2010 applications have in common.

Objectives

• This course explores the new features that the major Office 2010 applications have in common.
• Modify and minimize the Ribbon
• Use Backstage view
• Capture windows and clippings
• Add artistic and color effects to images
• Save documents to the Web
• Work with Office Web Apps

Topics

• Modifying the Ribbon
• Working with Backstage View
• Capturing Windows and Clippings
• Removing Image Backgrounds
• Adding Artistic and Color Effects
• Checking Document Accessibility
• Saving Documents to the Web
• Working with SkyDrive
• Using Office Web Apps

Session III - What's New in Access 2007

Time - 2 hours

Description

This course provides an overview of the new features in Microsoft Office Access 2007.

Objectives

• This course provides an overview of the new features in Microsoft Office Access 2007.
• Navigate Access using the Ribbon, the Office Menu, and the Navigation Pane
• Create a database
• Create new forms
• Filter the data in a table
• Generate reports from a table
• Migrate database objects to SQL Server and Windows SharePoint Services

Topics

• The New Look
• Creating a Database
• Importing Data
• Filtering Data
• Creating Reports
• Upsizing and Moving Data

Session IV - What's New in Access 2010

Time - 3 hour

Description

This course explores the new features in Microsoft Access 2010.

Objectives

• This course explores the new features in Microsoft Access 2010.
• Describe the new Ribbon features
• Visualize trends with data bars
• Create application parts and data type parts
• Use calculated fields
• Build data macros
• Insert Web content and create Web databases

Topics

• Reviewing the Ribbon Tabs in Access
• Visualizing Trends with Data Bars
• Building Application Parts
• Creating Data Type Parts
• Using Calculated Fields
• Building Data Macros
• Inserting Dynamic Web Content
• Creating Web Databases