computer training image
Online Training Classes Purchased Securely
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout
Online Payments

Benefits of Computer Coach's online computer training classes

  • Accessible 24 hours a day 7 days a week, so you can learn when you have time.
  • Cost-effective solutions, so you don’t go broke learning the skills you need.
  • Available Anytime, anywhere with an Internet connection, so you can study at your house, office, or where you feel comfortable.
  • Interactive & fun courses allow for greater retention of course topics.
  • Easy to use so you can start learning right away.
  • Full of hands-on labs so you can get the practice you need
  • HTML Based so you don’t need any additional downloads
  • Live Mentor Available to ask questions and get clarification

online computer training questions answered

Access 2002 Online Course

12 Month Subscription - $35
Live Mentor +$30

Summary:
This series 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 series is procedure focused and assumes that the student is familiar with the mechanics of getting around in a Microsoft Office application.

Audience:
This series is for anyone who wants to get the most out of using Access 2002.

Features:
●  Exercises that allow users to practice the application
●  Simulations that allow users to practice course skills, even if they don't have access to the application
●  A glossary
●  A Skill Assessment

Topics included in this course:
Access 2002 Series: Creating Databases
Access 2002 Series: Building Tables
Access 2002 Series: Modifying Tables
Access 2002 Series: Sorting and Filtering
Access 2002 Series: Relationships and Queries
Access 2002 Series: Building Forms
Access 2002 Series: Producing Reports
Access 2002 Series: Advanced Tasks

Access 2002 Series: Creating Databases
Summary: Time: 3.0 hour(s)
This course shows users how to plan and create a database in Access 2002.

Objectives:
After completing this course, students will be able to:
Identify appropriate input and output for a database
Plan a database
Create a database with and without the wizard
Select and print database objects

Topics:
Understanding Relational Databases
Planning a Database
Creating a Database
Selecting and Printing Database Objects
top

Access 2002 Series: Building Tables
Summary: Time: 2.0 hour(s)
This course shows users how to create and populate database tables in Access 2002.

Objectives:
After completing this course, students will be able to:
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

Topics:
Understanding Table Structure
Creating Tables
Entering Records
top

Access 2002 Series: Modifying Tables
Summary: Time: 3.0 hour(s)
This course shows users how to edit table data, table structure, and field properties in Access 2002.

Objectives:
After completing this course, students will be able to:
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

Topics:
Modifying Data
Modifying Tables
Modifying Field Properties
Modifying Tables Using the Wizards
top

Access 2002 Series: Sorting and Filtering
Summary: Time: 3.0 hour(s)
This course shows users how to find, filter, and sort records in Access 2002.

Objectives:
After completing this course, students will be able to:
Sort records
Create advanced sorts
Search for records
Apply and remove filters

Topics:
Sorting Records
Using Advanced Sorts
Finding Records
Applying and Removing Filters
top

Access 2002 Series: Relationships and Queries
Summary: Time: 4.0 hour(s)
This course shows users how to establish table relationships, perform join operations, and define and execute queries in Access 2002.

Objectives:
After completing this course, students will be able to:
Define table relationships
Manage table relationships
Display related records
Specify query criteria
Create calculated fields
Create and modify multi-table queries

Topics:
Establishing Table Relationships
Managing Table Relationships
Displaying Related Records
Specifying Query Criteria
Creating Calculated Fields
Using Multi-Table Queries
top

Access 2002 Series: Building Forms
Summary: Time: 2.0 hour(s)
This course shows users how to create forms in Access 2002, to change the appearance of reports, and to add bound and unbound controls to reports.

Objectives:
After completing this course, students will be able to:
Create a form
Edit the form in design view
Add and modify controls
Create and use calculated controls

Topics:
Creating a Form
Working in Design View
Using Controls
Using Calculated Controls
top

Access 2002 Series: Producing Reports
Summary: Time: 3.0 hour(s)
This course shows users how to create reports with the Report Wizard, arrange and organize reports, and add bound and unbound controls to the report in Access 2002.

Objectives:
After completing this course, students will be able to:
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

Topics:
Creating Access Reports
Using the Report Wizard
Working with Reports in Design View
Using Controls in Reports
Using Calculated Controls in Reports
top

Access 2002 Series: Advanced Tasks
Summary:
This course shows users how to import data into Access databases, create Web hypertext pages based on Access objects, incorporate hyperlinks into Access objects, and perform administrative tasks such as backing up the database in Access 2002.

Objectives:
After completing this course, students will be able to:
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

Topics:
Importing Data
Saving Access Objects as Web Pages
Adding Hyperlinks
Performing Administrative Tasks
top

12 Month Subscription - $35
Live Mentor +$30