Data Manipulation  «Prev  Next»

Create Table Hyperlinks - Exercise

Objective

Create a Hyperlink field in the Clients table and enter website addresses for selected clients.

Scoring

You will receive 2 points for this exercise. This exercise is auto-scored, which means you receive full credit by completing the task and clicking Submit. If your workflow requires notes, you may enter them in the optional text area below.

Instructions

  1. Open the Clients table.
  2. Add a new field named Web Site.
    • You may add the field in Datasheet view, but set the Data Type in Design View.
    • Set the data type to Hyperlink.
  3. Switch to Datasheet View and enter hyperlink values for the clients listed below.
  4. For the Great Tapes, Inc. record, remove the http:// prefix so the stored value is only the domain name.
  5. When finished, click Submit to continue to the Exercise Result page.

Client website values to enter

Client Web Site value
Lizard Web, Inc. www.ldbw.com
XPDX, Inc. www.xpdx.net
Great Tapes, Inc. http://www.greattapes.com

Important: you cannot reliably “click into” a hyperlink cell to correct typos because that may activate the link. To edit hyperlink text safely, either:

  • Right-click the field and choose Hyperlink > Edit Hyperlink, or
  • Tab to the field and press F2 to place the cursor for editing.

For Great Tapes, Inc., delete the http:// prefix after you enter the value.