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.

Challenge!

  1. If you haven't already, download our sample database and open it.
  2. Open the query called Cakes and Pies Sold.
  3. Apply a filter to the Product Types field that shows only Cakes.
  4. In the Sum of Quantity field, apply a filter that only shows numbers greater than five.
  5. Apply an ascending sort to the Sum of Quantity field.
  6. Save the database.