Microsoft Office Tutorials and References
In Depth Information
Access Data Types
When you type a link into the datasheet, the first two are set to the same value—
whatever you’ve just typed in. For example, when you type www.FantasyPharma-
cologists.com , the text you see and the tooltip are both set to hold the same content,
which is www.FantasyPharmacologists.com .
To set the third piece of information—the URL or file path—Access examines your
entry and makes a reasonable guess. For example, if you type www.FantasyPhar-
macologists.com , Access assumes you want the URL to be the web location http://
www.FantasyPharmacologists.com , so it adds the http:// sequence at the beginning.
Similarly, if you type an email address like email@example.com , Access creates the full
email link mailto:firstname.lastname@example.org . When you click a link like this in Access or in
a web browser, your email program starts a new message. Finally, if you enter a file
path or a URL that already starts with http:// (or some other URL prefix), Access
doesn’t make any changes.
Most of the time, Access’s approach gives you the result you want. However, you
aren’t limited to this strategy. You can set these three components to have different
values—for example, so your URL has a website address (like www.zyqcorp.com ) but
your display text has a more approachable name (“The ZYQ Corporation”). To do
so, move to the value, and then press Ctrl+K to pop up the Edit Hyperlink window
(see Figure 26-16). Or right-click it, and then choose Hyperlink ➝ Edit Hyperlink.
Using the Edit
you can change the
text that appears in
the cell (at the top
of the window) and
the page that Access
opens when you click
it (at the bottom).
You can also create
links that use email
addresses (in which
case Access opens the
email program that’s
configured on your
computer) or links
to file paths (use the
to pick the file you
The Attachment data type lets you add one or more files to your database record in
much the same way that you tack on attachments to your email messages. Access