O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required