This certification exam was developed based on a product task analysis that defined the skills required to use Microsoft Access to create simple queries, databases, and forms, and to create and print reports at a minimally competent level for a specialist-level user. This exam consists of 22 performance-based, multiple-task 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:15.6% Structuring Databases: define data needs and types; define and print; add, set, change, or remove primary keys table relationships; split databases.33.3% Creating and formatting database elements: create databases; create tables; modify tables; create fields and modify field properties; create forms; create reports; modify the design of a report or form; create reports.11.1% Entering and modifying data: enter, edit, and delete records; navigate among records; find and replace data.15.6% Creating and modifying queries: create queries; modify queries.15.6% Presenting and sharing data: sort data; filter data; create and modify charts; export data; save database objects as other file types; print database objects.8.8% Managing and maintaining databases: perform routine database operations; manage databases.