Microsoft Office Tutorials and References
In Depth Information
Navigating a Form
Oren wants to use the Customer Data form to view some data in the Customer table. As
you saw earlier, you use Layout view to modify the appearance of a form. To view, navi-
gate, and change data using a form, you need to display the form in Form view. As you
learned in Tutorial 1, you navigate a form in the same way that you navigate a table
datasheet. Also, the navigation mode and editing mode keystroke techniques you used
with datasheets in Tutorial 3 are the same when navigating a form.
The Customer Data form is already displayed in Form view, so you can use it to navi-
gate through the fields and records of the Customer table.
To navigate the Customer Data form:
1. Press the Tab key twice to move to the First Name field value, and then press the
End key to move to the E-mail Address field.
2. Press the Home key to move back to the Customer ID field value. The first record
in the Customer table still appears in the form.
3. Press the Ctrl+End keys to move to the E-mail Address field for record 40, which is
the last record in the table. The record number for the current record appears in
the Current Record box between the navigation buttons at the bottom of the form.
4. Click the Previous record navigation button
to move to the E-mail Address
field in record 39.
5. Press the key twice to move to the Zip field in record 39.
6. Click the insertion point between the numbers “7” and “5” in the Address field
value to switch to editing mode, press the Home key to move the insertion point to
the beginning of the field value, and then press the End key to move the insertion
point to the end of the field value.
7. Click the First record navigation button to move to the Address field value in
the first record. The entire field value is highlighted because you have switched
from editing mode to navigation mode.
8. Click the Next record navigation button
to move to the Address field value in
record 2, the next record.
Next, Oren asks you to display the record for the Three Tulips Café, one of Belmont
Landscapes’ customers. The paper form containing the original contact information for
this customer was damaged. Oren recently contacted the owner of the café and obtained
all the customer information again. Now Oren wants to view the data for this customer
in the Customer table to make sure it is correct.
Finding Data Using a Form
As you learned in Tutorial 3, the Find command lets you search for data in a form or
datasheet so you can display only those records you want to view. You choose a field to
serve as the basis for the search by making that field the current field, and then you enter
the value you want Access to match in the Find and Replace dialog box.