In this Access forms tutorial you will learn how to make Access forms more usable with controls while increasing the integrity of your Access database.
Making forms more usable
Watch the video! (10:04min)
Download the example to work along with the video.
Making forms more useable
You already know that forms can help you increase the integrity of your data by limiting what you see and how you can enter data. You saw that using a drop-down list can make data entry easy. Now it's time to think about the design of your forms from a form user's perspective.
Let's look at the Orders form in our bookstore scenario. The basic form, which was created with the Form command, looks like this:
This form is where we would want our user—the store employee—to pair a customer with a book to complete an order. Let's look at the form from the user's point of view:
- The employee would be adding new orders, not editing existing ones, so we'll set form properties to limit this action.
- The user will also never need to enter the Order ID number because this is the number the database assigns each order record to differentiate it from other orders. We'll hide this field.
- The Customer ID field and the Book ID field are not too useful as they are because the employee would have to know each customer's ID number and every Book ID number to be able to enter the data in the format we need. We'll make these fields more useable by creating combo boxes that help users select the correct customer and book.
- Our user will not need to enter the Order Date because we want the database to auto-populate this field in the database using today's date. We'll set field properties to make this happen.