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
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.
Step 3: After selecting “Form” option, your form will be display as below
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.
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.
Select Categories and Actions for button. For saving records, I have selected “Record Operations” and “Save Record”
Select “Text” option for display button name.
Give the button help name
Step 5: Now you have successful added button. Select “Form View” option (Red rectangle in below image)
Step 6: Fill data into controls as below image.
Step 7: Check your table, where you see data are inserted into successfully
This article end here, I hope this is helpful for you
Leave Comment