Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

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. You solve that problem by creating forms.

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:

  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.

  2. The controls in the form are usually bound, or linked, to the tables or queries in your database — but not always. For example, a control that displays asset data is probably bound to either the Assets table, or to a query that retrieves asset data. In contrast, a form control that displays your corporate logo isn't bound to a table field; it just points 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.

Topic 1 of 7

Next

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×