Access 2003 Intermediate Level 2 2 Days

Tables & Database
Tables
Review of Referential Integrity
1 to 1 Relationships
Self-joins
Join Lines
Join Types
Multiple Field Primary Keys
Lookup Tables
Combo Boxes in Tables
Database Analysis
Analyze Tables
Analyze Performance
Documenter
Forms
Creating Pop Up Forms
(Dialog Boxes)
Border Styles
Setting Properties
Sub Form Totals
Create Formula in Datasheet Form
Add Formula to Main Form
Protecting Formulas
Bound Options Groups
Creating an Option Group
Modifying & Formatting
Bound List Boxes
Creating using the Wizard
Formatting the List Box
Switching to a Combo Box
From Combo Box to List Box
The Tab Control
Creating a Tab Control
Adding Fields & Formulas
Moving Control to Pages
Changing Page Order
Adding & Deleting Pages
Formatting Pages
Control Defaults
For Objects Already on Form
Setting Defaults Before Add Field
Format Template
Properties
Form Properties
Edits, Deletions, Additions
Data Entry
Caption
Shortcut Menu
Pictures
Grid X/ Y
Background Picture
Cycle
Page Breaks & Form Printing
Page Breaks
Page Headers/ Footers
White Background Printing
Continuous Forms
Adding and Aligning Fields
Adding Formulas
2 Line Labels
Continuous View
Format to Resemble Datasheet
Dividing Lines
Form Header/ Footer
Continuous vs. Datasheet
Reports
Multi-Column Reports
Sorting & Grouping
Grouping Tricks
Setting Up Columns
Adding Fields
Adding Column Headings
Review of Mail Merge
Quick Review of Word Merge
Letters in Access
Writing the Letter
Inserting the Fields
Formatting the Letters
Limitations
Sub Reports
Designing a Sub Report
Designing a Main Report
Graphs
Using the Chart Wizard
Arranging the Chart
Setting Summary Formulas
Formatting the Chart
Using MS Graph