|
Skill Sets
|
Exam Objectives
|
|
Planning and Designing Databases
|
 | Determine appropriate data inputs for your database
| Determine appropriate data outputs for your database
| Create table structure
| Establish table relationships |
| | |
|
|
Working with Access
|
| Use the Office Assistant
| Select an object using the Objects Bar
| Print database objects (tables, forms, reports, queries)
| Navigate through records in a table, query, or form
| Create a database (using a Wizard or 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 (font, style, font size, color,
caption, etc.) of controls
| Use form sections (headers, footers, 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 multi-table select query |
| | | | | | | | | | |
|
|
Defining relationships
|
| Establish relationships
| Enforce referential integrity |
|
|
|
Producing reports
|
| Create a report with the Report Wizard
| Preview and print a report
| Move and resize a control
| Modify format properties (font, style, font size, color,
caption, etc.)
| Use the Control Toolbox to add controls
| Use report sections (headers, footers, detail)
| Use a Calculated Control in a report |
| | | | | |
|
|
Integrating with other applications
|
| Import data to a new table
| Save a table, query, form as a Web page
| Publish a presentation to the Web
| Add Hyperlinks |
| | |
|
|
Using Access Tools
|
| Print Database Relationships
| Backup and Restore a database
| Compact and Repair a database |
| |
|
