Access Windows 97: Advanced

Course Code: ACCW97-3
Time: 7 hours		 Prerequisites: Access Windows 97: Intermediate
Table Relationships
Relativity: What’s the Big Deal?
The Relationships Window
Relationship Types
One-to-One Relationships
One-to-Many Relationships
Many-to-Many Relationships
Working with Join Properties
Referential Integrity
Cascading Related Values
Crosstab Queries
A Word About Table Normalization

Form Design Enhancements
Building Forms From Multiple Tables
Functions in Forms
List Boxes
Option Groups
Tab Order Review

Subforms
What’s a Subform?
Subform Properties
Creating a Subform with a Wizard
Formatting Subforms
Creating a Subform from Scratch
Command Buttons and Macros
What’s a Macro?
The Anatomy of a Macro Window
Creating a Macro
Assigning a Macro to a Command Buttons
Properties and More Properties, Plus Some Actions
The MoveSize Action
The Echo Action
Macro Conditions
The Conditions Column

Advanced Report Formatting
Calculated Fields
Running Sums
Evaluating Report Data
Using Macros in Reports
The ApplyFilter Action
The SetValue Action
Report Title Pages

Replicating Databases
Database Replication
Design Masters and Replicas
Synchronization
Resolving Conflicts

Return to Course Listing | Home Page

For comments or questions, e-mail us at info@cornerstonesolutions.com or contact us at: Cornerstone Solutions, Inc., P. O. Box 270514, Houston TX, 77277-0514, 713/661-5200