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.
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.
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.
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.
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.