Microsoft Office Tutorials and References
In Depth Information
Reference Window | Finding Data in a Form or Datasheet
• Open the form or datasheet, and then make the field you want to search the current field.
• In the Find group on the Home tab, click the Find button to open the Find and Replace
• In the Find What text box, type the field value you want to find.
• Complete the remaining options, as necessary, to specify the type of search to conduct.
• Click the Find Next button to begin the search.
• Click the Find Next button to continue searching for the next match.
• Click the Cancel button to stop the search operation.
You need to find the record for the Three Tulips Café. Oren doesn’t recall the Cus-
tomer ID value for this customer, so you’ll base the search on the Company field name.
To find the record using the Customer Data form:
1. Click in the Company field value (which is empty for the current record) to estab-
lish Company as the current field. This is the field you need to search.
Instead of searching for the entire company name, Three Tulips Café, you can
search for a record that contains part of the name anywhere in the Company field
value. Performing a partial search such as this is often easier than matching the
entire field value and is useful when you don’t know or can’t remember the entire
2. In the Find group on the Home tab, click the Find button. The Find and Replace
dialog box opens. The Look In box shows that the Company field will be searched.
You’ll search for records that contain the word “tulips” in the company name.
3. In the Find What text box, type tulips . Note that you do not have to enter the
word as “Tulips” with a capital letter “T” because the Match Case option is not
selected in the Find and Replace dialog box. Access will find any record containing
the word “tulips” with any combination of uppercase and lowercase letters.
4. Click the Match arrow to display the list of matching options, and then click Any
Part of Field . Access will find any record that contains the word “tulips” in any
part of the Company field.
5. Move the Find and Replace dialog box by dragging its title bar so that you can see
both the dialog box and the form at the same time. See Figure 4-12.