More Query Design Options

In Access query design is essential for getting the data you want. Use query design in Access to design almost any query you want.

Modifying queries

Video: Modifying Queries in Access 2010

Launch video!Watch the video (2:09).

Access offers many options for making your queries work better for you. In addition to modifying your query criteria and joins after you build your queries, you can choose to sort or hide fields in your query results.

To modify your query:

When you open an existing query in Access, it is displayed in Datasheet view, meaning you will see your query results in a table. To modify your query, you must enter Design view, the view you used when creating it. There are two ways to switch to Design view:

Once in Design view, make the desired changes, then select the Run command to view your updated results.

You may notice that Access offers other query views, like Pivot Table View, Pivot Chart View, and SQL View. You can ignore them; these views permit advanced functions you will not need to use for this tutorial or for most Access functions.