Microsoft Access 2000 Introduction

Database Terminology

Data Storage
Database Objects
Relational and Flat-File Databases
Access Databases

The Access Environment

Database Window
Menu Bar
Dialog Boxes
Shortcut Menus
Wizards
Getting Help

Creating a database

Introduction
Creating a New Database
Designing a Database

Tables

Creating a Table
Saving a Table
Modifying a Table
Field Names and Data Types
Other Field Properties

Entering And Editing Data

Adding New Records
Editing Records
Deleting Records
Editing and Adding Records with the Keyboard

Modifying Table Appearance

Columns
Rows
Fonts
Datasheet
Saving the Table Layout

Working with Records

Sorting Records
Finding Records
Filtering Records
Indexes

Using Multiple Tables

Relational Database Design Theory
Creating Relationships

Queries

Introduction
Creating a Query
Update Queries
Delete Queries
Append Queries
Crosstab Queries

Forms

Introduction
Creating a Form
Modifying a Form
Changing the Appearance of Controls
Subforms
Switchboard Manager
Startup Form

Reports

Introduction
Creating a Report
A Report with Grouped Data
Modifying a Report
Printing a Report