Microsoft Office Specialist Exam Skill Standards: Access 2002 Core
Creating and Using Databases
- Create Microsoft Access databases
- Open database objects in multiple views
- Move among records
- Format datasheets
Creating and Modifying Tables
- Create and modify tables
- Add a predefined input mask to a field
- Create Lookup fields
- Modify field properties
Creating and Modifying Queries
- Create and modify Select queries
- Add calculated fields to Select queries
Creating and Modifying Forms
- Create and display forms
- Modify form properties
Viewing and Organizing Information
- Enter, edit, and delete records
- Create queries
- Sort records
- Filter records
Defining Relationships
- Create one-to-many relationships
- Enforce referential integrity
Producing Reports
- Create and format reports
- Add calculated controls to reports
- Preview and print reports
Integrating with Other Applications
- Import data to Access
- Export data from Access
- Create a simple data access page
Back to Microsoft Office Specialist Exams |
|
