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 Database window and press the Delete key (or choose the Delete command from the Edit menu). Access opens the dialog box shown in Figure 5-5 on the next page, which asks you to confirm or cancel the delete operation.

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

Get Microsoft® Office Access 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.