To delete the data that is currently in a table, you use the DELETE statement, which is commonly referred to as a delete query. This is also known as truncating a table. The DELETE statement can remove one or more records from a table and generally takes this form:
DELETE FROM table list
Recently I caught into a duplicate record issue in my access 2016 database. So, if you have any such problem then do try out this fixes:
http://www.accessrepairnrecovery.com...crosoft-access