Chapter 6. Keeping Your Information Accurate

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

Get Microsoft® Office Access 2003 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.