Developing Queries in MS Access

3/19/00


Click here to start


Table of Contents

Developing Queries in MS Access

What is a query?

Common Types of Queries

Two ways to create queries

Query Design Window

Query By Example Grid

Specifying Criteria

Using Boolean Operators

Using “And”

Using “Or”

Using Wildcards

Choosing a range of records

Using Parameter Queries

Creating a custom crosstab query

SQL in Access

Author: D. Power

Email: power@dssresources.com

Home Page: http://dssresources.com