How to create Access form to enter data

How to create Access form to enter data

From our previous lesson 01 we have learnt that how to create access database and how to enter data in to a designed table.Entering data into a table directly is somewhat difficult when there are large volume of data.Then access we have good option to enter data easily,it is Access Forms.We can design access form to feed data in to a access table.So lets learn simply how we can design access form to enter data.

Step 01

Fig 01

As we designed from our first lesson we already have a table like Fig 01.Then we can create a access form for above table very easily.

Fig 02

Follow the instructions as per Fig 02.Then Form Wizard will appear on your desktop.

Fig 03

When you click on the Form Wizard Fig 03 dialog box will appear,there you should select your table to create form for that table.Then on this dialog box on the left hand side there is a window called Available Fields,it shows the all the available fields of your designed table.then on the right hand side there is anther window which allows you to select desired fields for your table,with the help of the arrow marks appear among the two windows allows to user to select field to your access form.(Please see following Fig 04 image for more )

Fig 04

After selecting field you need click on the Next button.Then anther dialog box comes as per Fig 05.

Fig 05

Fig 06

Give a name to your Form and Click on the finish as per Fig 06.

Fig 07

Then Form is created and it looks like Fig 07,then you can easily enter data to your table via this form.