Creating and Using Forms

In this Access forms tutorial you will learn how to create and use forms to know exactly what data to enter into your Access database.

Creating a drop-down list

Using a drop-down list on a form can increase the integrity of the data in the database because drop-down lists force form users to select one of the preset options in the list to populate the field. These types of form controls are relatively easy to set up using the Combo Box.

To create a drop-down list using a Combo Box control:

Whatever name is entered will appear as a label on the form. This label can be deleted if you want.

Switch to Form view to see how the combo box works. The Category drop-down list appears on the Books form, as seen in the image below.

Books FormBooks Form Drop Down Category List