Learning Outcomes
- Sort and filter records
There are multiple ways to sort data in Access. The first option is to use the toolbar shown in the example below. The tools function as you would expect from any MS Office tool bar.
Another way to quickly sort data in a table is to use the sorting capability built-in to the column headers, as shown in the example below. Clicking on the arrow in each header will sort the records in ascending or descending order (alternating).
Filtering your view of the data set can be accomplished in several ways. Perhaps the quickest is to right-click on the value you wish to filter by to open the dialog in the example below.
In this case, if we wish to filter by the value “Closed” and can choose one of four filtering elements: “Equals,” “Does Not Equal,” Contains,” or “Does Not Contain.”
PRactice Question
Contribute!
Candela Citations
- Sorting Data. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution