How to Create Data Forms in Access

Database

Microsoft Access uses tables to hold data, while forms are a user interface that allows users to input the data into the table. It is possible to just add the data into the table, but forms makes the experience more user friendly. Microsoft Access has a simple way to create a form that is attached to a table and the information is automatically put into the table after you enter it into the form. It doesn't take long to do this as long as you already have your tables set up.

Instructions

1. Click on the "New" button with the "Forms" objects showing in the Database window.

2. Choose the type of form you want to create in the "New Form" dialog box. There are five choices; AutoForm: Columnar, AutoForm: Tabular, AutoForm:Datasheet, AutoForm:PivotTable and AutoForm: PivotChart. Click on the type of form you want to create.

3. Choose the table or query that you want the form to be bound to. After clicking on the table or query, choose which fields that you want to be added to the form. You can choose just a few or all of them. Click "Next."

4. Continue progressing through the "New Form" wizard until you have set up the form the way you want it. At the end of the wizard, choose whether you want to open the form in Form View or Design View. With Form View, you can start entering in data in the form to be saved in a table or query. In Design View, you can continue to customize the form. Click "Finish."

References

• Microsoft Office Online: Create a Form