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.
On the
Create tab, in the
Other group, click
Query Design. The designer starts and displays the
Show Table dialog box.
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.
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.
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.
