How to Create a Form in Microsoft Access

Access is database application software that lets you create database of various sorts with ease. You can even create forms in Access. To begin with, forms in access allow you to view one record at a time. Furthermore, forms make it easier to enter data into tables. Lastly, forms express the same data in the table but in a manner far more presentable.


In this tutorial, we will teach you how to work with forms in Access.

Step # 1 – Creating data entry form

In this tutorial, we will create forms in Access. The first kind of form that we will create is the data entry form. Click once on the “sales reps” table and then go to the “create” tab and click on the “form” button; instantly a data entry form will appear. The form displays information about the employee. Through forms you can add new customers to an employee or delete existing ones.

making the data entry form

Step # 2 – view records

At the bottom of the page, there are arrows pointing left and right. Press those arrows in order to navigate through different employees and view their respective information. You will notice that there is an arrow with a star sign. Click on that button and you will be able create a new employee form.

watching all the records

Step # 3 – Updating the form

Click on the datasheet button that can be found in the top left corner of the screen and any changes you make in the form will be updated in the table as well. In the tutorial, we updated the phone number. If you do not click on the datasheet view, you will unable to make changes in the form.

adding new data to the form

Step # 4 – saving the change

After you have made changes to the form in Access, save it and name it “sales reps and customers form”.

saving the modifications made

Step # 5 – Creating the split form

Another type of form is the Split Form. To create a Split Form, we will use the product table. Select the desired table, go to the “create tab” and from the “More Forms” drop down menu, select “split form”. A form will appear that displays a single entry along with a list of all the products at the bottom. Click on any of the product at the bottom that product will appear on the form above. Save the form once done.

Making a split form

Step # 6 – Viewing and saving the form

The split form allows for multi-tasking as it shows two different views at the same time. You can add data and view it in table form at the same time. You can also select a particular data from the list below and edit in the form above. Information displayed in forms is much cleaner and easier to use.

Using and saving the form