Build a data entry form using the Form Wizard

Keyboard Shortcuts

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…

Resume Transcript Auto-Scroll

Author

Released

5/4/2016

Spreadsheets can only go so far. Databases are the next best step for complex data sets. Access 2016, Microsoft's powerful database software, is the perfect introduction for those new to relational databases. This course provides an overview for first-time users. Adam Wilbert explains the best uses for Access, tours the interface, and guides viewers through various Access conventions and tasks, like understanding how objects interact, adding data to a table, and running a report. He also shows how to get going quickly with Access templates, create queries and reports to pull insights from data, and even use data from existing sources like Excel.

If you need a deeper dive into the topics discussed, check out Adam's Access 2016 Essential Training course.