Email:

edcenter@computersup.com

Address:

Computer Support

860 South 5th Ave

Clarion, PA 16214

Page best viewed with Internet Explorer 4.0 or higher and 1024x768 or higher screen resolution.

 

Intermediate Microsoft Access

Day or Evening Class

 

Overview

The Intermediate Microsoft Access class teaches students some of the more advanced features of Microsoft Access. Topics include modifying tables, setting field properties, advanced form and report designs and creating queries.

 

Prerequisite

Students should have successfully completed the Introduction to Microsoft Access course or equivalent knowledge.

 

Outline

    1. Review of Basic Access

    1. Using Related Tables

    2. Referential integrity

    1. Creating Relationships

    1. Insert Columns

    2. Hyperlink Columns

    3. Many to Many Relationships

    1. Setting Field Properties

    1. Using Field Properties

    2. Default Values

    3. Yes/No Formats

    4. Validation Rules

    5. Input Masks

    1. Design View

    1. Ruler

    2. Alignment

    3. Snap to Grid Feature

    4. Field List

    5. Adding Labels and Images

    6. Edit an Unbound Control

    1. Advanced Form Design

    1. Using Forms in Design View

    2. Combo Boxes

    3. Setting Tab Order

    4. Creating a Blank Form

    5. Headers and Footers

    1. Advanced Report Design

    1. Working with Subforms/Subreports

    1. Creating Action Queries

    1. Make-table Query

    2. Append Query