Microsoft® Office Access™ 2007 Step by Step

Chapter 7. Keeping Your Information Accurate

Chapter at a Glance

In this chapter, you will learn to:
✓	Restrict the type and amount of data in a field.
✓	Specify the format of data in a field.
✓	Restrict data by using validation rules.
✓	Create a simple or multi-column lookup list.
✓	Update information in a table.
✓	Delete information from a table.
✓	Prevent database problems.

Depending on how much information you have and how organized you are, you might compare a database to an old shoebox or to 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 ...