- Date: September 30th, 2008
- Author: Mary Ann Richardson
Set up a simple form that can quickly tell you how long you’ve been working on a project. Mary Ann Richardson walks through the process.
Do you need to know how long you’ve spent on a project? You can create an Access form that will answer that question for you. Follow these steps:
- Click on the Form Object in the Database Window and click New. (In Access 2007, click the Create tab and then click Forms Design in the Forms group.)
- Click the Text Box control tool and then click and drag in the form where you want to locate the control.
- Click on the text box label and change the caption to Enter Project Start Date.
- Right-click the text box and select Properties.
- Click in the Name Property box and enter ProjectStart.
- Click the drop-down arrow of the Format property box and select cialis c20 ShortDate 6.
- Click the Text Box control tool and then click and drag in the form to create a second text box below the first one.
- Click the text box label and change the caption to Actual Work in Months, as shown in Figure A.
Figure A
-
Right-click the second text box and select Properties.
-
Click in the ControlSource property box and under the Data tab, click the Build button.
-
Type the following function code as shown in Figure B:
=DateDiff(”m”,[ProjectStart],Now())
Figure B
-
Click OK.
-
Close and save the form as Total Work Calculations.
When you run the form and enter a date in the ProjectDate text box, Access will automatically display the number of months from the entered date to today, as shown in Figure C.
Figure C
- Date: September 26th, 2008
- Author: Susan Harkins
Word lets you insert a graphic into a document’s header or footer. Excel’s not so flexible, but you can cheat. Insert the graphic and specify it using the Print Titles feature. Excel will print the graphic at the top of each printed page, which is really what you want — header or not.
The first step is to get the graphic into the workbook. Try to insert it into cell A1 and then adjust the cell’s height to accommodate it, but that might not work. Depending on the size of the graphic, Excel might insert cialis c10 it as is, usurping several rows and columns. To insert a graphic, choose Picture from the Insert menu, select From File, locate the file, and then click Insert. In Excel 2007, click Picture in the Illustrations group on the Insert tab.
The next step is to identify the graphic using the Titles feature as follows:
- Choose Page Setup from the File menu and click the Sheet tab. In Excel 2007, the Page Setup group is on the Page Layout tab.
- Click the row or drag across the rows that contain the graphic. Or enter the rows in the Rows To Repeat At Top control. For instance, the RabbitTracks graphic (above) covers rows 1, 2, and 3. Therefore, you’d enter $1:$3. When you finish, click OK.
Click Print Preview to view the graphic on all pages of the worksheet. You can’t really tell, but the following picture shows the second page of a long sheet, and each page displays the same graphic at the top.
- Date: September 30th, 2008
- Author: Susan Harkins
PowerPoint’s AutoContent wizard gives you a head start on setting up a presentation based on various prefab templates. But you can also plug your own presentations into the wizard, making it easy to reuse their design, structure, and content.
The AutoContent Wizard is a great place to start when you’re not sure what a presentation should cover. This wizard creates a new presentation using built-in templates, offering content ideas to help you organize the information you include on each slide.
What you might not know is that you can add an existing presentation to the AutoContent Wizard’s library. To do so, follow these steps:
- Launch the wizard by choosing New from the File menu.
- Click the From AutoContent Wizard link in the New Presentation task pane.
- Click Next in the wizard’s first pane.
- Choose the most appropriate content template category from the list (Figure A) and click Add.
Figure A
-
Locate the presentation you want to use as a content template and click OK.
-
Proceed through the rest of the wizard’s prompts.
The presentation you added is now available to use as a template when you run the AutoContent Wizard.
Don’t cialis buying let a good generic presentation go to waste. You’ll still have to customize it to suit your particular purpose, but that’s true of any content template you choose.
Notes: The AutoContent Wizard isn’t available in PowerPoint 2007. Instead, use a themed template. Choose File from the Office menu and select New to get started.
Microsoft offers more free templates.
- Date: September 30th, 2008
- Author: Mary Ann Richardson
One of the most common word processing chores is changing the case of text in a document. You can greatly streamline the process if you learn a couple of Word’s most useful keyboard shortcuts.
Do you find yourself continually pressing the Caps Lock key to change from uppercase to lowercase, and vice versa, as you type? While the Caps Lock key is better than having to search for the Change Case commands with the mouse, you can’t use it to change the case of text that has already been typed.
Word does provide a couple of toggle key combinations you can use to change the case of selected text without retyping. For example, say you typed the following text and want to change it to all uppercase:
Caution! To avoid injury, please read all instructions first.
Just select the text and press Ctrl + Shift +A.
You can also use this key cialis buy online combination to change case as you type. Follow these steps:
- Press Ctrl + Shift + A.
- Type: Caution! To avoid injury, please read all instructions first.
- Press Ctrl + Spacebar to return to lowercase.
Another helpful key combination is Shift + F3, which lets you toggle case from lowercase to uppercase and then to initial caps. For example, say you just typed Tcp/Ip. To change it to all uppercase, select it and then press Shift + F3. To change the phrase “All’s well that ends well” to initial caps, select the text and then press and hold the Shift key while you press F3 three times.
- Date: September 29th, 2008
- Author: Susan Harkins
If you’re like me, you live and breathe by your contacts. They’re vital to my business, as they probably are to yours. When I’m on the road without cialis buy on line remote access, that can be a problem. I know that I can print my contacts, but taking the .pst file with me is much better. (The .pst file contains your contact information.) It’s a simple process:
- From the File menu, choose Import And Export.
- Choose Export To A File and click Next.
- From the list of file types, choose Personal Folder File (.pst) and click Next.
- Select Contacts and click Next.
- Save the exported file to your flash drive (or a CD).
- Click Finish.
To use the file, you can simply import it into Outlook on another computer. But you should also be prepared to not have access to Outlook. Repeat the above process again, saving your .pst file as Microsoft Excel file and a comma-delimited text file (Comma Separated Values). If the worst happens, you can at least view the information.
Now, you probably already knew that you could export the .pst file. What you might not have considered was how easily you could save that exported file to a flash drive and take it with you.
