Microsoft Access 2002 Tutorial Try for FREE

The fastest and most cost effective way to learn! Forget boring books! No need for expensive classroom training - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.

Please Note:
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Access 2002 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.

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