O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a Query Manually

A query can do more than simply return a list of records from a table. You can use functions in a query to perform calculations on the information in a table to produce the sum, average, count, and other mathematical values.

When you want to work with more than one table, you need to move beyond filters and into the realm of queries. Common types of queries include the following:

  • A select query retrieves data from one or more tables and displays the results in a datasheet. You can also use a select query to group records and calculate sums, counts, averages, and other types of totals. You can work with the results of a select query in Datasheet view to update records in one or more related tables at the same time. This ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required