How to Sort Records in a Microsoft Access Table
Sorting records simplifies information retrieval and makes it easier for you to arrange your database content. These instructions are for Access 97.
Other People Are Reading
Instructions
-
-
1
Open your database file in Microsoft Access.
-
2
Use the F11 key to open the Database window.
-
-
3
Click on either the Form tab or the Table tab, depending on which view you want to work in. A list of forms or tables appears.
-
4
Select the table or form you want to work with and click Open.
-
5
Click the field that you want to use for sorting records.
-
6
From the Records menu, click Sort Ascending if you want to sort from 0 to 9 or from A to Z.
-
7
Click Sort Descending if you want to sort the field from 9 to 0 or from Z to A.
-
1
Tips & Warnings
To undo a sort order, click Remove Filter/Sort in the Records menu.
