Access 2000 Intermediate

Module 1: Designing and Creating Tables

Building Your Skills

Designing Tables

Table Elements

Normalization

Creating Tables

Creating Tables Using a Wizard

Creating Tables in Design View

Assigning a Primary Key

Defining Data Entry Rules

Setting Display Rules

Establishing Data Entry Rules

Module 2: Creating and Using Relationships

Building Your Skills

Importing and Linking Data

Importing Data

Linking to Another Database

Defining Table Relationships

One-to-many relationship

One-to-one relationship

Many-to-many relationship

Many-to-one relationship

Subdatasheets

Using Cascade Update and Cascade Delete Options

Creating Lookup Controls

Using Tables to Establish Lookups

Using Queries to Establish Lookup Fields

Module 3: Creating and Enhancing Forms

Building Your Skills

Creating a Form

Creating a Form Using AutoForm

Creating a Form Using a Wizard

Modifying a Form

Selecting Form Elements

Moving and Modifying Controls

Creating Form Headers and Form Footers

Building a Custom Form

Enhancing a Form

Creating a Hyperlink

Exploring Form Properties

Changing Form Properties

Using AutoFormat

Module 4: Creating and Automating Forms

Building Your Skills

Enhancing Form Design

Creating Combo Boxes

Creating Check Boxes

Creating Option Groups

Combining Multiple Data Sources in a Single Form

Merging Two Tables into a Form

Adding a Subform to a Form

Inserting Tab Controls

Designing Command Buttons