Creating Forms

Creating forms in Access can make entering data more convenient. Learn how to create and modify Access forms here.

Adding additional fields to a form

When you use the Form command on an existing table, all of the fields from the table are included in the form. However, if you later add additional fields to the table, these fields will not automatically show up in existing forms. In situations like this, you can add additional fields to a form.

To add a field to a form:

  1. Select the Design tab, then locate the Tools group on the right side of the Ribbon.
  2. Click the Add Existing Fields command.
    Screenshot of Access 2013Clicking the Add Existing Fields command
  3. The Field List pane will appear. Double-click the desired field(s).

    Screenshot of Access 2013Selecting a field from the source table
  4. The field will be added.
    Screenshot of Access 2013The added field

You can also use the above procedure to add fields to a totally blank form. Simply create a form by clicking the Blank Form command on the Create tab, then follow the above steps to add the desired fields.

Screenshot of Access 2013Clicking the Blank Form command

To add a field from a different table:

You can also add fields from different tables in your database to the form.

  1. From the Field List pane, click Show All Tables.
  2. Click the plus sign + next to the table that contains the field you want to add, then double-click the desired field.
    Screenshot of Access 2013Selecting a field from another table
  3. The new field will be added.