Access Intermediate Course Content

Table Relationship Overview

A quick review of relationships to ensure everybody understands the concept to be uised during the course

Advanced and Action Queries

• Calculated fields, Parameter Queries, Summary Queries, Crosstab Queries and Top Values Queries
• Action Queries - Make Table, Append Query, Delete Query, Update Query
• Find Duplicates and Unmatched Data

Advanced Forms

• Calculations within Forms
• Combining Text Values
• Changing the data source
• Keyboard Short Cuts for Fields
• Tab Order
• Adding and Removing Filters(Selection and Forms)
• Defining Validation Rules
• Template Forms

Advanced Reports

• Using Expressions
• Adding Sub Reports
• Parameter reports
• Report Templates
• The Keep Together property
• Group on and group interval properties
• Advanced Grouping techniques
• Page setup

Charts and Pivot Tables

• Creating and editing charts on forms and reports
• Creating and editing Pivot Tables on forms and reports

Macro Overview

• Discussing macros and their benifit
• Example macro to automate tasks