Change the default font in your Word documents

Sometimes clients (or bosses) require documents to be in a specific format--even down to the font type and size.

Microsoft Word
Change the default font in your Word documents

Sometimes clients (or bosses) require documents to be in a specific format--even down to the font type and size.

If these requests are causing you to change the default font for nearly all of your Word 2000, 2002, and 2003 documents, you can save yourself some time by changing the default font in the Normal template.

Follow these steps to create a shortcut key:

  1. Open a new document.
  2. Go to Format | Font.
  3. Select the settings you want for your default font.
  4. Click the Default button.
  5. When the pop-up appears asking you to confirm that you want to apply the new font to the Normal template, click Yes.

All documents based on the Normal template will have the new default font. If wish to change another template, you must attach the template to a new document before changing the default font. Now follow these steps:

  1. Open a new document.
  2. Go to Tools | Templates And Add-Ins.
  3. Click the Attach button.
  4. Select the template you want to change. Press the Open button and then click OK.

Microsoft Excel

Customize workbook printing

When you print a worksheet in Excel, do you find yourself adding the same header and footer and resetting the same print options every time?

For example, suppose you require that all worksheets are printed with the company's custom header and set to print in landscape mode. Each time you create a workbook, you will need to change the default print settings, unless you create a custom template that will automatically give you the appropriate settings.

Here's how to create a custom template:

  1. Open a blank document. Select all sheets.
  2. Go to File | Page Setup.
  3. In the Orientation section, select Landscape, and then click OK.
  4. In the Header and Footer section, you can either select a header from the Header drop-down menu, or you can press the Custom Header button to create your header.
  5. Click OK.
  6. Go to File | Save As.
  7. Under File Name, enter a name for your template.
  8. Under Save As Type, select Template and click Save.

Now when you create a workbook based on your custom template, the header and print settings will automatically be set to your specifications.

Microsoft Access

Create a form-type Data Access page

Data Access pages provide an online viewer that lets you display and edit Access databases over the Internet. It's possible to create a form-type data access page for a single table or query using the Page Wizard.

For example, say your managers need to be able to access their employees' addresses, phone numbers, and e-mail addresses online. They can do just that if you create a form-type Data Access page. Here's how:

  1. Open the Employees database.
  2. Click the Pages object in the database window.
  3. Click New and then select Page Wizard.
  4. Select the Employees table on which to base the object data and click OK.
  5. Select the fields that you want displayed online and click Next.
  6. Click Next twice.
  7. Enter a title for the page, select Open The Page, and click Finish. The new data page is displayed.
  8. Close and Save the Data Access page to a folder that you (and your managers) can access online.
After the Data Page is saved, Access places a shortcut to it in the database window. The actual Data Page exists as an HTML file separate from the Access database to which it is connected.