Microsoft Office Tutorials and References
In Depth Information
Sorting a Database
Access filters your database table according to your criteria.
8. Repeat Steps 5 through 7 for each additional filter you want to add.
Clearing a filter
When you apply a filter to a database table, you see only those records that
match that filter. Access displays a Filtered message at the bottom of the
screen to let you know when you’re looking at a filtered database table.
To remove a filter so you can see all the records, choose one of the following:
Click the Toggle Filter icon in the Sort & Filter group.
Click the Filtered or Unfiltered button on the status bar near the bottom
of the screen.
Access temporarily turns off any filters so you can see all the information
stored in your database table.
When you choose the Save command (Ctrl+S) to save a database table, Access
also saves your last filter. The next time you open that database table, you’ll
be able to use the last filter you created. If you want to save multiple filters,
you’ll have to save them as a query (see the section “Querying a Database”
later in this chapter).
Sorting a Database
Sorting simply rearranges how Access displays your information. Sorting can
be especially handy for rearranging your records alphabetically by last name,
by state, or by country. You can also sort data numerically so that customers
who buy the most from you appear at the top of your database table, while
customers who don’t buy as much appear near the bottom.
To sort a database table, follow these steps:
1. In the All Tables pane on the left of the screen, double-click the name
of the database table you want to sort.
Access displays the Datasheet view of your database.
2. Click the Home tab.
3. Click in a field (column) that you want to use for sorting.
4. Click the Ascending or Descending icon in the Sort & Filter group.
Access sorts your records and displays an Ascending or Descending
icon in the field name so you know you’re looking at a sorted list, as
shown in Figure 17-7.