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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.