Certification

Microsoft Certified Application Specialist Exam Skill Standards: Access 2007 (77-605)

Structuring a Database

• Define data needs and types.
• Define and print table relationships.
• Add, set, change, or remove primary keys.
• Split databases.

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 reports and forms.

Entering and Modifying Data

• Enter, edit, and delete records.
• Navigate among records.
• Find and replace data.
• Attach documents to and detach from records.
• Import data.

Creating and Modifying Queries

• Create queries.
• Modify queries.

Presenting and Sharing Data

• Sort data.
• Filter data.
• Create and modify charts.
• Export data.
• Save database objects as other file types.
• Print database objects.

Managing and Maintaining Databases

• Perform routine database operations.
• Manage databases.

Back to Microsoft Certified Application Specialist Exams