O'Reilly logo

Microsoft® Access® 2010: Step by Step by Joan Lambert and Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. Maintain Data Integrity

Chapter at a Glance

Maintain Data Integrity

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 any ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required