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