You people are utterly amazing. I use and recommend you all the time!”

Online Learner

Creating Opportunities For A Better Life.®

Access 2007

Single page view print copy

Filtering Records

Challenge!

If you haven't already done so, save the sample Ready2Read database on your own computer.

  • Use the Filter by Field method to filter the Customers table to find all customers from NC.
  • Use the Filter by Selection method to filter the Customers table, looking for all NC customers NOT in Raleigh.
    Hint: Use the Does Not Equal option.
  • Practice toggling between the filtered results and the unfiltered tables.
  • Apply an Advanced Filter on the Books table to find all of the Kids books, sorted by price with the highest price first.
  • Save your Advanced Filter with whatever name you choose.
1 2 3 4 5 6