Microsoft Access 2002: Level 1

Course Specifications

Software Version: Access 2002

Course Length: 6 Hours

 

Course Description

Databases are used to create, revise, and save documents for printing and future retrieval. This course is the first in a series of three Microsoft Access 2002 courses. It will provide you with the basic concepts required to produce a basic 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:

 

Basic Typing Skills        Windows XP Introduction

Windows XP Level 1     Windows XP Level 2

 

Performance-Based Objectives

And Course Content

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

 

Get Started With Access

Creating A New Database

Creating A Table

Adding Records To A Table

Closing A Table and Database

Opening A Database

Adding Additional Records

Previewing And Printing The Contents Of A Table

Creating Additional Table

Using A Form To View Data

Creating A Report

Closing The Database

Access Help System

Creating A Query

Clearing The Design Grid

Entering Criteria

Using Compound Criteria

Sorting Data Ina A Query

Joining Tables

Saving As Query

 

Course Content

 

L1-01: Getting Started With Access

   An Overview Of Access

   Knowing The Toolbars

 

AL1-02: Creating A New Database

   Creating And Naming A Database

   Using The Wizard

 

AL1-03: Creating A Table

   Using The Wizard

   Field Name - A Unique Name

   Data Type - Data The Field Will Contain

   Description - Detailed Description Of The

      Field

 

AL1-04: Adding Records To A Table

   Using Tab Key To Add A Record

   Use Shortcut Menu To Add A Record

 

AL1-05: Saving And Closing A Table and Database

 

AL1-06: Opening A Database

 

AL1-07: Adding Additional Records

 

AL1-08: Previewing And Printing The Contents Of A Table

 

AL1-09: Creating Additional Tables

 

AL1-10: Using A Form To View Data

   Creating A Form

   Closing And Saving The Form

   Opening The Saved Form

   Using The Form

   Switching Between Form View And Data sheet View

 

AL1-11: Creating A Report

   Using A Wizard

   Printing A Report

 

AL1-12: Closing The Database

 

AL1-13: Access Help System

   Ask A Question Box

 

AL1-14: Creating A Query

   Using A Wizard

   Displaying Selected Fields

      In A Query

   Running A Query

   Printing The Results Of

      A Query

   Returning To The Select

      Query Window

   Closing A Query

 

AL1-15: Clearing the Design Grid

 

AL1-16: Entering Criteria

   Using Text Data In Criteria

   Using Wildcards

   Criteria For A Field Not In

     The Result

   Using Numeric Data In Criteria

   Using Comparison Operators

 

AL1-17: Using Compound Criteria

   Using AND Criteria

   Using OR Criteria

 

AL1-18: Sorting Data In A Query

   Omitting Duplicates

   Sorting On Multiple Keys

 

AL1-19: Joining Tables Restricting Records in a Join

 

AL1-20: Saving a Query