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 ...

Get Office 2010 Made Simple now with O’Reilly online learning.

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