Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160

Course catalog - Improve Job Skills or Study For Certification Exams.                              








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




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.

Buy this entire online training course with one easy payment of $37

OR

Buy the Office Value pack, and receive this course plus many more, for only $97



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 is designed to help you 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.




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



Sorting and Filtering
  • Sort records
  • Create advanced sorts
  • Search for records
  • Apply and remove filters



Relationships & Queries
  • Define table relationships
  • Display related records
  • Specify query criteria
  • Create calculated fields
  • Create and modify multi table queries



Building Forms
  • Create a form
  • Edit the form in design view
  • Add and modify controls
  • Create and use calculated controls



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





 

          Tutorials for success

Copyright © 2010 TrainingCenter.com