access 2002 online training course tutorials

See How It Works

This online course includes tutorials for:	Time Needed
Creating Databases	3 hours
Building Tables	2 hours
Modifying Tables	3 hours
Sorting and Filtering	3 hours
Relationships & Queries	4 hours
Building Forms	2 hours
Producing Reports	3 hours
Advanced Tasks	2 hours
Estimated time needed to complete entire course	22 hours

Receive your login ID to take the training courses online, as many times as you wish, for 1 year. Click here for group orders.

Benefits

Unlimited access for 1 year
Learn anytime, anywhere
You control the pace
Start & stop wherever you want
No books to read
No software needed
Value Packs include Free online tech support
Double guarantee

100% Money back guarantee
One time payment No monthly fee
Use the course index for review anytime
Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
Free status reports for company managers

Requirements

All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer. Prices shown are per user.

What You will Learn

This online training course shows how to create, plan, and modify databases and database objects in Access 2002. Courses cover the following topics: understanding relational databases, creating and planning databases, selecting and printing database objects, creating tables, entering records, modifying tables and field properties, using advanced sorts, finding records, applying and removing filters, establishing and managing table relationships, specifying query criteria, creating calculated fields, running multi table queries, creating forms and reports, implementing standard and calculated controls in both forms and reports, importing data, saving Access objects as Web pages, and performing administrative tasks. This online training course is procedure focused and assumes that the student is familiar with the mechanics of getting around in a Microsoft Office application.

Creating Databases

Identify appropriate input and output for a database
Plan a database

Create a database with and without the wizard
Select and print database objects

Building Tables

Explain the structure of a table, the data types used in the table, and the function of primary keys

Create a table using the wizard
Enter records into the table through a form or datasheet

Modifying Tables

Insert and delete records and fields
Modify the appearance and structure of the table in Design View

Change the size, format, and default value of fields
Use the Lookup and Input Mask wizards

Relationships & Queries

Define table relationships
Manage table relationships
Display related records

Specify query criteria
Create calculated fields
Create and modify multi table queries

Producing Reports

Describe the components of reports
Create a report using the Report Wizard
Edit the report in design view

Add and modify controls in a report
Create and use calculated controls in a report

Advanced Tasks

Import data into a table
Save an Access object as a Web page

Add hyperlinks to an Access object
Back up, restore, and compact a database

Access 2002 Join over 1 million people who learn online, with these complete interactive computer training courses.

Access 2002
Join over 1 million people who learn online, with these complete interactive computer training courses.