GCFLearnFree.org

As a website designer, I can say you have one of the best learning websites.”

Online Learner

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

Access 2003

Single page view print copy

Sorting Records

Challenge!

  • Open the Contact Management database.
  • Open the Contacts table in Datasheet view.
  • Perform the following single-field sorts:
    • Sort (descending or ascending) the records by the Last Name field.
    • Sort (descending or ascending) the records by the State/Province field.
    • Sort (descending or ascending) the records by the Contact ID field.
  • Perform the following multi-field sorts:
    • Move the City field to the right of the State field and sort (descending or ascending) the records by State and City.
    • Move the City field to the right of the Last Name field and sort (descending or ascending) the records by Last Name and City.
  • Remove the last sort performed.
  • Cancel the sort when you close the Contacts table, and 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 next
Terms Of Use

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