Microsoft Access 2000 Exam Objectives

This page describes how to prepare for the Microsoft® Office Specialist exam in Microsoft Access 2000. There is a single designation level for Microsoft Access 2000; users are expected to be able to work with databases in individual and workgroup settings.

There is only one level for Access 2000. The table beginning on the following page lists specific activities to attain Expert level status.

• Determine appropriate data inputs for your database
• Determine appropriate data outputs for your database
• Create table structure
• Establish table relationships

• Use the Office Assistant
• Select an object using the Objects Bar
• Print database objects (tables, forms, reports, queries)
• Navigate through records in a table, query, or form
• Create a database (using a Wizard or in Design View)

• 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

• 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, detail)
• Use a Calculated Control on a form

• 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 multi-table select query

• Establish relationships
• Enforce referential integrity

• 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, detail)
• Use a Calculated Control in a report

• Import data to a new table
• Save a table, query, form as a Web page
• Publish a presentation to the Web
• Add Hyperlinks

• Print Database Relationships
• Backup and Restore a database
• Compact and Repair a database