clogo.gif (12135 bytes)

Microsoft Access 2002 Exam Objectives

This page describes how to prepare for the Microsoft® Office Specialist exam in Microsoft Access 2002. 

There is only one level for Access 2002. The table below lists specific activities to attain Core level status.

Access 2002 Core Exam Objectives

Skill Sets Activities
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
 

Return Home

 Services & Pricing | Our Classes
  Contact Us | Site Map