Sorting Records

When working in Access sort data to make it easier to work with, including text-based and numerical data in your Access database.

Sorting records

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 few ways:

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.