Chapter 6. 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 ...

Get Microsoft® Office Access™ 2007 Step by Step 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.