Access 2002 Core

MOUS Exam Objectives

Posted: January 21, 2002
 
Exam objectives are categories of examination tasks, identified by subject-matter experts, that certify an ability to productively use Microsoft Office programs. These categories are organized into skill sets representing the more basic functions of each Office program. Exam objectives and skill sets for the Microsoft Access 2002 Core Exam are provided below to assist in your exam preparation. Training centers and courseware providers authorized by the Microsoft Office User Specialist (MOUS) program tailor their instruction to these criteria.

Creating and Using Databases

  • Create Access databases
  • Open database objects in multiple views
  • Move among records
  • Format datasheets

Creating and Modifying Tables

  • Create and modify tables
  • Add a predefined input mask to a field
  • Create Lookup fields
  • Modify field properties

Creating and Modifying Queries

  • Create and modify Select queries
  • Add calculated fields to Select queries

Creating and Modifying Forms

  • Create and display forms
  • Modify form properties

Viewing and Organizing Information

  • Enter, edit, and delete records
  • Create queries
  • Sort records
  • Filter records

Defining Relationships

  • Create one-to-many relationships
  • Enforce referential integrity

Producing Reports

  • Create and format reports
  • Add calculated controls to reports
  • Preview and print reports

Integrating with Other Applications

  • Import data to Access
  • Export data from Access
  • Create a simple data access page