Access 2007

Sorting Records

Watch the video! (3:34min)

Download the example to work along with the video.

Sorting records

Sorting is probably the simplest way to look at data because it keeps similar things together. In our bookstore database, for example, we could sort our data a number of ways:

• We could sort orders based on the order date.
• We could sort customers by the state in which they live, or by their zip codes.
• We could sort our books by author, category, or price.

Access 2007 allows you to sort the records in your database tables based on a field or value that is either text (like an author's last name) or numerical (like a customer's zip code or a book's price). Depending on the type of value, Access offers different sorting options.