Lesson 1:
Getting to Know Access

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

Lesson 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

Lesson 3:
Building a Database

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

Lesson 4:
Managing Data in a Table

Modify Table Data, Sort Records, Work with Subdatasheets

Lesson 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

Lesson 6:
Designing Forms

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

Lesson 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

Lesson 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

Lesson 9:
Joining Tables

Create Query Joins, Join Unrelated Tables, Relate Data Within a Table

Lesson 10:
Creating Flexible Queries

Set Select Query Properties, Create Parameter Queries, Create Action Queries

Lesson 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

Lesson 12:
Customising 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

Lesson 13:
Sharing data Across Applications

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