In Microsoft Access, creating a form that is based upon more than one table requires an understanding that it is a form plus a sub-form. Use the form wizard to choose more than one table in Microsoft Access with help from a computer programming teacher in this free video on Microsoft Access.
Hi, my name is Chip Browne, I teach computer programming and Microsoft Applications at a local business college, Stevens Henager, here in Utah. I also create practice tests for Microsoft certifications. Today we're going to talk about creating a form based upon more than one table. Microsoft acts as, is a registered trademark of Microsoft Corporation, I'm not affiliated with Microsoft Corporation. To create a form that is based upon more than one table, it's important to understand that it's actually a form plus a sub-form. When we create a form that contains a sub-form, we are using more than one table. For example: you may want to see customer data, and then also look at the orders associated with that customer. Let's create one. Using the create tab and the more forms drop down box, we click on form wizard, here we choose more than one table, let's choose customers, and we'll choose some of the fields out of customers. Now we choose a second table, and we'll choose fields from that table. Next we determine how we want to view our data, if we view by customers, then we see that the sub-form is contained inside the form. If we choose to view by orders, then that relationship of one to many is not represented, and it becomes just one form. Let's choose by customers. Next, we choose what lay out we would like for our sub-form, tabular or data sheet, let's choose tabular. It's easier to format. Next we choose what style we would like, let's take the default. Finally, we name the form, and the sub-form, and we choose whether or not to open the form to view our inner information or modify the forms design. Let's take the default. Here is our form and as you can see, here underneath is our sub-form. This represents the record of one customer and then the associated records from the orders table that apply to that one customer. Layout view allows us to add more fields to our form. This is how you create a form that's based upon more than one table. For more information, and more videos visit chipbrowne.com. Chipbrowne.com.