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 ...

Get Teach Yourself VISUALLY™ Microsoft® Office 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.