ICB Consulting, Inc.

Good with computers, but even better at helping people.

 

 
Home
Products
Services
Training

 

Training Menu

Training Home
Upcoming Classes
Register For A Class
Training Center Directions
Nearby Hotels
Evaluation Form
Rent Our Room

 

 

 

Microsoft Access Level 2

This is a one day, intermediate level class.   It assumes you have either taken the Level 1 class or you have at least some experience using Microsoft Access.

Target Student:  

Students enrolling in this course should have a basic level of understanding of the Access 2000 interface, and should have some experience designing tables, simple queries, forms, and reports.

Course outline:

Lesson 1: Principles of Table Design

Topic 1A: Normalizing Data

Topic 1B: Normalizing Data for Fourth and Fifth Normal Forms

 Lesson 2: Principles of Table Relationships

Topic 2A: Analyzing Table Relationships

Topic 2B: Establishing and Testing Referential Integrity

 Lesson 3: Table Design Techniques

Topic 3A: Data Validation Techniques

Topic 3B: Indexing Techniques

 Lesson 4: Designing Select Queries

Topic 4A: Using Calculated Fields in Queries

Topic 4B: Creating Multiple-table Queries

 Lesson 5: Customizing Form Designs

Topic 5A: Customizing the Form Design

Topic 5B: Performing Calculations on a Form

Topic 5C: Adding Combo Boxes to a Form

Topic 5D: Adding Unbound Controls

 Lesson 6: Working with Data Access Pages

Topic 6A: Creating Data Access Pages

Topic 6B: Integrating with Other Applications

 Lesson 7: Customizing Reports

Topic 7A: Customizing a Report Created by the Report Wizard

Topic 7B: Working with Subreports

Topic 7C: Creating a Report in Design View

 

Copyright © 2003-7 ICB Consulting, Inc.  |  Site Map  |  Web Sites We Publish Jobs About Us Contact Us