Excel Data Entry Form

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 Multiple Field Names

Note: For help with this example, see the image above.

In this example we will search for all students who are 18 years of age and enrolled in the Arts program at the college. Only those records that match both criteria should be displayed in the form.

1. Click on the Criteria button in the form.


2. Click on the age field and type 18.


3. Click on the Program field and type Arts.


4. Click on the Find Next button. The record for H. Thompson should appear in the form since she is both 18 years old and enrolled in the Arts program.


5. Click on the Find Next button a second time and the record for J. Graham should appear since he too is both 18 years old and enrolled in the Arts program.


6. Click on the Find Next button a third time and the record for J. Graham should still be visible since there are no other records that match both criteria.

The record for W. Henderson should not be displayed in this example because, although he is enrolled in the Arts program, he is not 18 years old so he does not match both of the search criteria.

• Using a Form for Data Entry in Excel
• Finding the Data Entry Form Button
• Adding the Database Field Names
• Opening the Data Entry Form
• Adding Data Records with the Form
• Adding Data Records with the Form (con't)
• Using the Form's Data Tools
• Searching for Records Using One Field Name
• Searching for Records Using Multiple Field Names