| Lesson 5 | Using the Query Design view |
| Objective | Identify the parts of the Query Design window and what they do. |
Using Query Design View
Although the Query Design view looks pretty daunting, it should not look completely unfamiliar. The Advanced Filter/Sort window is very similar to the Query Design view.
The following MouseOver identifies the different parts of the window and what they do.
- View Datasheet button
- Save button: Saves the query design
- Query Type button
- Show Table button: Displays Show Table dialog box so that you can add tables to the query
- Totals button: Displays or hides Total line in grid
- Tables pane: Displays tables and their fields for use in the query
- Query by Design grid: Do the query here
- You can click and drag the pane divider to change the size of the panes.
- Field row: Shows fields used in the query
- Table row: Lists the table each field is from
- Total row: Allows you to group and summarize query results
- Sort: Allows you to choose a sort order for the query
- Criteria: Specify criteria in this row
- Or: Specify “or” criteria in this row
Query Design View
The query Design view has a shortcut that can help you and here is how it works:
- Open your query in Design view (or create a new query, and add the fields you want to use). This example uses the Products table, and includes the ProductName and Price fields.
- Sort your table so that the records you are most interested in are at the top. If you want to find the most expensive products, then add a descending sort on the Price field.
- In the Query Tools | Design.Query Setup.Return box, choose a different option.
Ad SQL Guide