Chapter 11. Locating Specific Information

Chapter at a Glance

Locating Specific Information

In this chapter, you will learn to:

Sort and filter information in a table.

Filter information by using a form.

Locate information that matches multiple criteria.

Create a query manually or by using a wizard.

Perform calculations by using a query.

A database is a repository for information. It might contain only a few records or thousands of records, stored in one table or multiple tables. No matter how much information a database contains, it is useful only if you can locate the information you need when you need it. In a small database you can find information simply by scrolling through ...

Get 2007 Microsoft® Office System Step by Step, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.