Datasheets II: Sum, sort, filter, and find your data
Perform calculations on your data quickly and easily. In Access, your data resides in tables. Most of the time, you work with your information in Datasheet view — a grid of rows and columns that displays your data, much like an Excel worksheet. This course explains how to use several new features in Datasheet view, including the Totals row, tools for sorting and filtering data, and a handy Search feature.
About this course
This course includes:
One practice session for hands-on experience. Practice requires Access 2007.
A Quick Reference Card you can take away from the course.
After completing this course you will be able to:
Show the Totals row in a datasheet
Sum, count, and average the data in a column
Sort and filter the data in one or more columns
Use Search to find data in a table
Before you begin
If you're new to Access, it's a good idea to complete this course and familiarize yourself with datasheets.
Links in the Quick Reference Card at the end of this course also take you to more information about using datasheets and Datasheet view.