Page 2 of 10PREVNEXT

Create forms for a new Access 2007 database

Data sources for a form


Your new asset-tracking database is already saving time and money, but some of your coworkers don't like using Datasheet view to enter data. They find that a grid of columns and rows isn't that easy to use. Not a problem: Forms to the rescue.

A form is a screen that allows you to enter, change, and view the data in a database. Think of forms as windows into your data that help users understand and work with that data.

Let's take a quick look at what goes into a form:

Callout 1 Forms are made up of controls, such as text boxes, buttons, document tabs, and drop-down lists, grouped in a way that makes them easy to use and helps you get work done.
Callout 2 The controls in the form are usually bound, or connected, to the tables or queries in your database — but not always. For example, a control that displays your corporate logo doesn't have to be bound to a table field. It can just point to the image it displays.

In addition to entering data, you can use forms in other ways. For example, you can create a form that asks for input, and then generates a custom report based on that input.

Page 2 of 10PREVNEXT