Delete a record in Datasheet or Form view

1. Open a Datasheet, or form in Form view.
   
   
2. Click the record you want to delete.
   
   
3. 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.

Learn about referential integrity in a Microsoft Access database.

Learn about referential integrity in a Microsoft Access project.