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.

Sort Records

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

Sort Records


Click Ascending (

Click Descending (

Access sorts the table ...

Get Microsoft® Office 2007 Simplified® now with the O’Reilly learning platform.

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