Searching for Data

After you enter data into the database, you can use the criteria form or Excel's AutoFilter feature to search for data. The criteria form lets you use comparison criteria in two ways to find records: (1) enter matching data, or (2) use comparison operators.

Entering Matching Data Criteria

You can find specific records using a criteria form, which is a subset of the data form, to create a special criteria record. You enter a word, phrase, or value into the criteria record. This type of criteria is a comparison criteria.

You can also use the following wildcards, which are characters that represent information you don't know or information that is common to many records, when specifying criteria:

  • A question mark (?) represents ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.