Deleting Table Records

In Access 2000 deleting table records is simpler than you think. Just follow the directions provided in this free lesson.

Introduction

By the end of this lesson, you should be able to:

  • Delete table records

Deleting table records

Just as you may need to edit data in a table, you may need to delete an entire table record.

To delete a table record:

  • Click the Record Selector to the left of the record's first field to select the entire record.

Enter Text

  • Press the Delete key or click the Delete Record button on the toolbar. Delete Record button

OR

  • Right-click the Record Selector and choose Delete Record from the shortcut menu.

Shortcut menu

Deleting multiple records

You may need to delete multiple table records.

To delete more than one table record:

  • Drag on the Record Selector to select consecutive records.

Selecting consecutive records

OR

  • Hold the Shift key and click to select consecutive records.

THEN

  • Press the Delete key, click the Delete Record button, or right-click and choose Delete Record.

Important to remember:

Important pointDeleting records cannot be undone. When you attempt to delete a table record, a dialog box appears asking you if you are sure you want to delete the record(s).

Important pointSaving your work: When you are finished editing or deleting table data, close the table. Unlike Word, Excel, and PowerPoint, you will not be prompted to save the data you entered. Each record was saved as you entered it.

Important pointIf you have changed table layout, you'll be prompted to save the changes.

Challenge!

Practice deleting a table record by doing the following:

  • Open the Great Lake Elementary School sample database.
  • Open the Teachers table.
  • Practice selecting consecutive records using one of the methods described in the lesson.
  • Using the Record Selector, select the last record (it should be Regina Gibbs) in the table.
  • Press the Delete Record button on the toolbar. Choose Yes when prompted if you are sure you want to delete a record.
  • Close the Teachers table.
Note: Some of the tables in the databases are relational. If you attempt to delete a related record, the following error message displays:

Delete error

lesson arrowIf you get this message, click OK. In the short term, don't worry about deleting the record.