Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Modifying the Report Here's how you can modify a report in Microsoft Office Access 2007. 1. Ensure you are in Layout view, which is the default view if you have just created a new report. 2. Select the fields (columns) that you want to delete (press SHIFT to select multiple fields), and then press DELETE. 3. Resize columns by dragging the column edge to the width you want. 4. To reorder columns, select the column that you want to move, and then drag it to another location. 5. Double-click the report title to modify it. 6. To add banded rows, select a row. Then on the Formatting contextual tab, in the Font section, choose a color from Alternate Fill/Back Color. 7. To add a group, in the Grouping pane, click Add a group. If the pane is not open, on the Ribbon, on the Formatting tab, click Grouping. Select the fields that you want to group. 8. To change to Landscape mode or adjust margins, go to the contextual Page Setup tab. Deal Efficiently with Nonessential E-Mail While You're Out of the Office To create e-mail rules that apply only when you're out of the office: 1. On the Tools menu, click Out of Office Assistant. 2. Click Add Rule. In the Edit Rule dialog box that opens, you can set aside for later any nonessential messages you receive while you're away. Alternately, you can forward a copy of these e-mail messages to someone else. • Tips and Tricks Web site • Microsoft Office Online • Help Privacy note: Microsoft respects your privacy and that of your friends. Please do not use the Tell a Friend button to send mail to more than 10 people. Microsoft cannot collect any data about the people you send mail to unless they sign up for Tips and Tricks Special Delivery. To cancel your subscription to this newsletter, reply to this message with the word "unsubscribe" in the subject line. You can also unsubscribe at the Microsoft.com Profile Center. You can manage all your Microsoft.com communication preferences at this site. Legal information Microsoft Corporation One Microsoft Way Redmond, WA 98052 Sign up for other newsletters | Unsubscribe | Update your profile © 2009 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement