Microsoft Office® Access 2007 Inside Out

Deleting Tables

You probably won’t need to delete an entire table very often. However, if you set up your application to collect historical information—for example, total product sales by year—you’ll eventually want to delete information that you no longer need. You also might want to delete a table if you’ve made extensive changes that are incorrect and it would be easier to delete your work and restore the table from a backup.

To delete a table, select it in the Navigation Pane and press the Delete key (or click the Delete command in the Records group on the Home tab of the Ribbon). Access 2007 opens the dialog box shown in Figure 5-7, which asks you to confirm or cancel the delete operation.

Figure 5-7. This dialog box gives you the option of ...