GCFLearnFree.org

Your videos are excellent: short, sweet, and to the point.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2003
  • Filtering Records

Access 2003

Single page view print copy

Filtering Records

Saving a filter

Access defaults to displaying all records in a table. Filters are not initially applied to a table. Filtering table records actually change the table design. When you attempt to close a table after a filter, Access will prompt you to save the changes to the table design.

To save a filter:

  • Exit the table.
  • Click the "Yes" button in response to the question, Do you want to save changes to the table?

    Save Changes Confirmation

    The filter order is saved.

When you open the table or form later, all records will be visible. Click the Apply Filter button to reapply the filter. However, Access saves only the last filter you create.

You can apply filters to filtered data to narrow your search even further.

To cancel a filter:

  • Exit the table.
  • Click the "No" button in response to the question, Do you want to save changes to the table?

    The change is not saved; the table remains in its original design.
previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.