This certification exam was developed based on a product task analysis that defined the skills required to use Microsoft Access to manage the Access Environment, create tables, build forms, create and manage queries, and create reports at a minimally competent level for a specialist-level user. This exam consists of 34 performance-based exam items. Examinees are given 50 minutes to complete the exam, which is delivered using the live Microsoft Access application.
Approximate percentage of examination by content area:19% Managing the Access Environment: Create and manage a database; Configure the Navigation Pane; Apply Application Parts.23% Creating Tables: Create tables; Create and Modify Fields; Sort and Filter records; Set Relationships; Import Data from a Single Data File.19% Building Forms: Create Forms; Apply Form Design Tab Options; Apply Form Arrange Tab Options; Apply Form Format Tab Options.23% Creating and Managing Queries: Construct Queries; Manage Source Tables and Relationships; Manipulate Fields; Calculate Totals; Generate Calculated Fields.16% Creating Reports: Create reports; Apply Report Design Tab Options; Apply Report Arrange Tab Options; Apply Report Format Tab Options; Apply Report Page Setup Tab Options; Sort and Filter records for reporting.