Page 2 of 9PREVNEXT

Queries II: Create basic select queries

Using the wizard or Design view to create a query

Access gives you several ways to create select queries. The easiest and fastest are the Query Wizard and Design view.

Callout 1 The Query Wizard automates the process of setting up your query's structure. You select a record source, choose sorting and filtering options, and the wizard does the rest. You can also use the wizard to create other types of queries, such as crosstab and action queries.
Callout 2 Design view gives you more control over your queries. After you select your record source, you drag the fields you want to a grid. You can also enter any selection criteria for filtering your data, and formulas for performing calculations.

We'll start with the wizard.

Page 2 of 9PREVNEXT