- Open a datasheet, or open a form in Form view.
- Click the record you want to delete.
- Click Delete Record on the toolbar.
Note When you delete data, you might want to delete related data in other tables. For example, if you delete a supplier, you probably want to delete the products that the supplier supplies. In some cases, you can make sure the proper data is deleted by enforcing referential integrity and turning on cascade deletions.
Delete a record in a data access page
Important Once you delete a record, you cannot undo the deletion from the database.
- On the record navigation toolbar, click Delete .
Note If you don't see the Delete button, it means one of the following:
- The page does not support deletions.
- The designer of the page has customized the button. Look for custom instructions on how to use the page, or contact the designer.