Use themes to spice up your e-mail
Word offers themes that you can use to send attractive announcements and invitations as e-mail messages. This feature automatically formats background colors, graphics, headings, body text, hyperlinks, table borders, bullets, and horizontal lines around a coordinated set of styles.
To add a theme to a document, follow these steps:
The document now assumes the styles and background of the chosen theme. Backgrounds are visible only when you view the document electronically and not when you print it.
To send the document as an e-mail, go to File | Send To | Mail Recipient. When the mail client opens, it displays and formats the document according to the selected theme in the body of the e-mail message.
Develop best- and worst-case models with Scenarios
Excel's Scenario Manager lets you develop best- and worst-case models of your data. For example, let's say you want to show what your monthly payment would be for a $10,000 loan if your current 6 percent interest rate falls to 5.9 percent or rises to 6.1 percent.
First, create a model for the current interest rate. Follow these steps:
To create the best-case model, click the Add button to return to the Add Scenario dialog box, and repeat Steps 2 through 5, but change the rate displayed in Step 5 to 5.9 percent. To create the worst-case scenario, change the rate displayed in Step 5 to 6.1 percent.
To view the scenarios, follow these steps:
To retain the original worksheet values, return to the current value scenario before closing and saving the worksheet.
Prevent blank fields with field properties
Access provides two special field properties that can ensure users will never leave a field blank. For example, suppose a Customer database includes a Fax_Num field. If this field is blank, it can mean that the customer doesn't have a fax number or that the number wasn't available during data entry.
To prevent a blank entry, follow these steps:
Now, users won't be able to leave the Fax_Num field without entering a value—even if it's "Customer does not have a fax machine."