---
title: "Forms in Access"  
description: "Forms in Access"  
author: "AVADHESH PATEL"  
published: 2013-04-01  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/1181/forms-in-access  
category: "ms access"  
tags: ["ms access"]  
reading_time: 2 minutes  

---

# Forms in Access

A Form is a [database](https://www.mindstick.com/articles/71/how-to-create-xml-file-of-database-in-c-sharp) object that you can use to create a [user interface](https://www.mindstick.com/blog/302016/what-is-user-interface-and-what-are-its-benefits) 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](https://yourviews.mindstick.com/view/81489/kashmir-now-after-an-year-of-abrogation-of-article-370), I have described, how to used forms in Access step by step.

Step 1: First [Create table](https://www.mindstick.com/articles/443/how-to-create-table-in-sql-server) in your Access as below image

![Forms in Access](https://www.mindstick.com/mindstickarticle/44590393-a449-4d80-8917-415b515ea995/images/1b94b9c4-8348-4b45-b432-fb2e889d480c.png)

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](https://www.mindstick.com/mindstickarticle/44590393-a449-4d80-8917-415b515ea995/images/f0d55fc3-4882-4e8d-a815-bb7ce100c83a.png)

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

![Forms in Access](https://www.mindstick.com/mindstickarticle/44590393-a449-4d80-8917-415b515ea995/images/28c5d1a6-c5cb-4538-a1e4-df72951193ea.png)

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](https://www.mindstick.com/mindstickarticle/44590393-a449-4d80-8917-415b515ea995/images/f432c9cf-ff21-4860-a512-63ebeb4f297f.png)

Step 4: Now add one button on your form, on that click you save the [records](https://www.mindstick.com/forum/34640/how-to-create-a-stored-procedure-for-display-all-records) into table. For adding button follow below steps.

Select [button control](https://www.mindstick.com/articles/290/button-control-in-vb-dot-net) 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](https://www.mindstick.com/mindstickarticle/44590393-a449-4d80-8917-415b515ea995/images/825043a7-e9d1-44d6-b919-99318d2124e5.png)

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

![Forms in Access](https://www.mindstick.com/mindstickarticle/44590393-a449-4d80-8917-415b515ea995/images/0d3c5e3e-9776-4e79-9edf-c4858f755d17.png)

Select “Text” option for display button name.

![Forms in Access](https://www.mindstick.com/mindstickarticle/44590393-a449-4d80-8917-415b515ea995/images/3bdfcd5a-fe89-4e49-be6b-f68ba60d7a60.png)

Give the button help name

![Forms in Access](https://www.mindstick.com/mindstickarticle/44590393-a449-4d80-8917-415b515ea995/images/90ce7792-818e-4844-98db-ec08c88f0174.png)

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

![Forms in Access](https://www.mindstick.com/mindstickarticle/44590393-a449-4d80-8917-415b515ea995/images/192f1c01-4fda-448f-9b0b-31fd7fc66ddf.png)

Step 6: Fill data into controls as below image.

![Forms in Access](https://www.mindstick.com/mindstickarticle/44590393-a449-4d80-8917-415b515ea995/images/9ce2abf1-9d25-4567-ad38-0de8416f02af.png)

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

![Forms in Access](https://www.mindstick.com/mindstickarticle/44590393-a449-4d80-8917-415b515ea995/images/0236aa46-eb67-4df2-9c72-610d3cf127d4.png)

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

---

Original Source: https://www.mindstick.com/articles/1181/forms-in-access

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.