Sorting and Finding Records
Two of the most common database tasks are sorting records and searching for records that meet a particular condition. Fortunately, both of these operations are easy to perform while viewing the table datasheet.
To sort records by a particular field, select the field you want to sort. From the Records menu select Quick Sort then choose either Ascending or Descending order. Access quickly sorts the records by the selected field.
If you want to locate a record that contains a certain name or date use the Find command on the Edit menu. Type the search string in the Find What box and click Find First. Access will highlight the first record that contains the search string.