Chapter 7
Types, Masks, and Triggers
IN THIS CHAPTER
Locating your table settings (and I don’t mean flatware!)
Changing how data displays
Keeping bad data out with input masks
Understanding required fields
Performing detailed testing through validation
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.)
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.
