Microsoft® Office Access 2003 Step by Step

Chapter 5 Locating Specific Information

Creating a Query in Design View To sort a field in ascending or descending order

1. Open the table in Datasheet view.

2. Click anywhere in the column you want to sort, and then click the Sort Ascending or Sort Descending button.

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

4. To sort on more than one column of information, arrange the columns so that they are side-by-side in the order you want to sort them, select the columns, and then use the Sort buttons.

Filtering Information in a Table To filter a table by selection

1. Open the table in Datasheet view.

2. Click any instance of the selection by which you want to filter, and then click the Filter By Selection button.

Filtering Information in a Table To remove a ...