Office 2010 Made Simple

Sorting a Database by One or More Fields

When you need to examine the data in your database, you can sort it either by a single field or by using multiple fields.

TIP: If you need to be able to return a database to its original order, include a column with sequential numbers in it. These numbers may be part of your records (for example, sequential sales numbers for transactions) or simply ID numbers for the records; in either case, you can use AutoFill to enter them quickly (see Chapter 11: “Creating Worksheets and Entering Data” for instructions on using AutoFill). To return the database to its original order, you can then sort it by this column.

Sorting Quickly by a Single Field

To sort a database by a single field, click the column you want ...