Microsoft Office Specialist Exam Skill Standards: Access 2000 Core
Planning and Designing Databases
- Determine appropriate data inputs and outputs for your database
- Create table structure
- Establish table relationships
Working with Access
- Use the Microsoft Office Assistant
- Select an object using the Objects Bar
- Print database objects (tables, forms, reports, and queries)
- Move through records in a table, query, or form
- Create a database by using a wizard or the In-design View
Building and Modifying Tables
- Create tables by using the Table Wizard
- Set primary keys
- Modify field properties
- Use multiple data types
- Modify tables using Design View
- Use the Lookup Wizard
- Use the Input Mask Wizard
Building and Modifying Forms
- Create a form with the Form Wizard
- Use the Control Toolbox to add controls
- Modify Format Properties, such as font, style, font size, color, and caption of controls
- Use form sections (headers, footers, and detail)
- Use a Calculated Control on a form
Viewing and Organizing Information
- Use the Office Clipboard
- Switch between object views
- Enter records using a datasheet
- Enter records using a form
- Delete records from a table
- Find a record
- Sort records
- Apply and remove filters (filter by form and filter by selection)
- Specify criteria in a query
- Display related records in a subdatasheet
- Create a calculated field
- Create and modify a multitable select query
Defining Relationships
- Establish relationships
- Enforce referential integrity
Producing Reports
- Create a report by using the Report Wizard
- Preview and print a report
- Move and resize a control
- Modify Format Properties, such as font, style, font size, color, and caption
- Use the Control Toolbox to add controls
- Use report sections (headers, footers, and detail)
- Use a Calculated Control in a report
Integrating with Other Applications
- Import data to a new table
- Save a table, query, or form as a Web page
- Add hyperlinks
Using Access Tools
- Print database relationships
- Back-up and restore a database
- Compact and repair a database
Back to Microsoft Office Specialist Exams |
|
