Filtering Records

In Access XP filtering records may seem confusing at first. This free lesson offers step-by-step instructions.

Challenge!

  • Open the Contacts table in Datasheet view.
  • Apply the following filter by selection filters:
    • Filter by selection on any record that reveals a State of "North Carolina".
    • Filter by selection on any record that reveals a City of "Cary".
    • Remove the filter.
  • Apply the following filter excluding selection filters:
    • Filter excluding selection on any record that reveals a City of "Cary".
    • Remove the filter.
    • Filter excluding selection on any record that reveals a State/Province of "North Carolina".
    • Remove the filter.
  • Apply the following filter by form filters:
    • Filter by form on the City of "Raleigh".
    • Remove the filter.
  • Close the Contacts table, and if displayed, click No in response to the Do you want to save changes to the design of table 'Contacts'? system prompt.