From the course: Learning Access 2016
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Build a data entry form using the Form Wizard
From the course: Learning Access 2016
Build a data entry form using the Form Wizard
- [Voiceover] The best way to streamline and clarify data entry tasks is to have your database users enter data through a specially designed form rather than type directly into the data tables. This will give you a number of advantages, including the ability to provide helpful instruction and tool tips during the data entry process. If we open up the Create tab on the ribbon here and take a look at the Forms group, we'll see that Access provides us lots of different ways for creating new forms in our database. One of the easiest ways is to use the Form Wizard option here. In this case I'd like to create a form that'll help check guests into their hotel rooms. The first thing Access needs to know is which table we want to build our form around. Using this drop-down menu here, I'm gonna choose the Room Assignments table. Next we have to tell Access which fields from the Room Assignments Table we want to see in our form. This first field, the ID field, has no real world meaning to the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.