Sorting Data Records

One of the simplest operations you ll perform with your Access data involves sorting it. You can sort data by using either the datasheet or the data-entry form for a particular table. To sort records, follow these steps:

1. Open the database you want to use.

2. In the database window, double-click the data table or form you want to sort.

3. Click in the field that will be the organizing point for arranging your records. (For example, if you want to sort the records alphabetically by company name , click in the Company field. If you want the records sorted by customers last names , click in the Lastname field.)

4. Click Sort Ascending or Sort Descending in the Standard toolbar. If you click Sort Ascending, the records are arranged from A to Z. If you click Sort Descending, the records appear arranged from Z to A.

   Note  

   If you prefer to use the menus , you can choose Sort from the Records menu and then choose Sort Ascending or Sort Descending from the submenu.