Page 5 of 11PREVNEXT

Create queries for a new Access 2007 database

The process of creating a select query


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 recordsource. 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 Other group, click Query Design. The designer starts and displays the Show Table dialog box.
Callout 2 In the dialog box, select your recordsource. 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 recordsource, double-click the fields that you want to see in your recordset, or results. Your choices appear in the bottom section of the designer.
Callout 4 When you finish adding fields, go to the Design tab on the Ribbon, and in the Results group, click Run.

Your recordset 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