From the course: Access 2019 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Generate forms from tables
From the course: Access 2019 Essential Training
Generate forms from tables
- [Instructor] You can have a basic data entry form up and running in as little as two clicks. First, we're gonna select the table that you'd like to create the form from in the navigation pane, we go ahead and choose the Guest table, then on the Create tab of the ribbon, in the Forms group, just click the Form button. Access will go through and set up the form based off of the table that we had selected in the navigation pane, and this form has cells that correspond to a single guest record in our table. Here we have the guest ID: the first name, last name fields, and so on for the address. At the very bottom of the screen, just like with our tables, we have record selectors. We can page through our different records. For instance, I can go from Katherine Reid's record, number one to Donald Bryant, who's record number two. This corresponds to the same data that we find in the guest table. I open that up and just review that data. Here we have record number one for Katherine Reid, and…
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.