Microsoft Office Specialist Exam Objectives

Each Microsoft Office Specialist certification has a set of objectives, and each objective is organized into broader skill sets. To prepare for an Office Specialist certification exam, you should confirm that you can meet its respective objectives. This course will prepare you for the Microsoft Office Specialist exam for Microsoft Access 2002 at the Core level because it covers all the objectives associated with that examination.

The following table lists the objectives for the Microsoft Office Specialist Core Exam for Microsoft Access 2002, along with the course lessons and topics in which each of those objectives is addressed.

Office Specialist Objective

Description

Lesson

Topic

AC2002.1

Creating and Using Databases

AC2002.1.1

Create Access databases

Creating a New Database

Creating a New Database Structure

AC2002.1.2

Open database objects in multiple views

Getting to Know Access

Viewing Tables

Creating a New Database

Refining How Data Is Displayed

AC2002.1.3

Move among records

Creating a New Database

Checking the Work of a Wizard

AC2002.1.4

Format datasheets

Creating a New Database

Formatting Tables

AC2002.2

Creating and Modifying Tables

AC2002.2.1

Create and modify tables

Creating a New Database

Creating Tables

AC2002.2.2

Add a predefined input mask to a field

Keeping Your Information Accurate

Restricting Data with an Input Mask

AC2002.2.3

Create Lookup fields

Keeping Your Information Accurate

Restricting Data with a Lookup List

AC2002.2.4

Modify field properties

Creating a New Database

Refining How Data Is Displayed

Keeping Your Information Accurate

Restricting Data with an Input Mask

AC2002.3

Creating and Modifying Queries

AC2002.3.1

Create and modify Select queries

Locating Specific Information

Creating a Query with a Wizard

AC2002.3.2

Add calculated fields to Select queries

Locating Specific Information

Creating a Query in Design View

AC2002.4

Creating and Modifying Forms

AC2002.4.1

Create and display forms

Simplifying Data Entry with Forms

Creating a Form Using a Wizard

Creating a Form Using an AutoForm

AC2002.4.2

Modify form properties

Simplifying Data Entry with Forms

Refining Form Properties

Adding Controls to a Form

AC2002.5

Viewing and Organizing Information

AC2002.5.1

Enter, edit, and delete records

Creating a New Database

Checking the Work of a Wizard

Keeping Your Information Accurate

Restricting Data with the Data Type Setting

Deleting Records from a Table

AC2002.5.2

Create queries

Locating Specific Information

Creating a Query in Design View

AC2002.5.3

Sort records

Getting to Know Access

Viewing Tables

Locating Specific Information

Sorting Information in a Table

Locating Information Using Multiple Criteria

AC2002.5.4

Filter records

Getting to Know Access

Viewing Tables

Locating Specific Information

Filtering Information in a Table

Filtering Information By Form

Locating Information Using Multiple Criteria

AC2002.6

Defining Relationships

AC2002.6.1

Create one-to-many relationships

Simplifying Data Entry with Forms

Adding a Subform to a Form

AC2002.6.2

Enforce referential integrity

Keeping Your Information Accurate

Restricting Data with Validation Rules

AC2002.7

Producing Reports

AC2002.7.1

Create and format reports

Working With Reports

Creating a Report Using a Wizard

AC2002.7.2

Add calculated controls to reports

Working With Reports

Adding a Subreport to a Report

AC2002.7.3

Preview and print reports

Getting to Know Access

Viewing Reports

Working with Reports

Previewing and Printing a Report

AC2002.8

Integrating with Other Applications

AC2002.8.1

Import data to Access

Importing and Exporting Information

Importing Data from Excel

Importing Data from Text Files

Importing Data from an Access Database

Importing Data from Other Databases

Importing Data from an HTML File

AC2002.8.2

Export data from Access

Importing and Exporting Information

Exporting Data to Other Applications

AC2002.8.3

Create a simple data access page

Working with Pages

Creating a Data Access Page with AutoPage

Creating a Data Access Page with the Page Wizard