Building on the Room Assignments form started in the previous movie, Adam will introduce the development tools available to you when you switch into the Form Design view. By converting a text box of the room number into a dropdown combo box displaying the room name instead, the process of entering in guest check in data can be made even more clear.
- The design view of our form will provide…us with many more options to enhance…the usability and style of the Room Assignments form…we created in the last movie.…If your Room Assignments form is open,…you can change it into Design view by coming up here…to the Home tab and pressing the View button here.…Otherwise come down to the Navigation pane, and find it,…give it a right-click,…and press Design View from the pop-up menu.…When your view mode changes,…you'll notice that there are three new tabs…across the top of the ribbon:…we have the Design tab, the Arrange tab, and the Format tab.…The Design tab will allow you to place…new objects on the form.…
The Arrange tab contains tools to help you line things up.…And the Format tab, that'll help add some style and pizzazz…to the finished form through font, color,…and image options.…The middle portion of the screen represents…the layout of the various items that are on the form…and include this dotted pattern to help you line things up.…If you click on an item,…you'll notice that you get some handles…
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