Access Tip (Shortcut keys)

EVERYONE LOVES A SHORTCUT

Since everyone likes shortcut keys, here's a collection for Access.

ACTION KEYS TO PRESS

Display Control menu Alt+Spacebar
Open Replace dialog box Ctrl+H
Open new database Ctrl+N
Open existing database Ctrl+O
Paste the Clipboard contents at the cursor Ctrl+V
Copy to the Clipboard Ctrl+C
Cut to the Clipboard Ctrl+X
Undo Ctrl+Z
Open Find Ctrl+F

PowerPoint Tip Pictures in a presentation

Steps to bring pictures into Power Point.

1. Get a picture file from the net or a camera, save it to disk, andremember its location. (You can save pictures that you see in netscapeby right clicking the pictures and selecting "Save Image As..")
2. Go to the slide in your presentation that you wish the picture to bein.
3. In Power Point click Insert -> Picture -> From File...
4. A dialog box will come up called "Insert Picture"
5. You must use the "Look in:" drop box to select the drive/dir thatyour file is in. Then select the image that you saved to disk earlierand click the "Insert" button.
The picture should now be in your Power Point slide.
Steps to add a special effect to the picture.
1. Right click the picture and select "Custom Animation..."
2. In the "Entry animation and sound" section you can select theanimation that you would like your picture to perform. Chose one thenclick the Timing tab.
3. Make sure that your picture is still selected in the "Animationorder" box.
4. The most common setting for Timing is to have the Animate andAutomatically selected in the "Start animation" section.
5. select how many seconds delay you want, click OK, and it should beready to go.

Excel Tip Using hyperlinks to link to next sheet

Although we've often discussed how to use hyperlinks in Word and PowerPoint documents, we haven't discussed hyperlinks in Excel worksheets.
Let's say you're working with a large workbook--one that contains multiple sheets. When you go through the workbook, you may want to make your way to the final sum on the first worksheet and then go to the next worksheet. In this case, why not use a hyperlink to take you to the next sheet?
Click the cell that contains that last sum and choose Insert, Hyperlink. When the Insert Hyperlink dialog box opens, click the Bookmark button. Select Sheet2 (under the Cell Reference title) and click OK. Back in the Insert Hyperlink dialog box, click OK to close the dialog box and save your selection. All you have to do now is click the last sum cell to move to the next sheet.
Suppose that now you'd like to go from that last sum cell to a specific cell in Sheet2. To do this, you'll have to name the target cell in Sheet2. Go to Sheet2 and click the target cell. Choose Insert, Name, Define. When the Define Name dialog box opens, type in a name and click OK.
Now, go back to that last sum cell in Sheet1. Click the cell and choose Insert, Hyperlink. When the Insert Hyperlink dialog box opens, click the Bookmark button. Now, in the Select Place in Document dialog box, you will see your target cell's name (under the Defined Names title). Select it and click OK. Click OK back in Insert Hyperlink to close the dialog box and save your changes.
When you click the hyperlink now, Excel will take you directly to the target cell in Sheet2.