From the course: Microsoft Access: Forms and Reports

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Create a form with subforms

Create a form with subforms

From the course: Microsoft Access: Forms and Reports

Start my 1-month free trial Buy for my team

Create a form with subforms

“

- The form wizard allows you to pull information from multiple tables and it streamlines the process of getting a quick form setup. Depending on the options that you choose, you can finish the wizard with a variety of layouts that might be a better fit for the workflow that you're trying to create. Let's take a closer look at some of those other layout options that the wizard presents us with. On the create tab, we'll start up the form wizard again. Now, I'm going to build another form that uses the exact same tables and fields that we used in the prior movie. So from the orders table, I'll grab the order ID, date, and quantity fields and move those over to selected. Then we'll go to the customer's table and I'll grab the first name and last name of the customer that placed each order. And finally, we'll go to the products table, and there I can find the product name. So we can see exactly what product was ordered. With…

Contents