Horizon-Computer.Org.

Within any Office 97 application, when you type a Web address or even an e-mail address, it automatically becomes a hyperlink! Let’s say you are typing a memo in Microsoft Word and you inform the reader of a new Web site. Right after you type the URL (Web address) and hit the space bar, the URL becomes a hyperlink. Anyone can double click on the hyperlink to go directly to the Web site.

This is also a great way to make a list of your favorite Web sites. Just type the names, descriptions and URL’s of your favorite Web sites in a list in Word 97. As you type them, the URL’s become hyperlinks. Just double click on any address you would like to go to quickly.

Turn virtually any Office 97 document into a Web page! All of the Office 97 applications have added a Saves as HTML option under the File menu. Once saved in this fashion, your document becomes a fully functional Web page that you can upload to the Internet. Here’s a really exciting example. Let’s say you need to create a table for your Web page.

1. Open Excel 97 & create the table.
2. To control the amount of information that goes on a page, use the mouse to select a range of cells you would like included in your HTML document.
3. Choose File, Save as HTML from the menu.
4. An HTML Wizard will appear and step you through the process of creating an HTML file.
5. You can either create an independent HTML file or insert it into an existing HTML file.
6. Answer the questions about the Title, Header, Description, and placement of horizontal lines.
7. After answering all the questions, you have a Web page ready to upload to the Internet!

A fantastic new tool for database developers is the addition of a Hyperlink field type in Microsoft Access. Where traditionally you could store your data as Text, Number, Memo or Yes/No format, now you have Hyperlink format. This means you can store hyperlinks and e-mail addresses in a MS Access database and create HTML files directly from your Access database!

Let’s say you have a client list in Microsoft Access 95, and you want to be able to add Web addresses and e-mail addresses to all your client’s contact information.

1. Open the database in Access 97.

2. It will ask you to convert the file. Follow the steps to convert it.

3. Select the TABLE tab, highlight your client table, and click DESIGN.

4. In the design view, go to the bottom of your field list and add two fields:

Web Address Hyperlink

Email Hyperlink

5. You now have two new fields that can be double-clicked to either go directly to your client’s Web site or send them e-mail.

The possibilities are endless and the time you’ll save is immense!

[ Back ] [ Up ] [ Next ]