Chapter 7

Types, Masks, and Triggers


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

Get Access 2019 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.