|
Course Outline Query
Design
Advanced queries using multiple tables.
Strategies for placing calculations in queries.
Concatenation in queries.
Inner and Outer joins.
Solutions to the "Ambiguous outer join…" problem.
Totals Queries.
Four Action queries: Append, Update, Delete, and Make-Table.
Uses for the:
Crosstab Query Wizard.
Find Duplicates Query Wizard.
Find Unmatched Query Wizard. |
Form and Report Design
Details on the various controls and their uses.
Extensive session on designing combo-boxes.
Securing forms and individual controls.
Properties of Forms, Reports, and properties of the controls on them.
Controlling where page breaks occur in reports.
Varying page numbering in reports.
Grouping levels in reports.
|
|
