From the course: Office 365: Access Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Generating forms from tables

Generating forms from tables - Microsoft Access Tutorial

From the course: Office 365: Access Essential Training

Start my 1-month free trial

Generating forms from tables

“

- You can have a basic data entry form, up and running, in as little as two clicks. First, select the table you'd like to create a form for the navigation pane. I'll go ahead and make sure that the Guests table is selected. Then go up to the Create tab here, and in the Forms group, press the first button there that says Form. Access will go ahead and analyze the Guests table, and create a basic data entry form based off of the data that's in that table. This form has cells that correspond to a single guest's record in the table, we can view this information here, or edit it, in order to make changes back into the original data table. And, just like viewing a data table, we have the same record selectors across the bottom, down here, in order to page through our different records. In addition to the text boxes up here that hold the information about our individual guests, if I scroll down on this form a little bit, you'll also notice that we have this subdatasheet here, that's showing…

Contents