Access 2007 FAQ
Is there a quick and easy way to clear all the records in the Northwind 2007 sample database?
It's easier than you might think. Follow these steps:
Make sure you have Enabled the Content to run VBA code and all macros. See this page if you need more information on enabling the content in your database: Related Topic
Click the top of the Navigation Pane and select Object Type under Navigate to Category, as seen in the following screenshot.
Click the top of the Navigation Pane and select Macros under Filter by Group, as shown below.
Double click on the macro object called Delete All Data in the Navigation Pane, as seen in the following screenshot.
Click Yes on the confirmation message to delete all the data. (You'll also be prompted about deleting the records from the tables.)
You might want to compact the database after this procedure: Office Button | Manage | Compact and Repair Database, as seen below.