Access 2016 Intermediate

Access 2010

Lesson 2 – Modifying Tables

E XERCISE

M ODIFYING T ABLES



Task

Modify the appearance of a table.

1. Open MODTABX.ACCDB . 2. Open the Trainer table in Datasheet view. 3. Insert a hyperlink column to the right of the Home Phone column; name the hyperlink column E-Mail . 4. Select the E-Mail field of the Andrew Williams record, type awilliams@aol.com , and press [Enter] . Widen the E-Mail column as necessary; notice that the new entry is formatted as a hyperlink. Then, close the Trainer table, saving the changes. 5. Open the Payment table in Datasheet view. 6. Insert a lookup column to the left of the Trainer Initials column. 7. Have the lookup column get its values from the Types table and the Payment Type field, do not adjust the column width, and label the column Type of Payment . 8. Make sure the Payment table is sorted in ascending order by the Project ID field. Enter the following values for the first eight records into the Type of Payment column:

Project ID

Type of Payment

1

MONEY ORDER

1

MONEY ORDER

2

VISA

3

CHECK

3

CHECK

4

MASTER CARD

5

VISA GOLD

6

CASH

9. Widen the Type of Payment column as necessary. Then delete the Trainer Initials and Credit Rating columns.

OFFICEPRO, Inc.

Page 49