Contents:
| Introduction to Relational Database |
Crosstab Queries |
| · Relational vs. Flat File Database |
· What are Crosstab Queries |
| · Creating Relationships |
· Creating Crosstab Queries |
| · Enforced Referential Integrity |
· Rows, Columns and Values |
| · Join Types |
|
| · Join Properties |
Office Links |
|
· Collect and Paste among Programs |
| Select Queries |
· Collect multiple items with Clipboard |
| · Select Query v Select Filters |
· Analyse with Excel |
| · Creating a Select Query |
· Publish and Merge with Word |
| · Multi-Table Queries |
|
| · Entering Search Criteria |
Enhanced Report Design |
| · Query Expressions |
· Understanding Report Bands |
| · Sort and Sort Within |
· Adding Titles, Labels and Fields |
| · Hiding a column |
· Calculated Fields in a Report |
| · Calculated Fields |
· Sorting and Grouping |
| · Summary Total Queries |
|
| · Find Unmatched Records Wizard |
Pivot Tables |
|
· Using the Pivot Table Wizard |
| Parameter Queries |
· Page, Row, Column and Value Fields |
| · Creating Parameter Queries |
· Filtering Data |
| · Pattern Matching |
· Grouping Dates |
|
|
| Action Queries |
Charts |
| · Make Table |
· Selecting the Chart Data |
| · Delete |
· Free-Standing v Embedded Charts |
| · Append and Update |
· Changing the Properties of a Chart |
Target Audience: Individuals that create or use existing databases that wish to learn the skills necessary to analyse the data and produce enhanced reports.
Assumed Knowledge: Access Essentials or equivalent experience is required.
Duration:
1 Day - Click here to see our course calendar.
Suggested follow-up course: MS Access Specialist