How to Clear Table Data in MS Access

‍

‍

To clear data from a table in Microsoft Access, you can use one of the following methods:

‍

1. Open your Access database.
2. Go to the 'Create' tab in the Ribbon.
3. Click on 'Query Design'.
4. Add the table from which you want to delete data by clicking 'Add Selected Tables'.
5. In the 'Design View', click on the 'Delete' button in the Ribbon.
6. In the 'Query Design grid', under the 'Field' row, select the asterisk icon.
7. Click 'Run', the red exclamation mark on the Ribbon.
8. Go to the 'Navigation Pane' and click 'Close'.
9. Under 'Queries' select the Query you want to clear.
10. Click 'Run' to execute the query. You’ll be asked to confirm the deletion.
11. Click 'Yes' to delete all records in the table.
12. That's it! By using any of these methods it will permanently delete the data in the table.