Page 4 of 9PREVNEXT

Queries II: Create basic select queries

The process of creating a select query

Design view gives you more control over a query. For example, you can limit your results to just employees in the marketing department, and sort those records by the employees' last names.

Remember, you can filter and sort data when you work in datasheet view, but adding filtering criteria and sort orders to a query makes those criteria automatic — they appear whenever you run the query.

Callout 1 On the Create tab, in the Other group, click Query Design. The designer starts and displays the Show Table dialog box.
Callout 2 In the dialog box, select your record source. You can use a combination of tables and queries, and your choices appear in the upper section of the designer.
Callout 3 In your record source, double-click the fields you want to see in your record set, your results. Your choices appear in the design grid. That's also where you specify criteria and other settings, such as whether to sort the results, and you'll get a chance to do that in the practice.
Callout 4 When you finish adding fields and criteria, test your query. Go to the Design tab on the Ribbon, and in the Results group, click Run.

The next section explains more about using criteria, so keep going.

Page 4 of 9PREVNEXT