Tables & Database

Tables

Review of Referential Integrity

1 to 1 Relationships

Self-joins

Join Types

Multiple Field Primary Keys

Lookup Tables

Combo Boxes in Tables

Database Analysis

Analyze Tables & 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

Conditional Formatting

Form Properties

Edits, Deletions, Additions

Data Entry

Caption

Shortcut Menu

Pictures & Background Picture

Grid X/Y

Cycle

Control Defaults

For Objects Already on Form

Setting Defaults Before Add Field

Format Template

Properties

Page Breaks & Form Printing

Page Breaks, 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