RelationalDBDesign
SiteMap
Data Manipulation
Access Features
Building Access DB
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Data Manipulation
«Prev
Next»
Access Database
Database Features
Open Access Database
MS Access Window
Access Help System
Access Database Window
Access Interface Conclusion
MS Access Database
What is Database
What is Relational Database
Design Relational Database
How Data is stored
Access Database Objects
Database Analysis
Create Access Database
Steps For Creating Database
Design Tables Conclusion
Creating Access Table
Creating Access Tables
Access Datasheet
Edit Access Datasheet
MS Access Functions
Importing Data
Import Access Table
Building Modifying Forms
Table Manipulation
Table Design View
Field Data Types
Changing DataType
Use InputMask To Limit Data
Selecting Table Fields
Adding Deleting Fields
Creating Hyperlinks In Access Table
Edit Table Design By Moving Field
Understanding Primary Key
Access Table Manipulation Conclusion
Create Table Hyperlinks - Exercise
Creating hyperlink field in a table
Objective:
Create a hyperlink field and enter data.
Exercise Scoring
You will receive 2 points for this exercise. The exercise is auto-scored, which means all you need to do to receive full credit for the exercise is click the
Submit
button.
Instructions
Create a new field in the Clients table to hold the addresses of client Web sites--name it Web Site. You can create the new field in either datasheet or Design view, but you will have to set the data type in Design view.
Once you have created the new field, enter some data in it. The following clients have Web sites (two of these Web sites are real pages):
Lizard Web, Inc.
www.ldbw.com
XPDX, Inc.
www.xpdx.net
Great Tapes, Inc.
http://www.greattapes.com
You don’t actually need the “http://” in front of the Web site, so delete that from the Great Tapes record. Remember that you can’t just click a hyperlink to edit it – you have to right-click and use the Edit Hyperlink dialog box or Tab to it and press F2.