Form wizard in Access lets you create forms with great ease. You can create forms in Ms Access with the help of the wizard with just a few clicks. In this tutorial, we will teach you how to use the wizard and other options relating to it. New record entry can be done to the database with the help of these forms.
Step # 1 – Creating a form
To create forms in Ms Access, click once on the customers table and then go the create tab. Over there, click on the form wizard button. A window will open showing you the name of selected table. On the left side of the window, a list of all the fields in the table would be shown. We will move all the fields to the right by using the double headed arrow.
Step # 2 – Adding tables
Now change the table to “orders” table and move all of its fields to the right as well. Once you are done, click on the “next” button thrice to proceed further. As we are creating a form that contains information about customers and orders, we will select all the information from these two tables. The purpose of doing so is that it will show you which type of products are preferred by the customers and the number of orders per customer.
Step # 3 – Forms with sub-forms
In this part of the form wizard in Access, we will select the “forms with sub forms” option because it is easier to understand and use. As you can notice in the grey area, Access already recognizes the relationship between the tables and sets them up in sub-form.
In the next part of the wizard, select the “datasheet view” option. The datasheet view allows the user to use more options and make changes to the form.
Step # 4 – Naming the form
Change the name of the form to “Customers order form” and click finish. It is important to save the changes otherwise the changes will be lost and the process will have to be repeated all over again. As this form is about the customers and orders, use the same name to save the table because it will be easier to remember.
Step # 5 – Viewing the form
Now you will see a form showing all the customer information. Right below this information, the respective orders of that particular customer would be displayed. By clicking on the left and right arrows located at the very bottom, you can navigate through customers and view their information.
Complete information about the customer is displayed in the upper portion and the lower portion shows order details such as the date, product and order id.
Home