O'Reilly logo

Teach Yourself VISUALLY™ Microsoft® Office 2007 by Sherry Willard Kinkoph

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 21. Finding and Querying Data

Sort Records

One of the easiest ways to manipulate your database data is to perform a sort. Sorting allows you to put your database records in a logical order to match any criteria that you specify. For example, with a contacts database, you might want to sort the records alphabetically or based on the zip code. You can sort in ascending order or descending order.

You can either sort records in a table, or you can use a form to sort records. See Chapter 19 to learn more about Access tables. See Chapter 20 to more learn about forms.

Sort Records

Sort Records

SORT A TABLE

  • Click Ascending (

    Click Descending (

    Access sorts the table ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required