Microsoft® Office Access 2003 Step by Step

Chapter 6. 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 ...