Page 5 of 11PREVNEXT

Create queries for a new database

Using query designer


The Query Designer gives you the most control over a select query. It also makes it easy to create a query that uses a single table as a record source. For example, this type of query makes it easy to list your assets and their purchase dates.

Callout 1 On the Create tab, in the Queries group, click Query Design. The designer starts and displays the Show Table dialog box. On the ribbon, the Design tab also appears.
Callout 2 In the dialog box, select your record source. You can use a combination of tables and queries, and the ones you select appear in the upper section of the designer.
Callout 3 In your record source, double-click the fields that you want to see in your record set, or results. Your choices appear in the bottom section of the designer.
Callout 4 When you finish adding fields, go to the Design tab, and in the Results group, click Run.

Your record set appears as a datasheet. You'll have a chance to use the designer in the practice at the end of this course.

Page 5 of 11PREVNEXT