Making Forms More Usable with Controls

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

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:

Orders FormOrders Form

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: