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 |
|
