1. Computing

Excel Data Entry Form

By

8 of 9

Searching for Records Using One Field Name
Using the Form to Enter Data in Excel

Using the Form to Enter Data in Excel

© Ted French

The Criteria button allows you to search the database for records using one or more field names - such as name, age, or program.

Searching for Records Using One Field Name

For help with this example, see the image above.

  1. Click on the Criteria button in the form.

  2. Clicking on the Criteria button clears all the form fields but does not remove any data from the database.

  3. Click on the Program field and type Arts as we want to search for all students enrolled in the Arts program at the college.

  4. Click on the Find Next button. The record for H. Thompson should appear in the form as she is enrolled in the Arts program.

  5. Click on the Find Next button a second and third times and the records for J. Graham and W. Henderson should appear one after the other as they are also enrolled in the Arts program.

The next step of the tutorial includes an example of searching for records that match multiple criteria.

©2014 About.com. All rights reserved.