Creating a New Database

Using Microsoft Access

3 Hours
Versions XP or 2003

Below is a pre-designed course for Creating a New Database.
This 3-hour course introduces users to Microsoft Access and demonstrates how to create new tables, data-entry forms, queries and reports.

Creating a Table

Creating a New Database

Creating New Tables and Defining Fields

Importing an Excel Spreadsheet

Creating New Tables

Opening a Table

Relating and Linking Tables

Entering Related Data into a Child Table

Creating Forms to Help Enter Data

Reviewing a Multi-table Form

Creating a Form Using the Form Wizard

Closing a Form

Opening a Form

Creating Queries to Extract Information

Building a Query

Specifying the Fields

Adding Fields

Writing Criteria in Yes/No Fields

Viewing or Running the Query

Saving and Closing a Query

Creating Basic Reports

Creating a Report Based on a Query

Modifying and Customizing Reports

Modifying Page Setup Options

Changing the Title of a Report

Is this the right course for you? Please contact our office at 202.682.4500 if you have any questions.