Part I: Access Building Blocks
234
You can select your search options in the Find tab and then click the Replace tab to continue the
process. However, it’s far easier to simply do the entire process using the Replace tab. Enter the
value you want to find and the value that you want to replace it with. After you’ve completed the
dialog box with all the correct information, select one of the command buttons on the side:l (^) Find Next: Finds the next field that has the value in the Find What field.
l Cancel: Closes the form and performs no find and replace.
l (^) Replace: Replaces the value in the current field only. (Note: You must use the Find Next
button first.).
l (^) Replace All: Finds all the fields with the Find What value and replaces them with the
Replace With value. Use this if you’re sure that you want to replace all the values; double-
check the Look In box to make sure you don’t replace the values in the entire datasheet if
you don’t want to.
Adding New Records
There are a number of ways to add a record to the datasheet:
l Click on the datasheet’s last line, where the record pointer is an asterisk.
l (^) Click the new record Navigation button (the furthest button on the right).
l Click the New command from the ribbon’s Records group.
l (^) Choose Go To ➪ New from the ribbon’s Find group.
l Move to the last record and press the down-arrow (↓) key.
l (^) Press Ctrl++ (plus sign).
Once you move to a new record, enter data into the desired fields and save the record.
Deleting Records
To delete records, select one or more records using the record selectors, and then press the Delete
key or click the Delete command in the ribbon’s Records group. The Delete command’s drop-
down list contains the Delete Record command, which deletes the current record, even if it’s not
selected. When you press Delete or choose the ribbon command, a dialog box asks you to confirm
the deletion (see Figure 6.11). If you select Yes, the records are deleted; if you select Cancel, no
changes are made.