Data entry forms allow you to craft a polished user interface for entering data into the database. In this movie, Adam will start the process using the Form Wizard tool available from the Create tab on the ribbon. The form will connect to the underlying data table and focuses on a single record at a time.
- [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 the Landon Hotel.…It's just an auto number that's being generated…
If you need a deeper dive into the topics discussed, check out Adam's Office 365: Access 2016 Essential Training course.
- Loading a premade template database
- Exploring the interface
- Defining data types
- Creating tables
- Defining table relationships
- Editing forms
- Creating queries and reports
- Editing reports in Layout view