|
Exam objectives are categories of examination
tasks, identified by subject-matter experts, that certify an ability to
productively use Microsoft Office applications. These categories are
organized into skill sets representing the more basic functions of each
Office application.
Exam objectives and skill sets for the
Microsoft Access 2000 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.
Planning and Designing Databases
 | Determine appropriate data inputs/outputs
for your database
| Create table structure
| Establish table relationships |
| |
Working with Access
| Use the Microsoft Office Assistant
| Select an object using the Objects Bar
| Print database objects (tables, forms,
reports, and queries)
| Navigate through records in a table, query,
or form
| Create a database (using a wizard or
in-design view) |
| | | |
Building and Modifying Tables
| Create tables by using the Table Wizard
| Set primary keys
| Modify field properties
| Use multiple data types
| Modify tables using Design View
| Use the Lookup Wizard
| Use the Input Mask Wizard |
| | | | | |
Building and Modifying Forms
| Create a form with the Form Wizard
| Use the Control Toolbox to add controls
| Modify Format Properties (font, style, font
size, color, caption, etc.) of controls
| Use form sections (headers, footers, and
detail)
| Use a Calculated Control on a form |
| | | |
Viewing and Organizing Information
| Use the Office Clipboard
| Switch between object views
| Enter records using a datasheet
| Enter records using a form
| Delete records from a table
| Find a record
| Sort records
| Apply and remove filters (filter by form and
filter by selection)
| Specify criteria in a query
| Display related records in a subdatasheet
| Create a calculated field
| Create and modify a multitable select query |
| | | | | | | | | | |
Defining Relationships
| Establish relationships
| Enforce referential integrity |
|
Producing Reports
| Create a report with the Report Wizard
| Preview and print a report
| Move and resize a control
| Modify Format Properties (font, style, font
size, color, caption, etc.)
| Use the Control Toolbox to add controls
| Use report sections (headers, footers, and
detail)
| Use a Calculated Control in a report |
| | | | | |
Integrating with Other Applications
| Import data to a new table
| Save a table, query, or form as a Web page
| Add Hyperlinks |
| |
Using Access Tools
| Print database relationships
| Back-up and restore a database
| Compact and repair a database |
| |
|
