microsoft: 2009-06-07

Saturday, June 13, 2009

Daily Tips and Tricks Special Delivery

Using PowerPoint Themes
With Microsoft Office PowerPoint 2007, you can easily change the look of your entire presentation with just one click. By applying a theme, you can be confident that your entire presentation has a professional look.
1. Go to the Design tab.
2. Pause on different themes in the Themes gallery to see a preview of how the presentation looks with the theme applied.
3. Click the theme that you want to apply to your presentation.

Generate Random Text in Word 2007
On a blank line in a Microsoft Office Word document, type =rand followed by (PC,SC)—where PC stands for paragraph count and SC stands for sentence count—and then press ENTER. For example, =rand(2,3) will create two paragraphs of three sentences each.

Word inserts some random text based on your specification. You can use this new text for testing form controls such as text boxes or paragraph alignments.

•	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

Friday, June 12, 2009

[+/-]

Daily Tips and Tricks Special Delivery

Working with Prebuilt Templates
The new Getting Started window includes a variety of prebuilt database solutions. You can use these solutions right out of the box, or you can enhance and refine them to accommodate the kind of information you want to track or the way in which you want to track it. To open a template:
1. Start Microsoft Office Access 2007.
2. Browse the categories to find the template you want, and then click it.
3. Browse for a folder, and then click Download.

To Create a New Table
Microsoft Office Access 2007 has made creating tables easy by providing a handful of common schemas.
1. On the Ribbon, on the Create tab, in the Tables section, click Table.
2. Type the first value in the cell, just as you would in a Microsoft Office Excel spreadsheet, and then press ENTER.
3. Double-click the column heading to rename the field.

Based on the value typed, Access automatically defines the data type, although it does so differently from a spreadsheet. In Access, each field—a column in your datasheet—is defined by a data type.