O'Reilly logo

Sams Teach Yourself Microsoft Access 2002 in 21 Days by Craig Eddy, Paul Cassel, Jon Price

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 9. Refining Your Tables

You, as a developer, need to control the quality of the data entered in to your application. This applies not only to applications distributed to far-flung places, but to applications you will use yourself.

As I write this lesson, I’m working with a large medical provider who, at this point, can’t report its research findings to its granting agency. The reason is that the designer of the database where the research was supposed to be compiled failed to institute good data validation procedures. The resulting chaos caused by questionable data is costing this provider a lot of money (my fees) plus is putting its grant in jeopardy. Ignore this part of database design only at your extreme peril.

Today You Will Learn

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