- Display records in datasheets
- Sort and filter records
- Aggregate data
- Preview and print records
We will continue to exploit datasheet mode to learn techniques to view—and change the view—of information in Access. You will learn how to change the order of columns displayed in a datasheet for ease of analysis. Also, Access provides multiple methods for sorting and filtering data, as well as aggregating data for better analysis.
Sort and Filter
You can view the transcript for “Access: Sorting and Filtering Records” here (opens in new window).
Aggregate Tools
You can view the transcript for “Aggregate Queries in Access (Totals Queries)” here (opens in new window).