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.…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 Landon Hotel, it's just an auto number…
If you need a deeper dive into the topics discussed, check out Adam's 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