Add a separator between the document body and the header or footer
(Word 97-2000-2001-2002)!
Professional publications and letterhead often use a thin line or
"rule" to add visual separation between header and footer elements
and the document body. Creating this effect in your Word documents
is probably easier than you thought. If your first instinct is to
create a tabbed underline or to use the Line button on the Drawing
toolbar, you'll be glad to know there's a much better tool for the
job: paragraph borders. To add a rule to the header or footer,
choose View | Header And Footer from the menu bar, and then access
the header or footer you want to format. If you want to add a rule
at the bottom of the header, place the insertion point in the
header's last line; if you want to add a rule at the top of the
footer, place the insertion point in the footer's first line.
Next, choose Format | Borders And Shading from the menu bar. Click
on the Borders tab, then use the Style, Color, and Width dropdown
lists to specify the type of rule you'd like to apply. Select
Paragraph from the Apply To dropdown list. Then, if you want the
rule to appear at the bottom of the header, click the Bottom
Border button in the Preview area. Or, if you want it to appear at
the top of the footer, click the Top Border button instead. When
you've finished, click OK to close the Borders And Shading dialog
box. Then click Close on the Header And Footer toolbar to return
to your document. To preview the results, click the Print Preview
button on the Standard toolbar.
Using AutoFormat In Excel 2000!
If you wish to create attractive worksheets for your managers to
view, just remember the word "AutoFormat." There is no better,
quicker, or easier way to produce great looking Excel worksheets.
To investigate what AutoFormat can do for you, open a blank
worksheet and enter some text titles into cells A1, C1, and E1.
Now enter data into cells A2, C2, and E2. Then enter more data
into cells A3, C3, and E3.
Select the range of cells that contain titles and data and choose
Format|AutoFormat. This will open the AutoFormat dialog box from
which you can select the format you want to use. After you make a
selection, click OK to apply your selection and close the dialog
box.
Streamline emailing Access data (97-2000-2002)!
If you need to electronically send information stored in Access to
another user, you may export the data to a file and then attach
that file to an email message. If so, chances are that you're
going through more work than is necessary to complete the task.
Access has built-in functionality that allows you to easily email
an Access object in a variety of formats. For instance, you could
email a table as an HTML file, send a form's underlying data as an
Excel file, or send a copy of a report saved as a read-only
snapshot file.
You can email an open object or one that is selected in the
Database window. While the appropriate object is selected, choose
File | Send To | Mail Recipient (As Attachment). Access then
displays a dialog box that lists the available file formats that
can be used. Choose the format you want and click OK. You may then
be prompted to configure settings that are specific to the format
you selected. Once all of the required settings have been
specified, your default email application creates a new blank
email. The appropriate data is automatically attached or embedded
within the email, depending on the file format and email
application you're using.
|
|