In Access XP sorting records may seem confusing at first. This free lesson offers step-by-step instructions.
Sorting is one method that helps you find information quickly and easily in a database. Records can be sorted in ascending order (A-Z) and descending order (Z-A). You can sort by zip code, last name, first name, company, contact type (e.g., family, friend, relative), etc. You can even sort by contact type and then by last name within each contact type.
It's easiest to see the results of a sort if you work in Datasheet view.
To sort by Form view, switch to Form view, select the field you want to sort by, and click the Sort button on the toolbar. To see the results, use the status area to move through the records.