Chapter 6. Keeping Your Information Accurate

Keeping Your Information Accurate

Chapter 6 at a Glance

In this chapter you will learn to:

  • Use Data Type settings to restrict data.

  • Use Field Size properties to restrict data.

  • Use input masks to restrict data.

  • Use validation rules to restrict data.

  • Use lookup lists to restrict data.

  • Update information in a table.

  • Delete information from a table.

Depending on how much information you have and how organized you are, you might compare a database to an old shoebox or a file cabinet, into which you toss items such as photographs, bills, receipts, and a variety of other paperwork for later retrieval. However, neither a shoebox nor a file ...

Get Microsoft® Office Access 2003 Step by Step now with the O’Reilly learning platform.

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