Microsoft Office Specialist Exam Skill Standards: Access 2003 Core
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
Back to Microsoft Office Specialist Exams |
|
