Microsoft Office Tutorials and References
In Depth Information
To navigate the Position Data form:
1. Press the Tab key to move to the PositionTitle field value, and then press the End key to
move to the Experience field. Because the Experience field is a yes/no field, its value is not
highlighted; instead, a dotted outline appears around the field name to indicate that it is
the current field.
2. Press the Home key to move back to the PositionID field value. The first record in the
Position table still appears in the form.
3. Press the Ctrl+End keys to move to the Experience field for record 64, which is the last
record in the table. The record number for the current record appears in the record num-
ber box between the navigation buttons at the bottom of the form.
4. Click the Previous Record navigation button
to move to the Experience field in
5. Press the
key twice to move to the EndDate field in record 63.
6. Click the insertion point between the numbers “0” and “6” in the EndDate 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
7. Click the First Record navigation button to move to the EndDate 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 EndDate field value in record 2,
the next record.
Elsa asks you to display the records for The Clipper Ship Inn, whose EmployerID value
is 10145, because she wants to review the available positions for this employer.
Finding Data Using a Form
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; then you enter the value you want Access to match in
the Find and Replace dialog box. You can use the Find command by clicking the toolbar
Find button or by using the Edit menu.
Finding Data in a Form or Datasheet
Make the field you want to search the current field.
Click the Find button on the toolbar to open the Find and Replace dialog box.
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 all records in the Position table for The Clipper Ship Inn, whose
EmployerID is 10145.