Deleting Information from a Table

Over time, some of the information stored in a database might become obsolete. The Products table in our sample database, for example, lists all the products the company currently offers for sale or has sold in the past. You can indicate that a product is no longer available for sale by placing a check mark in the Discontinued field. Discontinued products aren’t displayed in the catalog or offered for sale, but they are kept in the database for a while in case it becomes practical to sell them again. A similar situation could exist with customers who haven’t placed an order in a long time or who have asked to be removed from a mailing list but might still place orders.

To maintain an efficient database, it is a ...

Get 2007 Microsoft® Office System Step by Step 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.