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.

Sorting Records image2

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.

Finding records image3

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.

 

 

 

 

 

 

next section >