Overview of Access 2003
Introduction to Database Concepts and Terminology
An Introduction to Access 2000
Database Planning and Design
Creating a Database

Principles of Table Design
Normalizing Data
Normalizing Data for Fourth and Fifth Normal forms

Principles of Table Relationships
Analyzing Table Relationships
Establishing and Testing Referential Integrity

Creating Tables
Examining a Table
Creating a Table with the Table Wizard
Creating a Table in Design View
Types of Primary Keys

Working with Tables
Adding Records
Modifying the Table Design
Finding and Editing Records
Deleting, Adding, and Copying Records and Values
Filtering and Sorting Records

Using Select Queries
Selecting Fields and Sorting Records
Refining the Results of a Query
Using Queries to Perform Calculations
Joining Tables in a Query

Query Joins and Crosstab Queries
Joining Tables and Working with Join Properties
Creating Crosstab Queries
Editing Limitations in Query Datasheets

Creating and Using Forms
Creating a Form
Modifying the Form Design
Using a Form to Locate and Organise Information
Multiple-Table Forms
Performing Calculations on a Form
Adding Combo Boxes to a Form
Adding Unbound Controls

Using Advanced Form Technqiues
Organising Field Placement
Using Functions to Control Data Entry
Adding an Option Group to a Form
Using a Form as the User Interface
Creating a Form that Contains a Subform

Creating and Using Reports
Creating a Report
Creating a Report that Contains Totals
Working with Subreports

Maintaining a Database
Managing a Database and its Objects
Database Maintenance
Securing a Database