Access 2016 Intermediate

Access 2010

Lesson 2 – Modifying Tables

NOTE After inserting a hyperlink column, change the default field name to one that clearly identifies its contents.



Procedures

1. Open the desired table in Datasheet view.

2. Go to the end of the table and click the Click to Add button.

3. Select the field choice, Hyperlink .



Step-by-Step

Insert a hyperlink column.

If necessary, open the Customers table in Datasheet view.

Steps

Practice Data

1. Go to the end of the table and click the Click to Add button. A short list of field types are displayed

Click

2. Select the field choice, Hyperlink . A blank column is inserted.

Click

Change the hyperlink column name to Web Address . Then, type www.shoes.com into the Web Address field for the Athletic Supplies Co. record. Widen the column as necessary. Notice that the entry is underlined and its text is blue.

Close the Customers table, saving the changes.

C REATING A M ANY - TO -M ANY R ELATIONSHIP



Discussion

Although one-to-many relationships are more common by far, there are times when you may need to create a many-to-many relationship. In a many-to-many relationship, a record in one table can have many matching records in another table

OFFICEPRO, Inc.

Page 45