Access Expert



Access Level 1

1 - Exploring the Microsoft® Office Access™ 2007 Environment

Examine Database Concepts Explore the User Interface Explore the Ribbon Customize the Access Environment Obtain Help Use an Existing Access Database

2 - Designing a Database

Describe the Relational Database Design Process Define Database Purpose Review Existing Data Determine Fields Group Fields into Tables Normalize Data Designate Primary and Foreign Keys Determine Table Relationships

3 - Building a Database

Create a New Database Create a Table Manage Tables Create a Table Relationship Save a Database as a Previous Version

4 - Managing Data in a Table

Modify Table Data Sort Records Work with Subdatasheets

5 - Querying a Database

Filter Records Create a Query Add Criteria to a Query Add a Calculated Field to a Query Perform Calculations on a Record Grouping

6 - Designing Forms

View Data Using an Access Form Create a Form Modify the Design of a Form

7 - Generating Reports

View an Access Report Create a Report Add a Custom Calculated Field to a Report Format the Controls in a Report Apply an AutoFormat to a Report Prepare a Report for Print

8 - Controlling Data Entry

Restrict Data Entry Using Field Properties Establish a Pattern for Entering Field Values Create a List of Values for a Field

9 - Joining Tables

Create Query Joins Join Unrelated Tables Relate Data Within a Table

10 - Creating Flexible Queries

Set Select Query Properties Create Parameter Queries Create Action Queries

11 - Improving Forms

Design a Form Layout Enhance the Appearance of a Form Restrict Data Entry in Forms Add a Command Button to a Form Create a Subform

12 - Customizing Reports

Organize Report Information Format the Report Set Report Control Properties Control Report Pagination Summarize Report Information Add a Subreport to an Existing Report Create a Mailing Label Report

13 - Sharing Data Across Applications

Import Data into Access Export Data Analyze Access Data in Excel Export Data to a Text File Merge Access Data with a Word Document



Access Level 2


 1 - Structuring Existing Data

Analyze Tables Create a Junction Table Improve Table Structure

2 - Writing Advanced Queries

Create Subqueries Create Unmatched and Duplicate Queries Group and Summarize Records Using Criteria Summarize Data Using a Crosstab Query Create a PivotTable and a PivotChart

3 - Simplifying Tasks with Macros

Create a Macro Attach a Macro Restrict Records Using a Condition Validate Data Using a Macro Automate Data Entry Using a Macro

4 - Making Effective Use of Forms

Display a Calendar on a Form Organize Information with Tab Pages Display a Summary of Data in a Form

5 - Making Reports More Effective

Include a Chart in a Report Print Data in Columns Cancel Printing of a Blank Report Create a Report Snapshot

6 - Maintaining an Access Database

Link Tables to External Data Sources Manage a Database Determine Object Dependency Document a Database Analyze the Performance of a Database



Access Level 3


1 - Integrating Access into Your Business

Import XML Data into an Access Database Export Access Data to XML Format Export Data to the Outlook Address Book Collect Data Through Email Messages

2 - Automating a Business Process with VBA

Create a Standard Module Develop Code Call a Procedure from a Form Run a Procedure

3 - Managing Switchboards

Create a Database Switchboard Modify a Database Switchboard Set the Startup Options

4 - Distributing and Securing Databases

Split a Database Implement Security Set Passwords Convert an Access Database to an ACCDE File Package a Database with a Digital Signature

5 - Sharing a Database Using a SharePoint Site

Export a Table to a SharePoint List Import Data from a SharePoint List Publish a Database to a SharePoint Site Move a Database to a SharePoint Site Work Offline