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.

Start course button

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.

Topics in this course

  1. Easy math, sorts, and searches

  2. Never get out of sorts

  3. Filters: rules to see by

  4. A simple date filter

  5. Search for specific records

  6. Practice

  7. Quick reference card

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!