Home.
Why Choose Ct.
Our Campus.
Mission Statement.
Staff and Tutors.
Certificate Courses.
Seminar Courses.
In Home Tutoring.
Onsite Training.
Va Program.
Workers Compensation.
Student Loans.
Job Pplacement.
Testing and Evaluations.
News Flash.
Contact Career Transitions.
links.
(707) 546-6605

Microsoft Access 2002: level 3

Course Specifications

Software Version: Access 2002

Course Length: 6 Hours

 

Course Description

Creating An Application System Using Macros, Wizards, And The Switchboard Manager. Databases are used to create, revise, and save documents for printing and future retrieval. This course is the third in a series of three Microsoft Access 2002 courses. It will provide you with the advance concepts required to produce a database.

 

Prerequisites

You should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. One of the following courses or equivalent knowledge is required:

   Windows XP Introduction         Windows XP Level 1

   Windows XP Level 2          Access Level 1 & 2

 

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

 

   Lookup And Input Mask Wizards         Modifying A Report

   Modifying The Form          Creating And Using Macros

   Creating And Using A Switchboard       Closing The Switchboard

 

Course Content

 

AL3-01: Lookup And Input Mask Wizards

   Using The Lookup Wizard

   Using The Input Mask Wizard

   Entering Data Using An Input Mask

   Using A Lookup Wizard Field

 

AL3-02: Modifying A Report

   Resizing And Moving Controls In A Report

   Adding Controls To A Report

   Resizing A Line

   Previewing A Report

 

AL3-03: Modifying The Form

   Adding Controls To A Form

   Changing The Tab Order

 

AL3-04: Creating And Using Macros

   The Macro Window

   Adding Actions To And Saving A Macro

   Running A Macro

   Modifying A Macro

   Errors In Macros

   Additional Macros

   Copying A Macro

   Modifying The Copied Macro

   Macro Arguments

   Creating Additional Macros

   Running The Macros

 

AL3-05: Creating And Using A Switchboard

   Creating A Switchboard

   Creating Switchboard Pages

   Modifying Switchboard Pages

   Modifying The Other Switchboard Pages

   Using A Switchboard

 

AL3-06: Closing The Switchboard And Database

Seminar Courses