Contents

What is a Database?

What can a Database do?

Advantages of Using an Electronic Database

Launching Microsoft Access

File Names

Field Names and Contents

Entering Data

Query Commands

Reports

Relational Databases

Backing Up your Data

Database Structure

The Access View of Databases

Opening Other Tables

Navigating a Database

Exiting Access

Creating and Using Queries

Listing Specified Fields in all Records

Using Inequalities

Search Criteria using the AND, OR Operators

Search Criteria using Combined Operators

Sorting a Table

Sorting a Query

Sorting a Subset

Adding or Appending Records

Creating and using Forms

Creating Reports

Using Reports with Statistical Analysis

Designing your First Database

Case Study 1

Case Study 2

Glossary of Terms