Microsoft Access 2007
Level I   back to top

Course Content

Lesson 1: Exploring the Microsoft® Office Access™ 2007 Environment

Topic 1A: Examine Database Concepts
Topic 1B: Explore the User Interface
Topic 1C: Use an Existing Access Database
Topic 1D: Customize the Access Environment
Topic 1E: Obtain Help

Lesson 2: Designing a Database

Topic 2A: Describe the Relational Database Design Process
Topic 2B: Define Database Purpose
Topic 2C: Review Existing Data
Topic 2D: Determine Fields
Topic 2E: Group Fields into Tables
Topic 2F: Normalize Data
Topic 2G: Designate Primary and Foreign Keys
Topic 2H: Determine Table Relationships

Lesson 3: Building a Database

Topic 3A: Create a New Database
Topic 3B: Create a Table
Topic 3C: Manage Tables
Topic 3D: Create a Table Relationship
Topic 3E: Save a Database as a Previous Version

Lesson 4: Managing Data in a Table

Topic 4A: Modify Table Data
Topic 4B: Sort Records
Topic 4C: Work with Subdatasheets

Lesson 5: Querying a Database

Topic 5A: Filter Records
Topic 5B: Create a Query
Topic 5C: Add Criteria to a Query
Topic 5D: Add a Calculated Field to a Query
Topic 5E: Perform Calculations on a Record Grouping

Lesson 6: Designing Forms

Topic 6A: View Data Using an Access Form
Topic 6B: Create a Form
Topic 6C: Modify the Design of a Form

Lesson 7: Generating Reports

Topic 7A: View an Access Report
Topic 7B: Create a Report
Topic 7C: Add a Custom Calculated Field to a Report
Topic 7D: Format the Controls in a Report
Topic 7E: Apply an AutoFormat Style to a Report
Topic 7F: Prepare a Report for Print
 

Microsoft Access 2007

Level II   back to top

Course Content

Lesson 1: Controlling Data Entry

Topic 1A: Restrict Data Entry Using Field Properties
Topic 1B: Establish a Pattern for Entering Field Values
Topic 1C: Create a List of Values for a Field

Lesson 2: Joining Tables

Topic 2A: Create Query Joins
Topic 2B: Join Unrelated Tables
Topic 2C: Relate Data Within a Table

Lesson 3: Creating Flexible Queries

Topic 3A: Set Select Query Properties
Topic 3B: Create Parameter Queries
Topic 3C: Create Action Queries

Lesson 4: Improving Forms

Topic 4A: Design a Form Layout
Topic 4B: Enhance the Appearance of a Form
Topic 4C: Restrict Data Entry in Forms
Topic 4D: Add a Command Button to a Form
Topic 4E: Create a Subform

Lesson 5: Customizing Reports

Topic 5A: Organize Report Information
Topic 5B: Format the Report
Topic 5C: Set Report Control Properties
Topic 5D: Control Report Pagination
Topic 5E: Summarize Report Information
Topic 5F: Add a Subreport to an Existing Report
Topic 5G: Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

Topic 6A: Import Data into Access
Topic 6B: Export Data
Topic 6C: Analyze Access Data in Excel
Topic 6D: Export Data to a Text File
Topic 6E: Merge Access Data with a Word Document

Microsoft Access 2007

Level III   back to top

Course Content

Lesson 1: Structuring Existing Data

Topic 1A: Analyze Tables
Topic 1B: Create a Junction Table
Topic 1C: Improve Table Structure

Lesson 2: Writing Advanced Queries

Topic 2A: Create Subqueries
Topic 2B: Create Unmatched and Duplicate Queries
Topic 2C: Group and Summarize Records Using Criteria
Topic 2D: Summarize Data Using a Crosstab Query
Topic 2E: Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros

Topic 3A: Create a Macro
Topic 3B: Attach a Macro
Topic 3C: Restrict Records Using a Condition
Topic 3D: Validate Data Using a Macro
Topic 3E: Automate Data Entry Using a Macro

Lesson 4: Making Effective Use of Forms

Topic 4A: Display a Calendar on a Form
Topic 4B: Organize Information with Tab Pages
Topic 4C: Display a Summary of Data in a Form

Lesson 5: Making Reports More Effective

Topic 5A: Include a Chart in a Report
Topic 5B: Print Data in Columns
Topic 5C: Cancel Printing of a Blank Report
Topic 5D: Create a Report Snapshot

Lesson 6: Maintaining an Access Database

Topic 6A: Link Tables to External Data Sources
Topic 6B: Manage a Database
Topic 6C: Determine Object Dependency
Topic 6D: Document a Database
Topic 6E: Analyze the Performance of a Database

Microsoft Access 2003

Level I   back to top

Course Content

Lesson 1: Overview of Access 2003

Introduction to database concepts and terminology
An introduction to Access 2003
Database planning and design

Lesson 2: Creating tables

Examining a table
Creating a table with the Table Wizard
Creating a table in Design View
Types of primary keys

Lesson 3: Working with tables

Adding records
Modifying the table design
Finding and editing records
Deleting, adding, and copying records and values
Filtering and sorting records

Lesson 4: Using select queries

Selecting fields and sorting records
Refining the results of a query
Using queries to perform calculations
Joining tables in a query

Lesson 5: Creating and using forms

Creating a form
Modifying the form design
Using a form to locate and organize information
Multiple-table forms

Lesson 6: Creating and using reports

Creating a report
Creating a report that contains totals

Lesson 7: Creating and maintaining a database

Creating a database
Managing a database and its objects
Database maintenance

Microsoft Access 2003

Level II   back to top

Course Content

Lesson 1: Principles of table design

Normalizing data
Normalizing data for fourth and fifth normal forms

Lesson 2: Principles of table relationships

Analyzing table relationships
Establishing and testing referential integrity

Lesson 3: Table design techniques

Data validation techniques
Indexing techniques

Lesson 4: Designing select queries

Using calculated fields in queries
Creating multiple-table queries

Lesson 5: Customizing form designs

Customizing the form design
Performing calculations on a form
Adding combo boxes to a form
Adding unbound controls

Lesson 6: Working with data access pages

Creating data access pages

Lesson 7: Customizing reports
 
Customizing a report created by the Report Wizard
Working with subreports

Appendix A: Using the Chart Wizard
Creating a chart in a form or report

Appendix B: New features of Access
View information on object dependencies
Property update options

Microsoft Access 2003

Level III   back to top

Course Content

Lesson 1: Parameter and action queries

Creating parameter queries
Creating action queries

Lesson 2: Query joins and crosstab queries

Joining tables and working with join properties
Creating crosstab queries
Editing limitations in query datasheets

Lesson 3: Using advanced form techniques

Organizing field placement
Using functions to control data entry
Adding an option group to a form
Using a form as the user interface
Creating a form that contains a subform

Lesson 4: Creating basic macros to automate forms

Macro basics
Attaching a macro to a command button
Revising a macro
Attaching a macro to an event in a form

Lesson 5: Using macros to provide user interaction and automate tasks

Using a macro to provide user interaction
Using macros to automate data entry
AutoKeys and AutoExec macros

Lesson 6: Using advanced report techniques
 
Customizing the appearance and functionality of a report
Mailing and other types of labels