Microsoft Office Tutorials and References
In Depth Information
Filtering to Find Information
Sorting records
Follow these steps to sort the records in a database table:
1. In Datasheet view, click anywhere in the field by which you want to
sort the records.
2. On the Home tab, click the Ascending or Descending button.
You can also right-click a field name at the top of a column and choose
Sort A to Z or Sort Z to A on the shortcut menu. The menu choices
change based on the type of data. For Number fields, you can sort
smallest to largest and vice versa; for Date fields, choose to sort oldest to
newest, or vice versa.
You can sort on more than one field by clicking a field and sorting it, and
then clicking a second field and sorting it. Just make sure you sort the
fields in reverse order. For example, to sort the database by the Employee,
Customer, and Order ID fields, click in Order ID and sort it in ascending
order; click in Customer and sort it in ascending order; click in Employee
and sort it in ascending order. If you mess up and forget how the table is
sorted, click the Remove Sort button. This button is located on the Home tab
underneath the Ascending and Descending buttons.
Filtering to Find Information
Filtering isolates all the records in a database table that have the same field
values or nearly the same field values. Instead of all the records in the table
appearing on the datasheet, only records that meet the filtering criteria
appear, as shown in Figure 4-1.
Remove lters
Figure 4-1:
Results of
a filtering
operation.
Filter indicators
Search JabSto ::




Custom Search