Chapter 5. Entering, Editing, and Validating Data in Tables

Ease of data entry is a primary criterion for an effective database development environment. Most of your Access database applications probably use forms for data entry. In many instances, however, entering data in Table Datasheet view is more expeditious than using a form, especially during the database development cycle. For example, it is a good idea to test your proposed database structure before you commit to designing the forms and reports, because changing table and field names or altering relationships between tables after you create a collection of forms and reports, involves a substantial amount of work.

To test the database design, you often need to enter test data. In this ...

Get Special Edition Using Access 97, Second Edition 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.