Access provides an easy way to enter data into your Access tables with forms.
In Access you have the ability to quickly make and customize these data entry forms to streamline
the data input process. Learning how to properly create an Access form will
save you a great deal of time!
Using our previous example, imagine that Bob, from Bob's Shoe Store, has recently hired
someone to enter all the sales data at the end of each business day. The only problem is this person
does not know how to use Access, so Bob needs to make them a custom form in Access!
This lesson will guide you through the process of creating a data input form in Access
Creating an Access Form
Although we haven't recommended the various wizards that Access had available in the previous lessons,
the form wizard is actually very useful and should save you a bunch of time!
Let's create a simple data input form for the new employee!
- Navigate to the Forms section in Access
- Double-click "Create form by using wizard"
- We want all of the fields from tbl_Sales to be included in this form, so first
select tbl_Sales from the drop down box "Tables/Queries"
- The single right arrow will add one selected field at a time, but we want all the fields. The shortcut
to add every field from a given table or query is to click the double arrow button. Do that and click Next.
- Choose a Columnar layout and press Next
- Choose any style and press Next (we chose "Sumi Painting")
- Change the form's title to frm_EmployeeEntry
and click Finish
Open up your form and check it out!
Entering Data Using Access Forms
Now that the form has been created, Bob just needs to teach his employee how to enter
in the data. Lucky for Bob it's as easy as one-two-three and won't take him long to bring
his new employee up to speed.
- Open up frm_EmployeeEntry (easy!)
- At the bottom of the form is a set of arrows to navigate through the records. To get to
the end of the existing records and begin entering data you need to click the arrow with an asterisk(*).
- Clicking that button will bring you to the first blank record, which would be the sixth in our case. You
would then enter all the data for that record and click the right arrow to advance to the next blank record.
After all the new records have been entered, close the form and pat yourself on the back.
When you enter data into this form it will automatically add it to our existing tbl_Sales because
we specified that table when we created our form. With this form the new employee will be able
to enter data into Bob's existing Access table without ever knowing a thing about tables!
Found Something Wrong in this Lesson?
Report a Bug or Comment on This Lesson - Your input is what keeps Tizag improving with time!