Microsoft Access – Full Course

Microsoft Access Outline

Lesson #1

Introduce Access

Dissect Access

Describe Interface

Save Database

Discuss Common Screen Elements

Introduce Access Containers

Describe Tables

Save Table

Create Table Elements

Use Design Views

Use Datasheet View

Describe Field Data Types

Use Field properties

Use Lookup Wizard

Use Input Mask

Enter Records

Insert Fields in Datasheet View

Move Fields

Lesson #2

Introduce Access

Dissect Access

Describe Interface

Discuss Common Screen Elements

Introduce Forms

Design form

Use Form

Enter Data into Forms

Navigate Forms

Search Forms

Windows Navigation Bar

Delete Records in Forms

Filter Records in Forms

Add New Field to Table

Add New Field to Existing Form

Lesson #3

Introduce Access

Dissect Access

Describe Interface

Discuss Common Screen Elements

Introduce Queries

Create Simple Query

Use Design Query

Creating a Custom Report

Put All Together

Introduce Table

Create Lookup List

Set Input Mask

Save Table

Introduce Forms

Use Form

Change Table Structure

Change Field names

Save Form

Introduce Reports

Design Report

Save Report

Introduce The Query

Choose Fields

Set Search Criteria

Run Query

Save Query

Lesson #4

Work with Multiple Tables

Introduce Primary Keys

Delete Primary Key Field

Re-create Primary Key field

Move fields

Create Lookup Combo Box

Introduce Relationships

Create Relationships

Introduce Referential Integrity

Enforce Referential Integrity

Introduce one to Many relationship

Create Lookup Query

Create Lookup form