Microsoft Office Tutorials and References
In Depth Information
Chapter 11: Getting on the Data List
advance to a
in the data
as the last
row of the
✓ Locate the record you want to edit in the database by bringing up its
data form. See the following two sections (“Moving through records in
the data form” and “Finding records with the data form”) and Table 11-1
for hints on locating records.
✓ To edit the fields of the current record, move to that field by pressing
Tab or Shift+Tab and replace the entry by typing a new one.
Alternatively, press ← or → or click the I-beam cursor to reposition the
insertion point, and then make your edits.
✓ To clear a field entirely, select it and then press the Delete key.
To delete the entire record from the database, click the Delete button in the
data form. Excel displays an alert box with the following dire warning:
Displayed record will be permanently deleted
To delete the record displayed in the data form, click OK. To play it safe and
keep the record intact, click the Cancel button.
You cannot use the Undo feature to bring back a record you removed with
the Delete button! Excel is definitely not kidding when it warns permanently
deleted . As a precaution, always save a back-up version of the worksheet with
the database before you start removing old records.