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.
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.
The standard option is All, which gets all the matching records. However, you can choose 5, 25, or 100 to get the top 5, 25, or 100 matching records, respectively. Or, you can use a percentage value like 25 percent to get the top quarter of matching records. In the next lesson create a query in Design view.