Home > DeveloperSection > Articles > Forms in Access

Forms in Access


MS Access MS Access 
Ratings:
0 Comment(s)
 1981  View(s)
Rate this:

Forms in Access

A Form is a database object that you can use to create a user interface for a database application. On other hands to make data entry and data viewing easier and harmless with Access forms designed and customized for user convenience.

In this article, I have described, how to used forms in Access step by step.

Step 1: First Create table in your Access as below image

Forms in Access

Step 2: Save the table design and close that. After that select table (Employee Details) and click create menu option and select Form option as below image.

Forms in Access

Step 3: After selecting “Form” option, your form will be display as below

Forms in Access

Note: Delete “Emp ID“ field because this field is auto generated value. After deleting “Emp ID” field, save your form and your form looking as below.

Forms in Access

Step 4: Now add one button on your form, on that click you save the records into table. For adding button follow below steps.

Select button control from toolbox as below. Press double clicks on button for select control and drag on form where you want to put button.

Forms in Access

Select Categories and Actions for button. For saving records, I have selected “Record Operations” and “Save Record

Forms in Access

Select “Text” option for display button name.

Forms in Access

Give the button help name

Forms in Access

Step 5: Now you have successful added button. Select “Form View” option (Red rectangle in below image)

Forms in Access

Step 6: Fill data into controls as below image.

Forms in Access

Step 7: Check your table, where you see data are inserted into successfully

Forms in Access

This article end here, I hope this is helpful for you


Don't want to miss updates? Please click the below button!

Follow MindStick