3. Designing Forms for Efficient and Accurate Data Entry
IN THIS CHAPTER
Preventing Errors by Validating Data
Using Controls to Limit Data Entry Choices
Case Study: Using an Option Group to Select the Shipper
Entering Data with ActiveX Controls
Collecting Form Data via Email
Data entry is one of those tasks that I describe as “dangerous” because it’s a chore that’s both tedious and important. It’s tedious because entering dozens or hundreds of records is no one’s idea of fun. It’s important because the data must be entered accurately; otherwise, any analysis of the data becomes at best misleading and at worst just plain wrong. The danger, then, lies in the fact that data entry is prone to errors but can’t afford to have any.
As a ...
Get Business Solutions Microsoft® Office Access 2007 Forms, Reports, and Queries 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.