Chapter 5. Locating Specific Information

Locating Specific Information

Chapter 5 at a Glance

In this chapter you will learn how to:

  • Sort information.

  • Filter information in a table.

  • Filter by form.

  • Locate information that matches multiple criteria.

  • Create a query in Design view.

  • Create a query with a Wizard.

  • Perform calculations in a query.

A database is a repository for information. It might hold a few records in one table or thousands of records in many related tables. No matter how much information is stored in a database, 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 Microsoft® Office Access 2003 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.