Exam 77-601: MOS: Using Microsoft Office Word 2007 Curriculum Outline

Getting Started with Word 2007

Target Audience

TBC

Expected Duration

1.0 Hour

Objectives :

Starting Work in a New Word 2007 Document

Enter and delete text in a Word document

The Word 2007 Screen

Locate the main elements of Word 2007s screen

Match the main features of Word 2007s screen with their descriptions

Navigating Documents in Word 2007

Recognize methods for navigating through a Word document given a scenario

Identify methods for paging through a document

Back to List

Working with Text and Paragraphs in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.60 Hours

Objectives :

Word 2007s Formatting Features

Identify the formatting options in Word

Use the Home tab to format text

Format Text in Word 2007

Apply basic text formatting in a scenario

Cut, Copy, and Paste Text in Word 2007

Cut and paste text in a Word document

Copy and paste text in a Word document

Add Lists and Symbols in Word 2007

Create lists in a Word document

Add symbols in a Word document

Set Margins and Indents in Word 2007

Work with margins in a Word document

Set indents in a Word document

Work with Paragraphs in Word 2007

Use tab stops

Align text in a Word document

Back to List

Structuring, Editing, Saving, and Opening Documents in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Insert Page and Section Breaks in Word 2007

Insert a page break

Insert a section break

Adjust Spacing and Inserting Columns in Word 2007

Adjust spacing in a Word document

Insert columns in a Word document

Use Basic Editing Tools in Word 2007

Correct spelling errors in a document

Correct grammar errors in a document

Save and Open Word 2007 Documents

Save a new Word document

Save an existing document

Open an existing Word document in a given scenario

Save Word 2007 Documents in Different Formats

Save a Word document in PDF format

Save a Word document as a web page

Back to List

Printing, Help, and Automated Formatting in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.5 Hours

Objectives :

Preview and Print a Document in Word 2007

Print a file

Preview a page before printing

Use Word 2007’s Help and Research Options

Use Word Help

Use Words Research feature

Use Word 2007s Style Options

Apply a style to selected text

Create a new Quick Style

Apply a new Quick Style set to a document

Use Word 2007’s AutoCorrect Features

Use AutoCorrect

Use Smart Tags

Use Word 2007’s Templates

Create a blank template

Create a template based on an existing document

Create a new template based on an existing template

Use Word 2007’s Building Blocks

Create a reusable building block

Distribute a building block with a template

Back to List

Working with Documents in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Headers, Footers, and Page Numbers in Word 2007

Insert a header

Insert a footer |w

Insert page numbers |w

Navigate Word 2007 Documents using Views

Navigate a Word document using the Outline view

Navigate a Word document using Full Screen Reading view

Navigate using Line Numbers, Thumbnails, and Document Map

Navigate a document using line numbers

Navigate a Word document using Document map

Navigate a Word document using Thumbnails

Use Word 2007’s Drawing Tools

Add a shape

Insert WordArt

Work with Pictures and SmartArt graphics in Word 2007

Add a picture

Add clip art

Add a SmartArt graphic

Back to List

Advanced Formatting in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.20 Hours

Objectives :

Page Formatting in Word 2007

Add a page border

Position a page border

Add a text border

Watermarks and Backgrounds in Word 2007

Add a watermark to a document

Add a custom background to a document

Themes and Document Statistics in Word 2007

Apply a theme

Change document properties

Footnotes and Endnotes in Word 2007

Insert a footnote

Insert an endnote

Customize an endnote

Back to List

Advanced Document Navigation and Document Reviews in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Creating Tables of Contents in Word 2007

Create a table of contents

Identify the function of a table of contents

Modify a table of contents

Hyperlinks and Bookmarks in Word 2007

Create a hyperlink

Add a bookmark

Create Indexes and Cross-References in Word 2007

Insert an index

Modify an index

Create an index using a concordance file

Document Review Features in Word 2007

Use the track changes feature to edit a document

Insert a comment

Document Recovery in Word 2007

Use the Document Recovery Pane

Backing Up and Repairing Word 2007 Documents

Save backup copies of documents

Use the file recovery converter

Back to List

Using Tables, Charts, and Graphics in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Formatting Tables

Format a table

Display or hide gridlines

Convert text to a table or vice versa

Modify Table Structure in Word 2007

Add a cell, row, or column to a table

Merge cells in a table

Sort Table Data in Word 2007

Sort table contents

Create Word 2007 Tables from Excel

Embed a selection from an Excel worksheet in a Word document

Distinguish between linked and embedded objects

Link to an Excel worksheet in a Word document

Working with Charts in Word 2007

Insert a chart into a Word document

Paste an Excel chart into Word

Back to List

Advanced Data Manipulation Features in Word 2007

Target Audience

Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2007; advanced end-users seeking to obtain Microsoft Office certification at in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent.

Expected Duration

1.00 Hour

Objectives :

Use Forms in Word 2007

Add form controls

Match the form type with its appropriate use

Add protection to content controls in a form

Protect a form document

Use Fields in Word 2007

Create a field

Modify a field

Use Mail Merge features in Word 2007

Create a form letter using mail merge

Print envelopes or labels

Back to List

Advanced Document Features in Word 2007

Target Audience

Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2007; advanced end-users seeking to obtain Microsoft Office certification at in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent.

Expected Duration

1.00 Hour

Objectives :

Using Macros in Word 2007

Record a macro

Edit a macro

Customizing Word 2007s Interface

Add a command to the Quick Access Toolbar

Use Master Documents in Word 2007

Create a master document

Create subdocuments

Manage Master Documents in Word 2007

Modify a master document

Manage subdocuments

Back to List

Collaborative Features in Word 2007

Target Audience

Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2007; advanced end-users seeking to obtain Microsoft Office certification at in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Securing Document Formatting in Word 2007

Lock document formatting

Assign a password to a document

Document Protection in Word 2007

Use the Document Inspector

Add a digital signature

SharePoint Collaboration in Word 2007

Upload a Word document to SharePoint

Working with HTML in Word 2007

Save a document as a web page

Set options for saving a Word document as a web page

Creating Blogs in Word 2007

Recognize how to get a blog account

Create a blog post

Back to List

Mentoring Using Word 2007

Overview/Description
SkillSoft Mentors are available to help students with their studies for the Using Word 2007 exam. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.

Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.

Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.

Expected Duration (hours)
0.0

Lesson Objectives

Mentoring Using Word 2007

Creating and Customizing Documents

Formatting Content

Working with Visual Content

Organizing Content

Reviewing Documents

Sharing and Securing Content

Course Number:
mntwd2007 <
Back to List

TestPrep Using Word 2007

Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.

Target Audience
Individuals seeking practice in a structured testing environment, covering the skills and competencies being measured by the vendor certification exam.

Prerequisites
The associated SkillSoft certification content should be completed before attempting this TestPrep. This will maximize the effectiveness of the preparation exam.

Expected Duration (hours)
0.0

Lesson Objectives

TestPrep Using Word 2007

Creating and Customizing Documents

Formatting Content

Working with Visual Content

Organizing Content

Reviewing Documents

Sharing and Securing Content

Course Number:
TPWD2007_eng <
Back to List

Exam 77-602: MOS: Using Microsoft Office Excel 2007 Curriculum Outline

Getting Started with Excel 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007.

Expected Duration

1.50 Hours

Objectives :

Spreadsheets and Excel 2007

Match basic Excel 2007 features with their functions

Recognize how to use the Help feature in a given scenario

Create and Navigate Workbooks in Excel 2007

Create a new Excel workbook in a given scenario

Open an existing Excel workbook in a given scenario

Navigate through an Excel workbook

Enter Data and Text in Excel 2007

Enter data in an Excel worksheet in given scenario

Save Work in Excel 2007

Save a new workbook

Distinguish between the common file formats used to save work in Excel 2007

Back to List

Manipulating and Formatting Data and Worksheets

Target Audience

Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007.

Expected Duration

3.50 Hours

Objectives :

Copy and Move Data in Excel 2007

Copy or move data in given scenarios

Modify Rows and Columns in Excel 2007

Add, delete, or resize rows and columns in a given scenario

Modify rows and columns to view specific sections of the worksheet

Insert and Modify Worksheets in Excel 2007

Format workbooks in given scenarios

Insert and delete a worksheet

Rename a worksheet and format the tab color

Copy or move worksheets

Format Data in Excel 2007

Apply basic data formatting

Format a data range as a table

Change the position of data in a cell in a given scenario

Identify the functions of Alignment commands

Format Data as a Table in Excel 2007

Work with tables in Excel 2007

Format a data range as a table

Modify an Excel table

Format Numbers in Excel 2007

Apply number formats in a given scenario

Identify the number formatting options available in Excel 2007

Conditional Formatting in Excel 2007

Apply basic conditional formatting rules in a given scenario

Recognize situations when conditional formatting is suitable

Back to List

Reviewing and Printing in Excel 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007

Expected Duration

1.50 Hours

Objectives :

Excel 2007 Review Features

Use Excel 2007 review tools in a given situation

Work with comments

Use the track changes tool

Prepare an Excel 2007 Worksheet for Printing

Customize page setup using the Page Layout View

Adjust page breaks using the Page Break Preview

Print Options in Excel 2007

Print a worksheet in a given scenario

Back to List

Excel 2007 Formulas and Functions

Target Audience

Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007.

Expected Duration

2.25 Hours

Objectives :

Basics of Formulas and References in Excel 2007

Identify the elements of a formula

Identify the default order in which calculations occur

Match absolute, relative, mixed, and 3-D references with examples

Insert Formulas in Excel 2007

Insert an Excel 2007 formula

Use names to clarify formulas

Edit formulas

Perform AutoCalculate Functions in Excel 2007

Use the AutoCalculate feature to perform basic functions

Logical, Financial, and Date Functions in Excel 2007

Use a logical function

Use a financial function

Use a date function

Back to List

Excel 2007 Charts, Pictures, Themes, and Styles

Target Audience

Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007

Expected Duration

1.50 Hours

Objectives :

Using Charts in Excel 2007

Insert an Excel 2007 chart

Identify the main elements of a chart

Updating Charts in Excel 2007

Change Excel 2007 charts

Change the data range included in the chart

Move a chart to a new worksheet

Insert Illustrations in Excel 2007

Insert illustrations in Excel 2007

Use Excel 2007 Themes and Styles

Apply a theme

Apply a cell style

Back to List

Advanced Formatting in Excel 2007

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at Expert level or an equivalent.

Expected Duration

2.50 Hours

Objectives :

Format Charts in Excel 2007

Format chart elements in Excel 2007

Identify Chart Tools commands for customizing chart elements

Save and apply a chart template

Modify Pictures in Excel 2007

Use the Adjust formatting commands to modify a picture

Recognize the commands for formatting a pictures style

Format a pictures size and properties

Create and Edit Excel 2007 Custom Number Formats

Create a custom number format

Identify codes for custom number formats

Use Advanced Conditional Formatting in Excel 2007

Create a new conditional formatting rule

Recognize how conditional formatting cell precedence works

Find cells that have conditional formats

Back to List

Advanced Data Management in Excel 2007

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at Expert level or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Sorting and Filtering Data in Excel 2007

Sort data

Filter data in a range or table

Subtotal, Group, and Outline Data in Excel 2007

Group and outline data

Insert subtotals in a worksheet

Display different levels of data using outlines

Validate Data in Excel 2007

Specify the data that is allowed in a particular range

Recognize which error alert to use in given examples

Audit and Correct Formulas in Excel 2007

Locate and correct formula errors

Use the Watch Window to audit formulas

Back to List

Advanced Customization in Excel 2007

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at Expert level or an equivalent.

Expected Duration

2.00 Hours

Objectives :

Creating Templates in Excel 2007

Create an Excel template

Customizing Themes and Styles in Excel 2007

Create new cell styles in Excel 2007

Customize Excel 2007 themes

Customizing Workbook Settings in Excel 2007

Customize workbook settings

Change the workbook properties

Record and Run an Excel 2007 Macro

Record and run a macro

Match macro security settings with their effects

Work with Excel Macros

Edit and delete macros

Assign a button to a macro and add it to the Quick Access Toolbar

Back to List

Analyzing Data in Excel 2007

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level or an equivalent.

Expected Duration

3.50 Hours

Objectives :

PivotTable Reports in Excel 2007

create a PivotTable report

rearrange PivotTable data

Excel 2007s PivotTable Tools

customize PivotTable reports

modify the look and feel of a PivotTable report

PivotChart Reports in Excel 2007

create a PivotChart report

modify a PivotChart report

Calculations in Excel 2007 PivotTables Reports

perform calculations in PivotTables reports

recognize when to use each calculation type

Work with Goal Seek and Solver in Excel 2007

use Goal Seek to perform data analysis

use Solver to perform data analysis

Create Scenarios in Excel 2007

create scenarios for what-if analysis

use the Scenario Manager to modify scenarios

Create a Data Table and Project Values in Excel 2007

create a one-variable data table for data analysis

create a two-variable data table for data analysis

project values in a series

Use Advanced Functions in Excel 2007

perform advanced functions

match advanced functions with examples of when you would use them

consolidate data from different workbooks using a Summary function

Back to List

Protecting and Sharing Excel 2007 Workbooks

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level or an equivalent.

Expected Duration

2.00 Hours

Objectives :

Worksheet and Workbook Protection in Excel 2007

protect a workbook in a given example

apply worksheet protection in a given example

Authenticate Workbooks with Excel 2007

identify the features of digital signatures in Excel 2007

Share Workbooks in Excel 2007

share workbooks on a network location

merge shared workbooks

Publish Excel 2007 Workbooks to SharePoint

publish a workbook to a SharePoint library

perform basic actions using SharePoint

Back to List

Exchanging Data with Excel 2007

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level or an equivalent.

Expected Duration

2.50 Hours

Objectives :

Link, Import, and Embed Data in Excel 2007

create links to data

identify how to import data

embed a file in a workbook

Create Database Queries in Excel 2007

create database queries in Excel 2007

import an entire Access table

Import Excel 2007 Data into Other Applications

import Excel data into Access

copy Excel data to Word

import Excel data into Outlook

Introduction to XML in Excel 2007

identify how XML works in Excel

recognize the components of a basic XML system

Work with XML Data in Excel 2007

create an XML map and map elements to it

import XML data

export XML data into mapped cells

Back to List

Exam 77-603: MOS: Using Microsoft Office PowerPoint 2007 Curriculum Outline

Getting Started with PowerPoint 2007

Target Audience

End User

Expected Duration

1.0 Hour

Objectives :

First Steps in PowerPoint 2007

recognize the functions of elements of the PowerPoint screen

recognize the steps for adding a command to the Quick Access Toolbar

Creating Your First Presentation in PowerPoint 2007

create a basic presentation in PowerPoint 2007

format content in a PowerPoint presentation

add slides to a presentation

change the layout of a PowerPoint slide

Using Views in PowerPoint 2007

change the default view in PowerPoint 2007

match PowerPoint views with their descriptions

Using the Help Features in PowerPoint 2007

search online Help in PowerPoint

Back to List

Adding Graphics to Presentations in PowerPoint 2007

Target Audience

End User

Expected Duration

1.5 hours

Objectives :

Using Themes in PowerPoint 2007

apply a theme to a presentation in PowerPoint 2007

customize a theme in a PowerPoint 2007 presentation

Inserting Objects in PowerPoint 2007

insert objects in PowerPoint presentations

SmartArt graphics in PowerPoint 2007

modify the appearance of PowerPoint slides using SmartArt graphics

Creating Charts and Tables in PowerPoint 2007

add a chart or a table in PowerPoint

modify the data in an embedded chart

Formatting Charts and Tables in PowerPoint 2007

change the appearance of a PowerPoint chart

modify the appearance of a PowerPoint table

Back to List

Adding Multimedia and Animations to Presentations

Target Audience

End User

Expected Duration

1.0 hours

Objectives :

Inserting Multimedia in PowerPoint 2007

insert a multimedia clip in a presentation

insert a sound clip in PowerPoint

Animating Slide Content in PowerPoint 2007

animate an object in PowerPoint

Specifying Slide Transitions in PowerPoint 2007

specify a transition for a slide in PowerPoint

recognize the options for transitioning between slides in a presentation

Adding Navigation Elements in PowerPoint 2007

identify the ways to enhance navigation in a PowerPoint presentation

add a hyperlink to a slide

add an action button to a slide

Back to List

Creating Custom Slide Shows in PowerPoint 2007

Target Audience

Office personnel at all levels; those wishing to become familiar with PowerPoint 2007.

Expected Duration

0.5 Hour

Objectives :

Creating Custom Slide Shows in PowerPoint 2007

customize a PowerPoint slide show

hide a slide in a custom slide show

Delivering Slide Shows in PowerPoint 2007

identify the options for writing on a slide during a presentation

turn on presenter view

create a self-running presentation

Back to List

Distributing Presentations in PowerPoint 2007

Target Audience

Office personnel at all levels; those wishing to become familiar with PowerPoint 2007.

Expected Duration

0.5 Hour

Objectives :

Securing and Printing Presentations in PowerPoint 2007

secure a presentation in PowerPoint 2007

print a PowerPoint slide show

Distributing Presentations in PowerPoint 2007

distribute a PowerPoint presentation

Back to List

Exam 77-604: MOS: Using Microsoft Office Outlook 2007 Curriculum Outline

Getting Started with Outlook 2007

Target Audience

End User

Expected Duration

1.50 Hours

Objectives :

First Steps in Outlook 2007

Launch Outlook 2007

Recognize how incoming e-mail messages are displayed in the Inbox

Recognize Outlook window features and their functions

Creating an E-mail Message in Outlook 2007

Create a new e-mail message

Viewing Incoming E-mails and Replying in Outlook 2007

Preview an incoming e-mail message

View an e-mail message in the Inbox using the Reading Pane

View an incoming e-mail message in a separate window

Reply to an e-mail message

Basic Help Features in Outlook 2007

Get help using the Browsing categories feature, given a scenario

Get help using the Searching feature, given a scenario

Get help using the Table of Contents feature, given a scenario

Back to List

Formatting and Managing E-mail in Outlook 2007

Target Audience

End User

Expected Duration

1.50 Hours

Objectives :

E-mail Formatting in Outlook 2007

Format an e-mail message, given a scenario

Apply stationery and themes to an e-mail message, given a scenario

Signatures and AutoReplies in Outlook 2007

Create a signature for an e-mail message in a given scenario

Create an auto-reply in a given scenario

E-mail Options in Outlook 2007

Set up a Read and Delivery receipt in a given scenario

Recall an e-mail message in a given scenario

Add voting buttons to an e-mail message in a given scenario

Respond to a poll in an e-mail message, given a scenario

E-mail Attachments in Outlook 2007

Add an attachment to an e-mail message in a given scenario

Preview an e-mail attachment in a given scenario

Edit an e-mail attachment in a given scenario

Color Coding and Flagging E-mail in Outlook 2007

Use color coding to organize e-mail messages in the Inbox, given a scenario

Use color categories to organize e-mail messages in the Inbox, given a scenario

Add a flag to an e-mail message in a given scenario

E-mail Arrangement Options in Outlook 2007

Arrange e-mail messages in the Inbox using the View menu, given a scenario

Use the Search Folders feature to view different types of e-mail messages in the Inbox, given a scenario

Use the Inbox column headings to arrange e-mail messages, given a scenario

Arrange read and unread e-mail messages in the Inbox, given a scenario

Back to List

Using the Calendar in Outlook 2007

Target Audience

End User

Expected Duration

2.00 Hours

Objectives :

Introduction to the Outlook 2007 Calendar

Configure how the Calendar is displayed, given a scenario

Appointments and Events in Outlook 2007

Schedule an appointment directly in the Calendar, given a scenario

Schedule an appointment using the appointment form, given a scenario

Schedule an appointment from an e-mail message attachment, given a scenario

Scheduling Meetings in Outlook 2007

Use the Meeting Requests feature to schedule a meeting, given a scenario

Use the Plan a Meeting feature to schedule a meeting, given a scenario

Recognize how to change an appointment to a meeting, given a scenario

Managing Meetings in Outlook 2007

Respond to a meeting request in a given scenario

Change a meeting request in a given scenario

Track a meeting in a given scenario

Cancel a meeting in a given scenario

Updating and Repeating Calendar Entries in Outlook 2007

Edit Calendar entries in a given scenario

Create a recurring Calendar entry in a given scenario

Change an existing Calendar entry to a recurring entry in a given scenario

Edit a recurring entry in a given scenario

Customizing the Outlook 2007 Calendar

Customize the calendar using the Calendar Options dialog box, given a scenario

Customize calendar entries by applying color to them, given a scenario

Customize the To-Do bar, given a scenario

Customize the calendar by creating additional calendars, given a scenario

Back to List

Using Contacts, Tasks, Notes, and Customizing the Interface in Outlook 2007

Target Audience

End User

Expected Duration

2.75 Hours

Objectives :

Creating Contacts in Outlook 2007

Create a new contact using the New Contact feature, given a scenario

Create a distribution list, given a scenario

Recognize how to create a contact from an e-mail that you receive

Recognize how to create multiple contacts from the same company

Viewing and Using Contacts in Outlook 2007

View your contacts, given a scenario

Perform tasks using your contacts, given a scenario

Send a contact as an electronic business card, given a scenario

Creating Tasks in Outlook 2007

Create a task, given a scenario

Recognize how to view your tasks

Recognize how to update a task, given a scenario

Managing Tasks in Outlook 2007

Assign a task, given a scenario

Reclaim an assigned task that has been rejected

Track a task that you have assigned, given a scenario

Recognize the different ways to display tasks

Using Notes in Outlook 2007

Create a note, given a scenario

Customize a note, given a scenario

Recognize how to change the view of the Notes folder

Customization of the Outlook 2007 Interface

Customize Outlook Today for the Outlook interface, given a scenario

Add folders to Favorite Folders, given a scenario

Work with shortcuts, given a scenario

Customize the Navigation Pane, given a scenario

Back to List

Completing Searches, Printing Items, and Working with RSS Feeds in Outlook 2007

Target Audience

End User

Expected Duration

1.50 Hours

Objectives :

Organizing and Sharing Folders in Outlook 2007

Create a private folder with permission for other users to access it, given a scenario

Create a public folder with permission to share it with other users, given a scenario

Move items between private and public folders, given a scenario

Searches and Search Folders in Outlook 2007

Recognize how to perform a basic search using Instant Search

Recognize how to perform an advanced search using Instant Search

Create a Search Folder, given a scenario

Printing Items in Outlook 2007

Print Outlook items, given a scenario

RSS Feeds in Outlook 2007

Add an RSS Feed, given a scenario

Read an RSS Feed, given a scenario

Cancel an RSS Feed, given a scenario

Back to List

Customizing Views, Tracking Items, and Adding E-Mail Accounts to Outlook 2007

Target Audience

Personnel at all levels of the enterprise; end users seeking competency in the use of Microsoft Office Outlook 2007.

Expected Duration

1.50 Hours

Objectives :

Customizing Views in Outlook 2007

Create a new view in Outlook 2007

Customize an Outlook 2007 view

Customizing Menus and Toolbars in Outlook 2007

Create a custom toolbar

Recognize how to customize menus and toolbars

Customize the Quick Access toolbar

Configuring E-mail Accounts in Outlook 2007

Add a new e-mail account to Outlook 2007

Change e-mail account settings in Outlook 2007

Remove an e-mail account in a given scenario

The Journal in Outlook 2007

Record a Journal entry in a given scenario

Recognize how to open and configure the Journal

Use the timeline to change the start and end date of a Journal entry in a given scenario

Back to List

Configuring Rules, Alerts, and Junk E-mail Settings in Outlook 2007

Target Audience

Personnel at all levels of the enterprise; end users seeking competency in the use of Microsoft Office Outlook 2007.

Expected Duration

1.50 Hours

Objectives :

Filtering E-mail Using Rules in Outlook 2007

Create a rule from a template in a given scenario

Create a rule from a message in a given scenario

Run a rule manually in a given scenario

Modify a rule in a given scenario

Out of Office Assistant and Public Folder Rules

Create a rule for the Out of Office Assistant in a given scenario

Add a rule to a public folder in a given scenario

Using Alerts in Outlook 2007

Switch on desktop alerts in a given scenario

Extend the onscreen duration of a desktop alert in a given scenario

Set up an alert for a SharePoint library in a given scenario

Introducing the Junk E-mail Filter in Outlook 2007

Recognize how the Junk E-mail Filter works

Recognize the functions of the filter lists

Controlling Junk E-mail in Outlook 2007

Set the level of junk e-mail protection to low in a given scenario

Add e-mail addresses to the Safe Senders and Blocked Senders lists in a given scenario

Mark an e-mail as not junk in a given scenario

Empty the Junk E-mail folder in a given scenario

Back to List

Working with SharePoint, Calendars, and Forms in Outlook 2007

Target Audience

Personnel at all levels of the enterprise; end users seeking competency in the use of Microsoft Office Outlook 2007.

Expected Duration

0.50 Hour

Objectives :

Working with SharePoint Files in Outlook 2007

Connect to a SharePoint library from Outlook in a given scenario

Open a SharePoint file from Outlook in a given scenario

Disconnect Outlook from SharePoint in a given scenario

Managing SharePoint Tasks and Contacts in Outlook 2007

Create an Outlook task for a SharePoint site in a given scenario

Add an event to a SharePoint calendar from Outlook in a given scenario

Add a SharePoint contact to Outlook in a given scenario

Creating and Using a Group Schedule in Outlook 2007

Create a group schedule in a given scenario

Display the group schedule for times outside working hours in a given scenario

Send a meeting request message from a group schedule in a given scenario

Using Internet Calendars in Outlook 2007

Add an Internet Calendar subscription to Outlook in a given scenario

Publish a calendar to Microsoft Office Online in a given scenario

Sharing the Calendar in Outlook 2007

Open another persons calendar in a given scenario

Add a delegate in a given scenario

Introduction to Forms in Outlook 2007

Choose a form in a given scenario

Creating and Publishing Forms in Outlook 2007

Create a form in a given scenario

Modify a form action in a given scenario

Test and publish a form to a library in a given scenario

Back to List

Data Security, Archiving, and Working Offline in Outlook 2007

Target Audience

Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2007.

Expected Duration

2.50 Hours

Objectives :

Setting Security Options in Outlook 2007

disable add-ins in a given scenario

disable all macros except digitally signed ones in a given scenario

add someone to the Trusted Publishers list in a given scenario

Using Digital Certificates in Outlook 2007

get a digital ID in a given scenario

digitally sign an e-mail, given a scenario

back up a digital ID in a given scenario

use an encrypted e-mail message

Archiving Data and Managing the Mailbox Size in Outlook 2007

specify the frequency of AutoArchive in a given scenario

Manually archive Outlook 2007 items in a given scenario

set AutoArchive options for a specific folder in a given scenario

clean up your mailbox in a given scenario

Using Data Files in Outlook 2007

create a Personal Folders file in a given scenario

change the data file where content is saved in a given scenario

open a Personal Folders file in a given scenario

Configuring Remote Connections in Outlook 2007

set up remote connections to Outlook in a given scenario

access your e-mail via Outlook Web Access in a given scenario

Working offline with Exchange

configure a Cached Exchange mode setting in a given scenario

set up a prompt to work offline in a given scenario

Using Send/Receive Groups and Remote Mail

create a Send/Receive group in a given scenario

download the offline address book in a given scenario

filter the items that are downloaded to your offline folders in a given scenario

process Remote Mail headers in a given scenario

Back to List

IRM, Instant, Text, and Unified Messaging in Outlook 2007

Target Audience

Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2007.

Expected Duration

0.50 Hour

Objectives :

Instant and Text Messaging from Outlook 2007

turn on instant message online status in Outlook in a given scenario

create and send a text message in a given scenario

forward an Outlook item as a text message in a given scenario

Unified Messaging in Outlook 2007

configure Unified Messaging in a given scenario

play a voice message on a telephone in a given scenario

Back to List

Business Contact Manager with Outlook 2007

Target Audience

Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2007.

Expected Duration

2.00 Hours

Objectives :

Getting Started with Business Contact Manager

distinguish the types of records used in BCM

recognize the functions of BCM interface elements

Configuring Accounts, Contacts, and Opportunities

create an Account in BCM in a given scenario

create a new business contact for an account in a given scenario

create an opportunity in a given scenario

Creating Marketing Campaigns and Business Projects

create a Marketing Campaign in a given scenario

track the results of a Marketing Campaign in a given scenario

create a business project in a given scenario

Generating Linked Items for BCM Records

link an account to an opportunity in a given scenario

link a file to an account in a given scenario

link a phone log to a record in a given scenario

Managing Linked Items in BCM

view a communication history in a record in a given scenario

link an item to more than one record in a given scenario

move a link to another record in a given scenario

auto-link an e-mail message to a record in a given scenario

Using Reports in BCM

create a report in a given scenario

export a report in a given scenario

launch a Marketing Campaign from a report

Protecting and Sharing Data in BCM

select a new database for your profile in a given scenario

delete and restore a database in a given scenario

export data from a database in a given scenario

Back to List

Exam 77-605: MOS: Using Microsoft Office Access 2007 Curriculum Outline

Getting Started with Access 2007

Target Audience

End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Plan an Access 2007 Database

plan a database

Get Started with Access 2007

match the main elements of the Access 2007 screen with their functions

use Access Help

Create Databases in Access 2007

create a database from scratch

create a database from a template

Components and Views of an Access 2007 Database

add a blank datasheet to a database

use views

Back to List

Basic Access 2007 Tables

Target Audience

End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Creating Tables in Access 2007

create a table from a template in a given scenario

identify the elements in an Access 2007 table

identify the table templates

Using the Design and Datasheet Views in Access 2007

create a table using Datasheet view

create a table using Design view

Modifying Tables in Access 2007

modify a table

modify a table in Design view

create a validation rule

Using Masked Input Fields and Indexing in Access 2007

create a masked input field in a table

apply indexing to a table

Manipulating Data in Records in Access 2007

view, edit, and navigate records

sort and filter data

find and replace data

print records

Setting up Relationships between Access 2007 Tables

create a relationship

Back to List

Basic Access 2007 Forms

Target Audience

End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Create Forms in Access 2007

create a form in Access 2007

Add and Configure Controls in Access 2007

add controls to Access 2007 forms

configure controls on an Access 2007 form

Create and Configure Bound Controls in Access 2007

bind controls to a field in Access 2007

configure bound controls in Access 2007

Customizing and Formatting Forms in Access 2007

customize forms in Access 2007

format forms in Access 2007

Creating and Managing Records in Access 2007

create and modify records

navigate between Access 2007 records

sort and filter Access 2007 records

Back to List

Queries and Reports in Access 2007

Target Audience

End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.

Expected Duration

2.00 Hours

Objectives :

Create Queries in Access 2007

create a simple query in design view

create a simple query using the Simple Query Wizard

Refine a Query in Access 2007

modify a query in Access 2007

create an expression with the Expression Builder

Add Calculations to a Query in Access 2007

use calculated fields and grouping in Access 2007

Crosstab Queries in Access 2007

create a crosstab query in Access 2007

refine a crosstab query in Access 2007

Unmatched and Duplicate Queries in Access 2007

find unmatched queries in Access 2007

find duplicate queries in Access 2007

Creating and Using Reports in Access 2007

create a basic report in Access 2007

Adding Controls to Access 2007 Reports

add a control to an Access 2007 report

Organizing Access 2007 Reports

recognize how to modify Access 2007 reports

add a group and calculated summary to a report in Access 2007

Back to List

Importing and Exporting Data and Data Presentation in Access 2007

Target Audience

Anyone wishing to become familiar with Microsoft Access 2007 at an advanced level; anyone seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; anyone seeking to obtain Microsoft Application Professional certification.

Expected Duration

1.50 Hours

Objectives :

Import Data into Access 2007

import data into an Access 2007 database

distinguish between the options available for importing data into Access 2007

Export Data from Access 2007

export Access 2007 data

distinguish between the formats you can export to from Access 2007

Collect Data Using E-mail Messages

set up data collection in Access 2007

collect data by using e-mail messages

Create and modify a PivotTable in Access 2007

build an Access 2007 PivotTable

modify a PivotTable in Access 2007

Create and Modify a PivotChart in Access 2007

build a PivotChart in Access 2007

modify an Access 2007 PivotChart

Back to List

Advanced Data Management in Access 2007

Target Audience

Anyone wishing to become familiar with Microsoft Access 2007 at an advanced level; anyone seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; anyone seeking to obtain Microsoft Application Professional certification.

Expected Duration

2.50 Hours

Objectives :

Retrieve Related Data in Access 2007

add a lookup field to an Access 2007 table

add a subdatasheet to a table

Working with the Attachment Feature in Access 2007

add attachments to Access 2007 records

Validate Data in Access 2007

implement data validation in Access 2007

Use Subforms, Subreports, and Conditional Formatting in Access 2007

add Subforms to an Access 2007 database

add Subreports to an Access 2007 database

apply conditional formatting to a form in Access 2007

Joins and Parameter Queries in Access 2007

create and edit joins in Access 2007 databases

create and use simple parameter queries

Action Queries in Access 2007

create and run update and append queries in Access 2007

create and run a make table query

delete data from an Access 2007 database

Access 2007 Queries and SQL

create union queries in Access 2007

recognize how to create or modify Access 2007 tables and indexes using data-definition queries

perform SQL processing on a server

edit the SQL of a SELECT query and use subqueries

Back to List

Programmability and Administration in Access 2007

Target Audience

Anyone wishing to become familiar with Microsoft Access 2007 at an advanced level; anyone seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; anyone seeking to obtain Microsoft Application Professional certification.

Expected Duration

1.50 Hours

Objectives :

Introducing SharePoint and Access 2007

determine how to move data to a SharePoint site

specify how to publish data to a SharePoint site

Working with Access 2007 and SharePoint Lists

create an Access view of a SharePoint list

work with SharePoint lists

Working Offline and Tracking Access 2007 Data

take SharePoint list data offline

work offline and track data in Access 2007

Use Macros in Access 2007

create and edit Access 2007 macros

run Access 2007 macros

VBA in Access 2007

use VBA to create an event handler in Access 2007

work with event handlers in Access 2007

Back to List

Database Administration in Access 2007

Target Audience

Anyone wishing to become familiar with Microsoft Access 2007 at an advanced level; anyone seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; anyone seeking to obtain Microsoft Application Professional certification.

Expected Duration

2.00 Hours

Objectives :

Personalize Access 2007

customize datasheets in Access 2007

Access 2007 Maintenance and Management

recognize how to compact and repair a database

illustrate how to convert earlier Access database formats to Access 2007

specify how to back up databases and restore database files

Optimize Access 2007 Database performance

outline how to view and change object dependencies in Access 2007

illustrate how to analyze objects for performance

outline how to use the database documenter and the Table Analyzer wizard to optimize database performance

Secure Database Information in Access 2007

identify how to enable content for an Access 2007 database

recognize how to hide a database object

Set a password and secure VB code in Access 2007

summarize how to encrypt a database by setting a database password

restate how to protect VB code in Access 2007

Share a Database in Access 2007

determine how to split a database and repair database links

use an Office Access 2007 database in a trusted location

restate how to package, sign, and distribute an Office Access 2007 database

Create a Switchboard in Access 2007

outline how to work with switchboards and the Navigation Pane

outline how to create a custom group and add objects to it

Back to List