Filtering Records

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

Challenge!

  • Open the Content Management database.
  • Open the Contacts table in Datasheet view.
  • Filter by Selection on any record that reveals a City of "Apex".
  • Remove the filter.
  • Perform a Filter Excluding Selection on any record that reveals a City of "Raleigh".
  • Remove the filter.
  • Filter By Form on the City of "Raleigh".
  • Remove the filter.
  • Close the Contacts table, and if displayed click the "No" button in response to the Do you want to save changes to the design of table 'Contacts' system prompt.