2] How to delete records in a datasheet. There are two methods to delete a record in the database table. Method one is to right-click the left end of the record that contains data.