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

Get Access 2013 For Dummies 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.