With the table open in Datasheet view, click anywhere in the column of the field on which you want to base the sort, and then click the Sort Ascending button or the Sort Descending button. (To sort on more than one column of information, arrange them so they are side-by-side in the order you want to sort them, select the columns, and then use the Sort buttons.)

To reverse the sort order, click the opposite Sort button.

Open the table in Datasheet view.

Select the information you want to use as the filter criteria.

Click the Filter By Selection button.

If necessary, repeat steps 2 and 3 to filter the information further.

Click the Remove Filter button to redisplay all of the table's records.