Access 2016 Intermediate

Access 201

Lesson 9 – Manipulating Form Controls in Design View

A DDING A F IELD FROM A NOTHER T ABLE



Discussion

The field list task pane includes fields from other tables in your database. It enables you to drag and drop fields into your form from any table in your database. If the table you select is unrelated to the table in your record source, a relationship is automatically created, or Access prompts you to do so.



Procedures

1. Open the desired form in Design view, if necessary.

2. On the Design tab in the Tools group select Add Existing Fields

.

3. Select the Show All Tables button

.

4. Select the desired table. 5. Select the desired field from the list. 6. Drag the selected field onto the desired position on the form. 7. Release the mouse button.



Step-by-Step

Add a field from another table.

Open Customer Data Entry form in Design view, if necessary.

Steps

Practice Data

1. On the Design tab in the Tools group select Add Existing Fields . The Field List task pane appears.

Click

2. Select the Show All Tables button.

Click

3. Select the desired table.

Click Orders

The table fields are displayed.

OFFICEPRO, Inc.

Page 173