How to Create Forms in Microsoft Access

Microsoft Access has made creating forms an easy experience. Microsoft Access is a database. Its purpose is to store and arrange information. Forms give the user the ability to access information in tables and queries through a graphical interface. If you are creating the forms, then you are probably responsible for the data stored in the tables as well.

Instructions

1. Open Microsoft Access.

2. Select “New Database.”

3. Click on the “Create” tab. Select “More Forms” in the “Form” section. A drop down menu will appear. Select “Form Wizard.” The “Form Wizard” window opens.

4. Select the “>” button. The “Tables/Queries” drop down menu will list all tables and queries that have been saved. For the purpose of this article there is only the default “Table: Table1.” We do not need to change it. The “Available Fields:” sub-window lists all of the fields that are in the table or query you selected. The only field we have is “ID.” Selecting the “>” button transfers the ID field from the “Available Fields” sub-window into the “Selected Fields” sub-window. Click the “Next>” button.

5. Choose a layout. There are four different layouts that you can choose: Columnar, Tabular, Datasheet and Justified. Select which layout you want and click the “Next>” button.

6. Choose a style. There are about twenty different styles that you can choose from. This will determine the general look of your form. Select the “Next>” button.

7. Give the form a name. Name the form something that keeps it unique from other forms you may create. In the “Do you want to open the form or modify the form’s design?” section choose if you want to open the form now or if you wish to modify the form. Click the “Open the form to view or enter information” radio button for the example in this article. Click the “Finish” button.

8. View your form. If you are not happy with it or wish to make additional changes you can click on the “View” drop-down menu under the “View” section. Click either the “Layout” view or the “Design” view to make further changes to the form.