Microsoft Office Specialist Exam Skill Standards: Access 2003
Microsoft Office Access 2003
Published: January 11, 2006
| Skill Sets |
Exam Skill Standards |
|
Structuring Databases
|
| • |
Create Microsoft Access databases
|
| • |
Create and modify tables
|
| • |
Define and modify field types
|
| • |
Modify field properties
|
| • |
Create and modify one-to-many relationships
|
| • |
Enforce referential integrity
|
| • |
Create and modify queries
|
| • |
Create forms
|
| • |
Add and modify form controls and properties
|
| • |
Create reports
|
| • |
Add and modify report control properties
|
| • |
Create a data access page
|
|
|
Entering Data
|
| • |
Enter, edit, and delete records
|
| • |
Find and move among records
|
| • |
Import data to Access
|
|
|
Organizing Data
|
| • |
Create and modify calculated fields and aggregate functions
|
| • |
Modify form layout
|
| • |
Modify report layout and page setup
|
| • |
Format datasheets
|
| • |
Sort records
|
| • |
Filter records
|
|
|
Managing Databases
|
| • |
Identify object dependencies
|
| • |
View objects and object data in other views
|
| • |
Print database objects and data
|
| • |
Export data from Access
|
| • |
Back up a database
|
| • |
Compact and repair databases
|
|
|