Microsoft Access 2002

Getting to Know Microsoft Access 2002

Course Introduction pt. 1

Course Introduction pt. 2

Access 2002 Database Tables / Queries

Access 2002 Database Forms

Access 2002 Database Reports / Reports / Macros

Access 2002 Database Modules

Working with Access 2002

Creating a New Blank Database

Saving Data / Opening / Exiting Database Applications

Printing Reports and Forms

Using Access 2002 Assistance

Access 2002 AssIstance

Access 2002 Menus / Tools / Options

File / Edit Menus

View / Insert / Tools Menus

Tools Menu Continued

Creating Databases, Tables, Fields, and Setting Data Types

Creating and Saving Tables and Fields

What Makes a Database Relational? pt. 1

What Makes a Database Relational? pt. 2

Setting Data Types pt. 1

Setting Data Types pt. 2

Common Fields

Formats pt. 1

Formats pt. 2

More Field Settings pt . 1

More Field Settings pt . 2

Using Access Relationship Tools

Relationship Types

Getting and Setting Table Relationships

Many To Many Relationships

Composite Primary Keys

Resetting the AutoNumber Field

Creating Forms with Microsoft Access 2002

Letting the Form Wizard Do the Work

Choosing Forms in Design View

Adding a Subform

Navigating, Sorting, and Filtering Records

Setting the Form to Open at Startup

Creating Switchboard Forms

Creating a Switchboard

Adding and Deleting Switchboards

Modifying the Switchboard Form

Adding Controls to Forms

Form Sections / Headers / Footers / Controls pt. 1

Form Sections / Headers / Footers / Controls pt. 2

Inserting Graphics

Specifying Form Views

Sorting Records - Creating Form Filters

Creating a Query and Adding Table/Queries

What Kinds of Queries Are There?

The Design View and SQL View

Creating a SELECT Query and WHERE Clause pt. 1

Creating a SELECT Query and WHERE Clause pt. 2

Creating UPDATE and DELETE Queries

Adding Calculated Fields

Working with Summary Functions and Formulas

Adding Relationships to Queries

Joining Two Tables / Queries

Summary Queries with Joined Tables

Specifying Ranges in WHERE Clauses

Retrieving Records with Null Values pt. 1

Retrieving Records with Null Values pt. 2

Creating a Report - Report Basics

Using the Report Wizard / Saving a Report

A Walk Around the Report in Design View

Page and Detail Sections Adding Fields pt. 1

Page and Detail Sections Adding Fields pt. 2

Multi-Table (Joined) Reports

Setting Groups and Sorting Records pt. 1

Setting Groups and Sorting Records pt. 2

Advanced Report Design

Summarizing Values Adding Expressions to Reports

Adding Page Breaks / Graphics / Changing Margins pt. 1

Adding Page Breaks / Graphics / Changing Margins pt. 2

Modifying Report Queries

Creating and Using a Report Generator Form pt. 1

Creating and Using a Report Generator Form pt. 2

Creating and Using a Report Generator Form pt. 3

Cleaning Up a Report pt. 1

Cleaning Up a Report pt. 2

The Expression Builder Tool

Navigating the Properties Window pt. 1

Navigating the Properties Window pt. 1

Exploring Properties of Labels / Textboxes / Buttons pt. 1

Exploring Properties of Textboxes / Buttons pt. 2

Input Mask

Control Source

Expression Builder Tool

Cleaning Up Forms and Reports