Access - Intermediate

How Table Relationships Affect Queries

• Creating Relationships Between Tables
• Add Relationship Security

Controlling Query Results with Join Types

• How Relationships Affect Query Results
• Using Join-Types to Affect Query Results

Creating Complex Queries with Multiple Criteria

• Applying Wildcards
• Using And / Or Conditions

Calculating Data with Queries

• Create Custom Fields with Calculations 
• Summarize Data with Grouping 

Module 4

Automating Queries with Parameters

• Creating Automated Requests for Criteria
• Using Wildcards in Parameter Queries
• Using Range Operators in Parameter Queries 

Using Query Wizards

• Getting Non-Matching Records with the Un-Matched Query Wizard
• Finding Duplicate Records with the Duplicate Query Wizard

Exploring Action Queries

• Create Tables with a Make-Table Query
• Add Records to a Table with an Append Query
• Change Data with an Update Query
• Delete Data with a Delete Query

Advanced Report Design Techniques

• Understanding Report Control Types
• Grouping Report Data
• Summarizing Report Data

What We'll Explore:

• How Table Relationships Affect Queries 
• Controlling Query Results with Join Types 
• Creating Complex Queries with Multiple Criteria 
• Calculating Data with Queries 
• Automating Queries with Parameters 
• Using Query Wizards 
• Exploring Action Queries 
• Advanced Report Design Techniques