Access gives us a window into our database data through an object called a form. Forms can be used to create user interfaces to either enter data or to manipulate data. A ” bound” form is a form that is tied directly to a table or query and can serve as a user interface into that data source. An “unbound” form does not directly connect to a data source, but gives the user controls that can be used to run the database application.

Forms are important tools for usability of a database application. Users do not have to be familiar with the internal structure of the database but instead can take advantage of a form to ensure usability—even that they are entering information correctly.

Bound vs. Unbound Forms

There are two main types of forms in Access:

• Bound Forms: These forms are directly connected to a data source, such as a table or query. When a user enters data into a bound form, the changes are immediately reflected in the underlying data. Bound forms are ideal for data entry, updating records, and viewing specific information in a structured format.

• Unbound Forms: These forms are not tied to any data source. They can be used to create custom interfaces that perform specific tasks—such as navigating between different objects in the database, launching reports, or executing macros and VBA procedures. Unbound forms often contain command buttons, search boxes, or menus.