Training Program Details
Basic Query Design
Creating a Query
Adding Fields
One at a Time
In Sequence
At Random
All Fields
All Fields Except 1 or 2
Using the *
Output All Fields
Clearing the Grid
Running a Query
Return to Design View
Sorting and Rearranging Columns
Preventing Data Changes
The Show Row
Entering Criteria
Number/Currency Fields
And vs. Or
Multi-line Criteria
In() and Not In()
Using Wildcards
Text Ranges
Dates
Yes/No Fields
Null and Not Null
Adding Parameters
Using Like in a Parameter
Adding Columns
Concatenating Fields
Adding Numeric Formulas
Calculating Time Durations
Formatting Formulas
Creating Totals Queries
Creating Update Queries
Creating Delete Queries
Other Query Types
Crosstab Queries
Why a Crosstab?
Setting Column, Row & Value
Grouping Options
Entering Criteria
Make Table Queries
Append Queries
Relationships in Queries
Join Types in Queries
Query Level Relationships
Union Queries
What is a Union Query?
Writing Basic SQL
Creating the Union Column
Sorting
Column Names
Setting Criteria
Using Parameters
Showing Duplicates
Forms & Reports Based
on Queries
Determing Sort Order
Adding Parameters
Based on an SQL Statement
Saving SQL as a Query
Creating Criteria Dialog Box
Creating the Form
Adding Unbound Controls
SQL in Combo Boxes
DMin & DMax
Pop Up/Dialog
Adding Command Buttons
Creating the Query
Adding Referencing Criteria
Testing the Dialog Box
Synchronizing Combo Boxes
Using Customer/Contact Combo
Manual Synchronizing
Automatic Synchronizing
