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, colour, caption, etc.) of controls
• Use form sections (headers, footers, detail)
• Use a Calculated Control on a form

Viewing and organising 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, colour, 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