Virtual Training Company author Dave Mercer teaches database users the fundamentals of Microsoft Access 2002. Whether an advanced, or first time database user, Access 2002 delivers powerful tools for managing and analyzing data. Learn efficient database design, how to create effective tables, and the secrets of querying. Learn the logistics of datatypes and Auto-number fields. Also, learn how to create and edit reports, charts and easy-to-use Switchboard forms. All this and much more! To get started, simply click on one of the movie topics below.
Try For Free Right Now To help you evaluate this training program, some of the tutorials may be viewed for free online. Listed below are all of the chapters and lessons for this title. Click on any of the linked lessons below to watch them now online!
Creating Databases, Tables, Fields, and Setting Data Types
Creating and Saving Tables and Fields
(06:45)
What Makes a Database Relational? pt. 1
(05:21)
What Makes a Database Relational? pt. 2
(02:19)
Setting Data Types pt. 1
(04:04)
Setting Data Types pt. 2
(03:58)
Common Fields
(04:59)
Formats pt. 1
(03:59)
Formats pt. 2
(02:56)
More Field Settings pt . 1
(07:13)
More Field Settings pt . 2
(00:40)
Using Access Relationship Tools
Relationship Types
(04:39)
Getting and Setting Table Relationships
(07:29)
Many To Many Relationships
(04:46)
Composite Primary Keys
(04:08)
Resetting the AutoNumber Field
(04:44)
Creating Forms with Microsoft Access 2002
Letting the Form Wizard Do the Work
(06:07)
Choosing Forms in Design View
(05:49)
Adding a Subform
(05:08)
Navigating, Sorting, and Filtering Records
(01:42)
Setting the Form to Open at Startup
(01:53)
Creating Switchboard Forms
Creating a Switchboard
(04:11)
Adding and Deleting Switchboards
(00:29)
Modifying the Switchboard Form
(03:13)
Adding Controls to Forms
Form Sections / Headers / Footers / Controls pt. 1
(05:56)
Form Sections / Headers / Footers / Controls pt. 2
(03:43)
Inserting Graphics
(04:29)
Specifying Form Views
(03:43)
Sorting Records - Creating Form Filters
(03:45)
Creating a Query and Adding Table/Queries
What Kinds of Queries Are There?
(04:32)
The Design View and SQL View
(03:00)
Creating a SELECT Query and WHERE Clause pt. 1
(06:39)
Creating a SELECT Query and WHERE Clause pt. 2
(02:42)
Creating UPDATE and DELETE Queries
(03:40)
Adding Calculated Fields
(02:14)
Working with Summary Functions and Formulas
(03:05)
Adding Relationships to Queries
Joining Two Tables / Queries
(02:31)
Summary Queries with Joined Tables
(01:27)
Specifying Ranges in WHERE Clauses
(01:07)
Retrieving Records with Null Values pt. 1
(04:15)
Retrieving Records with Null Values pt. 2
(02:11)
Creating a Report - Report Basics
Using the Report Wizard / Saving a Report
(04:12)
A Walk Around the Report in Design View
(06:31)
Page and Detail Sections Adding Fields pt. 1
(04:28)
Page and Detail Sections Adding Fields pt. 2
(04:22)
Multi-Table (Joined) Reports
(03:48)
Setting Groups and Sorting Records pt. 1
(05:35)
Setting Groups and Sorting Records pt. 2
(06:57)
Advanced Report Design
Summarizing Values Adding Expressions to Reports
(06:21)
Adding Page Breaks / Graphics / Changing Margins pt. 1
(03:47)
Adding Page Breaks / Graphics / Changing Margins pt. 2
(01:11)
Modifying Report Queries
(05:08)
Creating and Using a Report Generator Form pt. 1
(04:32)
Creating and Using a Report Generator Form pt. 2
(07:24)
Creating and Using a Report Generator Form pt. 3
(04:29)
Cleaning Up a Report pt. 1
(04:37)
Cleaning Up a Report pt. 2
(03:05)
The Expression Builder Tool
Navigating the Properties Window pt. 1
(02:25)
Navigating the Properties Window pt. 1
(05:38)
Exploring Properties of Labels / Textboxes / Buttons pt. 1
(05:21)
Exploring Properties of Textboxes / Buttons pt. 2
(03:00)
Input Mask
(02:41)
Control Source
(04:11)
Expression Builder Tool
(03:55)
Cleaning Up Forms and Reports
(02:35)
To view the Free Tutorials you must have Quicktime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
See all VTC titles
