O'Reilly logo

Access 2013 For Dummies by Ken Cook, Laurie Ulrich Fuller

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 6

Types, Masks, and Triggers

In This Chapter

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

arrow Changing how data displays

arrow Keeping bad data out with input masks

arrow Understanding required fields

arrow Performing detailed testing through validation

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