If you have an Access database, you can delete a table by using theDeleteTable cmdlet. The DeleteTable cmdlet deletes the table and all its data. You can also use theDeleteTableByRange cmdlet to delete a table by its first or last column. To delete a table in Access, use the following steps:

  1. Open Access and click on the Database button.
  2. In the Database window, click on the Tables button.
  3. Click on the Table name that you want to delete.
  4. Click on the Delete button.
  5. In the confirmation dialog, confirm that you want to delete the table by clicking on Yes in both boxes.
  6. The table is deleted and its data is removed from your Access database!