Access Exam

ACCESS EXAM OBJECTIVES:

MY STATUS: NOT TAKEN YET

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