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

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