Microsoft Access 2002: Level 2

Course Specifications

Software Version: Access 2002

Course Length: 6 Hours

 

Course Description

Reports, Forms, Combo Boxes, Enhancing Forms With OLE Fields, Hyperlinks, and Sub forms.

 

Databases are used to create, revise, and save documents for printing and future retrieval. This course is the second 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:

 

   Windows XP Introduction          Windows XP Level 1

   Windows XP Level 2                 Access Level 1

 

Performance-Based Objectives

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

   Report Creation

   Grouping in a Report

   Reviewing The Report Design

   Report Design Considerations

   Creating And Using Custom Forms

   Date, Memo, OLE (objects linking & embedding),

      And Hyperlink Fields

   Adding Fields To A Table

   Updating The New Fields

   Advanced Form Techniques

   Using Date And Memo Fields In A Query

 

Course Content

 

AL2-01: Report Creation

   Creating Query

   Creating A Report

   Using Design View

   Report Sections

   Changing Properties

   Enlarging Controls

   Saving And Closing A Report

   Printing A Report

 

AL2-02: Grouping In A Report

   Creating A Second Report

 

AL2-03: Reviewing The Report Design

   Removing Unwanted Controls

   Enlarging The Page Header Section

   Changing Column Headings

   Moving And Resizing Controls

   Previewing A Report

   Saving And Closing A Report

   Printing A Report

 

AL2-04: Report Design Considerations

 

AL2-05: Creating And Using Custom Forms

   Beginning the form creation

   Modifying the form design

   Adding a new field

   Changing the format of a field

   Combo boxes

   Adding a title

   Enhancing a title

   Changing tab stops

   Saving and closing a form

   Opening a form

   Using a form

   Closing a form

 

AL2-06: Date Memo, OLE (Objects Linking & Embedding), And Hyperlink Fields

 

AL2-07: Adding Fields To A Table

 

AL2-08: Updating The New Fields

   Entering Data In Date Fields

   Entering Data In Memo Fields

   Changing The Row And Column Size

   Entering Data In Ole Fields

   Entering Data In Hyperlink Fields

   Saving The Table Properties

 

AL2-09: Advanced Form Techniques

   Creating A Form With A Sub form

   Modifying The Sub form Design

   Modifying The Form Design

   Moving And Resizing Fields

   Moving Labels

   Moving Remaining Fields

   Changing Label Alignment

   Resizing The Labels

   Changing The Size Mode Of A Picture

   Changing The Special Effects And Colors Of Labels

   Adding A Form Title

   Viewing Data And Web Pages Using        The Form

 

AL2-10: Using Date And Memo Fields In A Query