GCFLearnFree.org

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

Online Learner

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

Access XP

Single page view print copy

Filtering Records

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 the NO button in response to the Do you want to save changes to the design of table 'Contacts' system prompt.
previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

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