Print each group of your Access report on a separate page
Thursday, June 26, 2008 02:00 PM
Follow these steps to print each group of your Access report on a separate page.
Microsoft Access
Print each group of your Access report on a separate page
You have a number of offices in various cities across the state. You need to send the latest employee information to each office.
You have already grouped your Employees report by city. Now you want to be sure that when this report is printed, each city’s employees list is printed on a separate page.
Follow these steps:
- Open the report in Design view.
- Click on the group header button for City.
- In the GroupHeader's Property sheet, click the All tab.
- Click the Force New Page property box drop-down arrow and select Before Section.
Now each city's employees list will begin printing on a new page.
Microsoft Word
Add hyperlinks that open in a new window
Hyperlinks make it easy for users to quickly go to a Web page without leaving their Word document, but you can make it even easier if the page opens in a new window outside of Word. Follow these steps:
- Click where you want to insert the hyperlink in your document.
- Type the following code:
HYPERLINK "http://www.microsoft.com"no "This Web Page will open in a new window."
- Select the field code.
- Press CTRL + F9.
- Click in the code.
- Press F9.
Pressing F9 converts the code to an actual hyperlink to the Web address. When the user hovers the mouse over it, the hyperlink is displayed in the document with a screen tip, as shown below:
Microsoft Excel
Quickly add text to your Excel 2002/2003 charts
To add text outside your chart titles, you usually have to create a text box. But with Excel 2002/2003, you can just type it in. Follow these steps:
- Select the chart you want to add text to.
- Start typing the text. As you type, the text will appear in the formula bar.
- Press Enter.
- Move and format the resultant text box.
The text will be displayed in a text box that can be moved and formatted as required.
Test Drive Now!
» Powerful server blade for SMBs
There are currently no comments for this post.