Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
 Datasheets II: Sum, sort, filter, and find your data 
 
  Overview  
 Show/Hide lesson sections Easy math, sorts, and searches
  Feedback  
 Quick Reference Card Quick Reference Card  
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Bookmark and ShareShare
Overview
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.

Don’t have the 2007 Office release? You can download a free 60-day trial or buy it now.

  • Length: 20–30 minutes
  

Next

GOALS

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
  
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.
AUDIO TEXT

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.

  
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.
  Go to previous page (disabled)    Next Go to next page
advertisement