Forms allow inserting data across multiple tables. There are different methods for creating forms but with the Form Wizard method, you can always modify the form later using Design View. To create a form
- From the main menu, click on CREATE and then choose the FORM option
- It will create a new form in Layout view, based on the fields in the Customer table
- Scroll the drop-down arrow under the View icon and select Form View. This is how the user will see the form.
- On the form, you will see fields like Customer, First Name, Last Name, and Date Created
- After filling in all details in the form, you can see the newly created record with data in the table
- Once you completed filling the field in the form, confirm that you click on the save button on the top of the ribbon