Software

Tech Tip: Link a logo to a Web page in Word/Create a workspace file in Excel/Simplify data entry with tab controls

Learn how to create a hyperlink that links to your company's Web page, create a file that contains pointers to a group of files, and replace multiple pages of a form with tab controls.

Link your company's logo to its Web page

If you include your company's logo in your Word documents, you can create a hyperlink that will link to your company's Web page.

Follow these steps:

  1. Right-click the logo image, and choose Hyperlink from the shortcut menu.
  2. Enter the URL of your company's Web site in the Type File Or Web Page Address text box in Word 2000, and click OK. (If you're using Word 2002, enter the URL in the Address text box.)

To go to your company's Web site, in Word 2000, either double-click the logo, or right-click it and choose Hyperlink | Open. In Word 2002, either press [Ctrl] and click the logo, or right-click it and choose Open Hyperlink.

Create a workspace file

If you frequently work with the same group of files at the same time, you don't need to spend extra time opening each file individually. Instead, you can create a workspace file that contains pointers to the files so you can open them all at once.

For example, let's say you normally work with three worksheet files at a time.

Follow these steps:

  1. Open all three files.
  2. Go to File | Save Workspace.
  3. Browse to where you want to save the workspace, name the file, and click Save.

Excel creates a workspace file with the .xlw file extension that contains pointers to the three Excel files. You can keep the icon for the workspace file on your desktop. When you're ready to work with the files, double-click the icon to open all three files at once.

When you close the .xlw file, all three files will close at once unless you've made any changes. If so, Excel will ask if you want to save your changes.

Simplify data entry with tab controls

If your Access forms take up more than one page, or your users spend a great deal of time scrolling through the forms, then it may be time to replace multiple pages with tab controls. Tab controls let you assemble groups of data on a screen, making it easier to work with.

For example, let's say you have a form that includes information on each book in your store, including data about the author and publisher on multiple pages. You can use a tab control to assemble the information into three tab pages: one for book information, one for author information, and one for publisher information.

Follow these steps:

  1. Open the form in Design View.
  2. Click and drag the lower border of the form to allow room for the tab control.
  3. In the Toolbox, click the Tab Control button, and draw the tab control in the blank area.
  4. Right-click the tab control, and select Insert Page.
  5. Select all of the fields on the form that pertain to book information, and copy them to the first tab page.
  6. Select all of the fields that pertain to author information, and copy them to the second tab page.
  7. Select all of the fields that pertain to publisher information, and copy them to the third tab page.
  8. Double-click the first page, and change the Caption property to Book Info; change the Caption properties for the other two pages accordingly.
  9. Delete the controls from the top of the form, and reduce the height of the form to include only the tab control.

Users can now select a tab to access the additional fields on the form.

Editor's Picks

Free Newsletters, In your Inbox