O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, 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 12. Keeping Your Information Accurate

Chapter at a Glance

Keeping Your Information Accurate

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

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