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 live online training, plus books, videos, and digital content from nearly 200 publishers.