|
Dave Mercer teaches database users the fundamentals
of Microsoft Access 2002 in this tutorial . Whether an advanced, or first
time database user, Microsoft 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.
This training course is designed for fast learning and covers all the
fundamental points of the application, all cds work on a mac or pc and
no application is needed.
Monitor resolution needs to be set at least 1024 by 768 to view
the entire movie.
The links below are free Macromedia Flash MX tutorials. The entire
contents may be purchased either on CD or watched via the Online University.
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
|
