• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Entering, Editing, and Valida... > Entering Data in Access Tables

Entering Data in Access Tables

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 introduced by Access 2000 reduces 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 database design, you must enter test data. In this instance, using Table Datasheet view to enter data makes more sense than using a form. Even if you import data from another database type or from a spreadsheet, you probably need to edit the data to make it compatible with your new application. The first part of this chapter concentrates on data entry and editing methods.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint