Microsoft Access 2002 Tutorial

We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD.
CLICK HERE TO BUY THIS CD

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? - Lesson 1
What Makes a Database Relational? - Lesson 2
Setting Data Types - Lesson 1
Setting Data Types - Lesson 2
Common Fields
Formats - Lesson 1
Formats - Lesson 2
More Field Settings - Lesson 1
More Field Settings - Lesson 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 - Lesson 1
Form Sections / Headers / Footers / Controls - Lesson 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 - Lesson 1
Creating a SELECT Query and WHERE Clause - Lesson 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 - Lesson 1
Retrieving Records with Null Values - Lesson 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 - Lesson 1
Page and Detail Sections Adding Fields - Lesson 2
Multi-Table (Joined) Reports
Setting Groups and Sorting Records - Lesson 1
Setting Groups and Sorting Records - Lesson 2

Advanced Report Design
Summarizing Values Adding Expressions to Reports
Adding Page Breaks / Graphics / Changing Margins - Lesson 1
Adding Page Breaks / Graphics / Changing Margins - Lesson 2
Modifying Report Queries
Creating and Using a Report Generator Form - Lesson 1
Creating and Using a Report Generator Form - Lesson 2
Creating and Using a Report Generator Form - Lesson 3
Cleaning Up a Report - Lesson 1
Cleaning Up a Report - Lesson 2

The Expression Builder Tool
Navigating the Properties Window - Lesson 1
Navigating the Properties Window - Lesson 1
Exploring Properties of Labels / Textboxes / Buttons - Lesson 1
Exploring Properties of Textboxes / Buttons - Lesson 2
Input Mask
Control Source
Expression Builder Tool
Cleaning Up Forms and Reports