Access 2016 Intermediate

Lesson 2 – Modifying Tables

Access 2010

Steps

Practice Data

12. Type the desired label for the lookup column. The text appears in the What label would you like for your lookup column? box.

Type Market Type

13. Select Finish .

Click

The Lookup Wizard closes, and the lookup column is inserted.

Use the lookup column to enter data. Click in the Market Type column for the first record and then click the drop-down arrow that appears. Select large metro markets ; then, double-click the separator line to the right of the Market Type column heading to widen the Market Type column as needed.

Click at the right side of the Market Type column for the second record; notice that the drop-down list automatically appears. Select medium markets .

I NSERTING A H YPERLINK C OLUMN



Discussion

You can insert a hyperlink column into a table; a hyperlink field contains a path to another location, such as a network server or a page on the Internet. When you insert a hyperlink column, its name defaults to Field1 ; you can rename the hyperlink column as desired.

After inserting a hyperlink column, type the hyperlink text for each record directly into the column, and each record can contain a different hyperlink address. Hyperlinks are underlined and appear in a different color.

Page 44

OFFICEPRO, Inc.