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


  • Click Ascending (

    Click Descending (

    Access sorts the table ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.