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
|