From the course: Learning Access for Office 365
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Build a data entry form using the wizard
From the course: Learning Access for Office 365
Build a data entry form using the 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. Once 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 wanna 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 wanna see in our form. This first field, the ID field, has no real world meaning to…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.