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 ...
Get Microsoft® Access® 2010: Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.