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 2000 Online Computer Course

12 Month Subscription - $35
Live Mentor +$30

Summary:
This series is designed to help users prepare for Microsoft Access 2000 MOS certification. It shows how to create, plan, and modify databases and tables in Access 2000. It also covers sorting and filtering, creating queries, forms and reports, and advanced tasks such as saving Access objects as Web pages, importing data, and adding hyperlinks. This course includes 22 hours of training on Microsoft Access 2000 material.

Certification:
MOS - Microsoft Office Certification - Access 2000

Audience:
This series is for anyone preparing for the MOS Access 2000 Core certification exam.

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

In this course you will learn how to:
Access 2000 : Creating Databases
Access 2000 : Building Tables
Access 2000 : Modifying Tables
Access 2000 : Sorting and Filtering
Access 2000 : Relationships and Queries
Access 2000 : Building Forms
Access 2000 : Producing Reports
Access 2000 : Advanced Tasks


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

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 2000 : Building Tables
Summary: Time: 2.0 hour(s)
This course shows users how to create and populate database tables in Access 2000.

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 Text
top

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

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 2000 : Sorting and Filtering
Summary: Time: 3.0 hour(s)
This course shows users how to find, filter, and sort records in Access 2000.

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 2000 : 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 2000.

Objectives:
After completing this course, students will be able to:
Define 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 2000 : Building Forms
Summary: Time: 2.0 hour(s)
This course shows users how to create forms in Access 2000 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 Form Design View
Using Controls
Using Calculated Controls
top

Access 2000 : 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.

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 a Report
Using the Report Wizard
Working with Reports in Design View
Using Controls in Reports
Using Calculated Controls in Reports
top

Access 2000 : Advanced Tasks
Summary: Time: 2.0 hour(s)
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.

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