You can change the order of records by using sort buttons. You use this feature when you want to view your records in a particular order. For example, you might want to first view the records in order by company name, and later view them in order by most recent order date. The wonderful thing is that with this easy-to-use feature, changing the sort order involves a simple mouse click.
To sort on a field, follow these steps:
Click anywhere within the field.
Click the Sort Ascending button or click the Sort Descending button. Access reorders the form data based on the designated column.
Another way to do this is to right-click a field and then choose Sort Ascending or Sort Descending.