Page 3 of 9PREVNEXT

Create forms for a new database

Steps for designing a form

You design forms in much the same way that you designed the tables for your asset-tracking database.

Callout 1 Start by listing the data that you want to enter or view, and then…
Callout 2 Decide on the controls you need in order to capture and work with your data. For example, if you need to enter or edit data, you use a text box. If you need to give users a list of choices, you use a list control.
Callout 3 If it helps, try sketching your form. If other users are involved, you can have them review your sketch.

While you’re at it, be sure to list the data source for each form. You can use tables, or queries that take their data from one or more tables. Also, note whether you'll publish the database to SharePoint. If you’re building a web database, you can only use Layout view to create or change your forms.

The videos in the next sections of this course introduce you to the types of forms you can create, how to build those forms, and how to change them in Layout view, so keep going.

Page 3 of 9PREVNEXT