Embedded Files
Data entry can be improved in a database by creating a Form view. In this page we will create a simple data entry form.
Form
Form
"A form in Access is a database object that you can use to create a user interface for a database application" (Microsoft Support, 2022). It can allow display and entry for one or more entities (tables) or queries (Figure 1).
Figure 1: Example of an MS-Access Form for displaying/entering data in the Employee table.
Naming Convention
Naming Convention
For a form , use the prefix "frm". Interestingly the default chosen in MS-Access is "tbl" which can be quite confusing as the form is named the same as the table. You will need to change the name after you have created your form.
Creating an Employee Form in MS-Access
Creating an Employee Form in MS-Access
Click on Create > Form Wizard
As we want a simple for click on [>>] to transfer all the attributes to the "Selected Fields"
(You can use the [>] button to specify which attributes you want on your form)
Click on [Next]
The following dialog box will be displayed. Change the "What title do you want for your form?" to frmEmployee.
Click on [Finish]
The following form will be displayed.
Note that as we have already added some sample data to tblEmployee this will show up in the form. You can use the control buttons (at the bottom) to move through the records
If you did not change the Form name to frmEmployee (from tblEmployee) you can change the name of the Form from the default (tblEmployee) to frmEmployee to make it obvious this is a form not a table.
(You will need to close the form then right click on tblEmployee in Forms and rename).
When you have done this your object panel should look like.
References
References
Microsoft Support (2022). Introduction to forms. https://support.microsoft.com/en-us/office/introduction-to-forms-e8d47343-c937-44e8-a80f-b6a83a1fa3ae
Google Sites
Report abuse