Contents:
| Defining Relationships |
Enhanced Table Designs |
| · Design considerations |
· Setting Field Properties |
| · Relational vs. Flat File Database |
· Formatting Data |
| · Creating Relationships |
· Default Value Properties |
| · Enforced Referential Integrity |
· Validation Rule Operators |
| · Join Properties |
· Rules and Limitations |
|
|
| Select Queries |
Enhance Form and Report Design |
| · When to use a Select Query |
· Overview of Bands and Controls |
| · Creating a Select Query |
· Adding Titles, Labels and Fields |
| · Entering Search Criteria |
· Calculated Fields in Forms |
| · Query Expressions |
· Group and Sort |
| · Sort Order |
· Inserting Objects and Page Breaks |
| · Hiding a Column |
· Insert Command Buttons |
| · Calculated Fields |
|
|
Macros |
| Parameter Queries |
· Creating a Macro |
| · Creating |
· The Macro Window |
| · Pattern Matching in a Parameter Query |
· Saving the Macro |
|
· Attaching to Command Buttons |
| Action Queries |
|
| · Make Table |
Charts |
| · Delete |
· Selecting the Chart Data |
| · Append |
· Insert Charts to Forms and Reports |
| · Update |
· Changing a Charts Properties |
| · Crosstab |
|
Target Audience: Individuals wishing to design relational databases and build more complex database objects, including tables, queries, forms, reports and macros.
Assumed Knowledge: Access Essentials or equivalent experience is required.
Duration: 1 Day
Suggested follow-up course: Access 2007 Specialist