Page 3 of 9PREVNEXT

Queries II: Create basic select queries

The process of using the Query Wizard

If you're new to Access, the Query Wizard is a good way to start building queries. The wizard also enables you to group and summarize data. That isn't necessary for simple queries, but it can help you analyze more complex record sets, and it can also make reports much easier to read and understand.

Callout 1 On the Create tab, in the Other group, click Query Wizard.
Callout 2 Complete the wizard. As part of that, you select the tables and fields you want to use as your record source. You can also use other queries in your record source.
Callout 3 Give your new query a descriptive name, and remember that it's a good practice to avoid using spaces in the name.

After you create your query, the wizard can run it for you. It's always a good idea to run your queries and ensure they provide the data you need. If they don't, you can start over and select new fields and other options, or you can change your queries in Design view. So let's take a look at Design view.

Page 3 of 9PREVNEXT