Sorting and Filtering Records
When working in Access sort data to make it easier to work with. In Access filter data as well so you see only what you want to see.
- Open our practice database.
- Open the query called Cakes and Pies Sold.
- Apply a filter to the Product Types field that shows only Cakes.
- In the Sum of Quantity field, apply a number filter that only shows numbers greater than or equal to five.
- Apply an ascending sort to the Sum of Quantity field.