O'Reilly logo

Access 2019 For Dummies by Ken Cook, Laurie A. Ulrich

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 7

Types, Masks, and Triggers

IN THIS CHAPTER

check Locating your table settings (and I don’t mean flatware!)

check Changing how data displays

check Keeping bad data out with input masks

check Understanding required fields

check Performing detailed testing through validation

check Adding data automatically with default values

If you have a sound table structure but poor data collection, your database won’t report anything of interest to its intended audience. You know the old saying, “garbage in, garbage out”? This chapter helps you limit the garbage that is put into your tables by detailing five tools Access puts at your disposal. (Access doesn’t call them tools; it calls them properties.)

remember You don’t want the task of going back and cleaning up your data after it has all been typed. Better to type it correctly ...

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