How to Access and Delete Multiple Query Tables

Using the Microsoft Office Access application, you can maintain databases and run queries to receive reports that evaluate your data. If you have created multiple query tables within your database file, you can remove all of the tables at once. Removing multiple query tables will not delete any related tables or records from your database. However, you should keep in mind that if the table is linked to another table, the link will no longer be valid.

Instructions

1. Open the Microsoft Access application on your computer. Click on the "File" option on the main menu bar.

2. Select the "Open" option and then locate the database that includes the multiple query tables you want to delete.

3. Click on the database file so it's highlighted and then click on the "Open" button. Your database will open in the Access application.

4. Press the "Ctrl" key on your keyboard and then select all of the query tables you want to delete.

5. Press the "Delete" key with all of the tables highlighted and then click on the "Yes" button in the dialog box that appears.

6. Click on the "Yes" button again, and all of your query tables will be removed.

References

• Microsoft Office: Delete One or More Records From an Access Database
• Microsoft Office: Open an Existing Database