Microsoft Office Tutorials and References
In Depth Information
Sorting enables you to arrange your database
records in a logical order to match any criteria
that you specify. For example, with a contacts
database, you might sort the records
alphabetically or based on the ZIP code. You can
sort in ascending order or descending order. You
can either sort records in a table, or you can use a
form to sort records.
Sort a Table
1 Open the table you want to sort.
2 Position your mouse pointer over
the column header for the field by
which you want to sort (the mouse
pointer changes to ) and click.
3 Click the Home tab on the Ribbon.
4 Click a sort button.
Click Ascending to sort the
records in ascending order.
Click Descending to sort the
records in descending order.
Access sorts the table records
based on the field you choose.
This example sorts the records
alphabetically by last name in
In the prompt box that appears
when you close the table, you can
click Yes to make the sort
permanent or No to leave the
original order intact.