How to Create Data Entry Forms in Microsoft Access on Windows 11

Posted on 19th June 2023

Introduction

In this article, we will show you how to create data entry forms in Microsoft Access. Data entry forms are a convenient way to enter data into your database. Forms can be used to enter data into multiple tables, or to query data from multiple tables. Forms can also be used to display data from a single table or query.

Creating a Data Entry Form in Microsoft Access

To create a data entry form in Access, you first need to create a table. For this example, we will create a table called “Employees”.

1. Open Microsoft Access.
2. Click on the “Create” tab.
3. Click on “Table” in the “Tables” group.
4. Enter the following information into the table:
   • Field Name: EmployeeID
   • Data Type: Number
   • Field Size: Long Integer
5. Click on the “Create” tab.
6. Click on “Table” in the “Tables” group.
7. Enter the following information into the table:
   • Field Name: FirstName
   • Data Type: Text
   • Field Size: 255
8. Click on the “Create” tab.
9. Click on “Table” in the “Tables” group.
10. Enter the following information into the table:
    • Field Name: LastName
    • Data Type: Text
    • Field Size: 255
11. Click on the “Create” tab.
12. Click on “Table” in the “Tables” group.
13. Enter the following information into the table:
    • Field Name: DateOfBirth
    • Data Type: Date/Time
    • Field Size: Date Only
14. Click on the “Create” tab.
15. Click on “Table” in the “Tables” group.
16. Enter the following information into the table:
    • Field Name: Department
    • Data Type: Text
    • Field Size: 255
17. Click on the “Create” tab.
18. Click on “Table” in the “Tables” group.
19. Enter the following information into the table:
    • Field Name: Salary
    • Data Type: Currency
    • Field Size: Standard
20. Click on the “Create” tab.
21. Click on “Table” in the “Tables” group.
22. Enter the following information into the table:
    • Field Name: HireDate
    • Data Type: Date/Time
    • Field Size: Date Only
23. Click on the “Create” tab.
24. Click on “Table” in the “Tables” group.
25. Enter the following information into the table:
    • Field Name: TerminationDate
    • Data Type: Date/Time
    • Field Size: Date Only
26. Click on the “Create” tab.
27. Click on “Table” in the “Tables” group.
28. Enter the following information into the table:
    • Field Name: Status
    • Data Type: Text
    • Field Size: 255

Once you have created the table, you can now create the data entry form.

1. Click on the “Create” tab.
2. Click on “Form” in the “Forms” group.
3. Click on “Form Wizard” in the “Other” group.
4. Select the “Employees” table from the list of tables and click on the “>>” button to move it to the “Selected Tables” list.
5. Click on the “Next” button.
6. Select the “EmployeeID”, “FirstName”, “LastName”, “DateOfBirth”, “Department”, “Salary”, “HireDate”, “TerminationDate”, and “Status” fields and click on the “>>” button to move them to the “Selected Fields” list.
7. Click on the “Next” button.
8. Click on the “Finish” button.

Your data entry form should now be displayed.

Conclusion

In this article, we showed you how to create data entry forms in Microsoft Access. Data entry forms are a convenient way to enter data into your database. Forms can be used to enter data into multiple tables, or to query data from multiple tables. Forms can also be used to display data from a single table or query.

In the next section, we’ll look at how to create data entry forms in Microsoft Access on Windows 11.

Creating data entry forms in Microsoft Access is a two-step process. First, you’ll need to create a table to store your data. Second, you’ll need to create a form that will allow you to enter data into your table.

To create a table, open Microsoft Access and click on the “Create” tab. Then, click on the “Table” icon. This will open the “Table Design” window.

In the “Table Design” window, you’ll need to enter the name of your table and the names of the fields that you want to include in your table. For each field, you’ll need to specify the data type. The data type will determine the kind of data that you can enter into that field.

After you’ve entered the name of your table and the names of the fields, click on the “Save” icon. This will save your table and close the “Table Design” window.

To create a form, click on the “Create” tab and then click on the “Form” icon. This will open the “Form Design” window.

In the “Form Design” window, you’ll need to select the table that you want to use for your form. Then, you’ll need to add the fields that you want to include in your form. To add a field, double-click on it in the “Fields” list.

After you’ve added the fields that you want to include in your form, you can click on the “Save” icon to save your form.

To create a form in Access, you first need to create a table to store your data. To do this, click the “Create” tab on the ribbon, then click “Table.” In the new table, create columns for the information you want to track. For each column, you’ll need to specify a data type (such as “text” or “number”).

Once you’ve created your table, click the “Create” tab again and click “Form.” In the Form Wizard, select the table you just created and click “Finish.” Your form will now be displayed in Layout view.

To add fields to your form, click the “Fields” button on the ribbon. Click the field you want to add, then click the “Add” button. To move a field, click the “Move” button on the ribbon. To delete a field, click the “Delete” button on the ribbon.

When you’re finished adding fields, click the “View” button on the ribbon to switch to Form view. From here, you can add, edit, or delete data in your form. To close the form, click the “Close” button on the ribbon.