Microsoft® Access® 2010: Step by Step

Chapter 6. Maintain Data Integrity

Chapter at a Glance

In this chapter, you will learn how to
✓	Restrict the type of data.
✓	Restrict the amount of data.
✓	Restrict the format of data.
✓	Restrict data by using validation rules.
✓	Restrict data to values in lists.
✓	Restrict data to values in other tables.

Depending on how organized you are, you might compare a database to a cardboard box or to a file cabinet, into which you toss items such as bills, receipts, statements, and a variety of other paperwork for later retrieval. The box or file cabinet does not restrict what items you can place in it (unless they are simply too big to physically fit) or impose ...