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

Excel in Practice

Excel's data-entry forms are plain and just not very functional. Searching for data and checking that entered data is correct is difficult. By using Excel's Data, MS Access Form command, you can use Access instead of Excel for data entry. Figures 29.49 and 29.50 show data forms in Excel and Access for you to compare.

The Access form is a dressed-up version of the Excel data form, adding graphics and formatted text. I've also really made the form more useful by organizing it more logically and by converting some fields to drop-down lists. These fields can be restricted by Access so that users can enter only valid data. For example, with a bit of configuring, I set the State field to show only U.S. states when the Country field is set to United States.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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