Business Solutions Microsoft® Office Access 2007 Forms, Reports, and Queries

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

From Here

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