Working With an Existing Database

Using Microsoft Access

3 Hours
Versions 2003 or 2007

Below is a pre-designed course for Working With an Existing Database.
This 3-hour course introduces users to Microsoft Access and demonstrates how to work with an existing database. Users will learn how to open and navigate tables, use forms to view information, update data, find information, modify existing queries and run reports.

Understanding the Basics of a Database

What is a Database?

Opening a Database

Important Screen Elements

Understanding the Main Database Objects

Working With Tables

Opening a Table

Navigating Through a Table

Adding New Records

Editing Information and Undoing Changes

Customizing the Datasheet

Deleting Records

Closing a Table

Using Forms to Enter Data

Opening a Form

Reviewing a Multi-table Form

Navigating Between Records on a Form

Adding Records

Deleting Records

Closing a Form

Finding, Sorting, and Filtering Records

Finding a Specific Record

Sorting Records

Filtering Records

Using Queries to Extract Information

Opening a Query

Modifying a Query

Saving and Closing a Query

Printing Results of a Query

Previewing Basic Reports

Opening or Modifying a Report

Printing Reports