Microsoft® Access® 2010 In Depth

6. Entering, Editing, and Validating Access Table Data

Ease of data entry is a primary criterion for an effective database development environment. Most of your Access database applications probably will use forms for data entry. In many instances, however, entering data in Table Datasheet view is quicker than using a form, especially during the database development cycle. For example, it’s a good idea to test your proposed database structure before you commit to designing the forms and reports. Although the Name AutoCorrect feature reduces object name discrepancies, changing table and field names or altering relationships between tables after you create a collection of forms and reports can involve a substantial amount of work.

To test the ...