Page 1 of 9PREVNEXT

Datasheets II: Sum, sort, filter, and find your data

Easy sums, sorts, and filters
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 self-paced lesson and one practice session for hands-on experience. Practice requires Access 2007.
  • A short test at the end of each lesson; tests are not scored.
  • 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.

Access 2007 makes it easier than ever to perform math functions on your data. With a new feature called the Totals row, you can sum, count, or average your data with just a few clicks.

Datasheet view also puts a set of sorting and filtering commands right at your fingertips, as well as a new Search feature to help you find data.

This course explains how to use those new tools, and in the process, see how they can help you answer some common business questions.

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

Page 1 of 9PREVNEXT