access certification training courses online
access certification training online

Access Certification Training Courses
Info and Order

Access Certification Training

Access Training Internet Based Course

The best access certification training site on the Internet.

FREE Online Courses

Video and CD's
Info and Order!

Access Tutorial

Cisco CCNA

Microsoft certification

Windows 2000 Tutorial

Windows NT

MS Exchange

SQL Server

IIS 4

TCP/IP

QuickBooks

HTML

Oracle 8i

RPG IV

Crystal Reports 8

XML Programming

SAP R/3

GroupWise 5.5

GUI Programming

Visual Basic

Visual InterDev

Lotus Notes

Novell 560 CNE

Novell 570 CNE

SAS Tutorial

SAS 8

LAN Training

UNIX

Sybase

Web Design

Contact Us

Click Here

This course is for anyone preparing for the MOUS Access 2000 Core certification exam, or interested in learning access.

Training that's Easy, Convenient and Affordable! High-quality, online, self-paced training designed to help you achieve your goals. Affordable annual subscription plans give you unlimited access to an entire suite of training topics at prices that you just won't find anywhere else.

Our courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All courses are design so that new knowledge and skills will be remembered and retrieved for future use. Each course include a 30-questions skill assessment, which evaluates your knowledge of the course material. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.

Try our FREE courses right now, and see for yourself how much you will learn!

This is self-paced, internet-based training -- there are no books to purchase and no scheduled classes to attend.

  • Creating Databases - shows users how to plan and create a database.
  • Building Tables - shows users how to create and populate database tables.
  • Modifying Tables - shows users how to edit table data, table structure, and field properties table format.
  • Sorting and Filtering - shows users how to find, filter, and sort records.
  • Relationships & Queries - shows users how to establish table relationships perform join operations and define and execute queries.
  • Building Forms - shows users how to create forms to change the appearance of reports and to add bound and unbound controls to reports.
  • Producing Reports - shows users how to create reports with the Report wizard arrange and organize reports and add bound and unbound controls to the report.
  • Advanced Tasks - shows users how to import data into databases create Web hypertext pages based on objects incorporate hyperlinks into objects and perform administrative tasks such as backing up the database.

After completing our courses, the user should 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
  • 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
  • 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
  • Sort records
  • Create advanced sorts
  • Search for records
  • Apply and remove filters
  • Define table relationships
  • Display related records
  • Specify query criteria
  • Create calculated fields
  • Create and modify multi-table queries
  • Create a form
  • Edit the form in design view
  • Add and modify controls
  • Create and use calculated controls
  • 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

A typical course has the following features:

  • Exercises that allow users to practice
  • A file containing the text of the exercises
  • Simulations that allow users to practice course skills.
  • A course index
  • A glossary
  • A Skill Assessment

All courses are included in PC Desktop Pack and PC Business Pack.