Microsoft Office Tutorials and References
In Depth Information
field containing the digits 517 in any part of the field, but this search would also find
records with the digits 517 in any part of the phone number. To find only those records
with the 517 area code, you’ll use the * wildcard character.
To find the records using the * wildcard character:
1. Make sure the Find and Replace dialog box is still open.
2. Click anywhere in the Customer Data form to make it active, and then press the Tab
key seven times to move to the Phone field. This is the field you want to search.
3. Click the title bar of the Find and Replace dialog box to make it active. The Look In
box now displays Phone, indicating that the Phone field will be searched.
4. Double-click tulips in the Find What text box to select the entire value, and then
type 517* .
5. Click the Match arrow, and then click Whole Field . Because you’re using a wild-
card character in the search value, you want Access to search the whole field.
With the settings you’ve entered, Access will find records in which any field value
in the Phone field begins with the digits 517.
6. Click the Find Next button. Access displays record 36, which is the first record
found for a customer with the area code 517. This customer is located in East
Lansing. Notice that the search process started from the point of the previously
displayed record in the form, which was record 35.
7. Click the Find Next button. Access displays record 8, which is the next record
found for a customer with the area code 517. This customer is located in Lansing.
Notice that the search process cycles back through the beginning of the records in
the underlying table.
8. Click the Find Next button. Access displays record 12, the third record found; this
customer is also located in Lansing.
9. Click the Find Next button. Access displays record 25 for another customer
located in Lansing, with the area code 517.
10. Click the Find Next button. Access displays record 33 for another customer
located in Lansing.
11. Click the Find Next button. Access displays a dialog box informing you that the
search is finished.
12. Click the OK button to close the dialog box. Oren notes that all customers with an
area code of 517 are located in either Lansing or East Lansing.
13. Click the Cancel button to close the Find and Replace dialog box.
Oren has identified some updates he wants you to make to the Customer table. You’ll
use the Customer Data form to update the data in the Customer table.
Maintaining Table Data Using a Form
Maintaining data using a form is often easier than using a datasheet, because you can
concentrate on all the changes required to a single record at one time. In Form view, you
can edit the field values for a specific record, delete a record from the underlying table,
or add a new record to the table. You already know how to navigate a form and find