O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required