TIPS

Corporate | Individual | Tips | SAGE Accounts | SAGE Payroll | ECDL | MOS | Dreamweaver | Centre Locations

Top tips

1. How to enter the Euro symbol in Word
2. Short cut keys for file menu
3. Multiple insertions of drawn objects in Office 2000
4. Create vertical controls in Access
5. Make your Excel Print outs fit the width of the paper
6. Multiple formatting of text and graphics in Office 2000
7. Change how text wraps around a graphic in Publisher
8. Picture bullets in Word 2000
9. Short cut keys for edit menu
10. Reset the Auto Number Field in Access
11. Prompted to enter a parameter value for the trim function
12. Shortcut to Page Setup in Word 97 / 2000
13. A flight simulator in Excel 97?

1. Press and hold the Ctrl and Alt keys and press 4. It wont work with the number pad, you have to use the numbers on the top row of the keyboard.
2. Press and hold Ctrl and Alt, then press the letter E.
3. Press and hold the Alt Gr key and press the number 4 .
4. Select the Insert Menu then choose Symbol . Scroll through the list until you see the Euro symbol, left click the symbol and then select Insert .

up

Short cut keys for file menu

Command		Key
New		Ctrl+N
Close		Ctrl+W
Save as		F12
Print		Ctrl+P
Open		Ctrl+O
Save		Ctrl+S
Print preview		Ctrl+F
Exit		Alt+F4

up

Multiple insertions of drawn objects in Office 2000

Instead of clicking on the drawing object button every time you want to insert an object take advantage of the drawing objects sticky feature.

1. To view the drawing tool bar right click any tool bar and select drawing.
2. To insert a drawing object several times, double click the drawing object button (such as rectangle) on the drawing tool bar. The button stays selected or “sticky”
3. Insert your drawing object several times by clicking in the appropriate locations.
4. When your finished to the “sticky” feature of press the drawing object button again or press Esc

up

Create vertical controls in Access

In Access 2000 you can create vertical as well as horizontal label or text boxes. Insert the label or text box in the usual way, click on properties and then click the other tab. Set the vertical property to yes.

up

Make your Excel Print outs fit the width of the paper

First click on page setup on the file menu, click the page tab under scaling, click fit to and select 1 page wide. In the second fit to box for how tall you want the data, delete the number so the box is blank.

up

Multiple formatting of text and graphics in Office 2000

If you want to add formatting to several non sequential words or graphics in FrontPage simply double click the format painter instead of the usual once. This holds the format painter on leaving you to click on anything you would like to format. To turn it off, click once on the format painter button in the standard tool bar.

up

Change how text wraps around a graphic in Publisher

You can adjust the amount of white space between text and a piece of clip art or any other graphic in Publisher.

1. Click the graphic.
2. On the format menu, click on picture frame properties.
3. Click picture only.
4. Click OK
5. On the formatting toolbar, click the edit irregular wrap button.
6. Grab the picture handles that surround the graphic until the space between the text and the graphic is the way you want it. To add additional adjust handles hold down Ctrl and click where you want the new handle to appear. To delete a handle hold Ctrl+Shift and click the handle.
7. When you're finished, click anywhere on the page.

up

Picture bullets in Word 2000

To liven up drab Word documents why not use picture bullets. First, select the items you want to add bullets to. On the format menu, click on bullets and numbering, and then click the bulleted tab. Click picture, and then click the pictures tab. Then select and insert the picture bullet you want.

up

Short cut keys for edit menu

Command		Key
Undo		Ctrl+Z
Clear		Delete
Copy		Ctrl+C
Select all		Ctrl+A
Replace		Ctrl+H
Bookmark		Ctrl+Shift+F5
Repeat		Ctrl+Y
Cut		Ctrl+X
Paste		Ctrl+V
Find		F5
Go to		Ctrl+G

up

Reset the Auto Number Field in Access

Ever wished you could reset the auto number field in access and get rid of all those gaps? Microsoft certainly has not come up with a solution but we have. First make a back up of the database to ensure against any mistakes. Now copy the table that has the irregular number order, call the new table the same as the original and add the number 1 to the end of the file name. Open the copied table and delete the row containing the auto number, close the table saving the changes. Next delete the original table clicking on yes to any warnings that follow. Re-opening the copied table and insert a row, call the field name and field type the same as the original and re-instate the primary key. Finally remove the number 1 you added to the table name and restore all links in the relationship table. The table should now be in a sequential order.

up

If you are prompted to enter a parameter value for the trim function while previewing a mailing label report

When you open an Access 2000 database that has been originally built in an earlier version and then converted to 2000 there are a few things that you need to be aware of. The parameter value dialog box relating to the trim function when opening a report is one of these.

The cause of this problem is a missing reference that is necessary in earlier Access versions that is not in Access 2000.

The cure is very simple:

1. Open your database, select the report with the problem and open it in design view.
2. On the View Menu click the code option.
3. The Visual Basic editor will now open, click on the Tools Menu then select References .
   
   
   
   
4. The References dialog box should now be open, deselect any options that begin with the word “Missing” and then click OK . In the example below the activeX control needs deselecting.
5. On the File Menu , click Save and then File Menu again, and select Close and return to Access.
6. The error messages in the report should have now all disappeared, check the details by pressing the Print Preview button on the standard toolbar.

up

Shortcut to Page Setup in Word 97 / 2000

A quick way of accessing the Page Setup dialog box in Word 97 / 2000, is to simply double click anywhere in either the horizontal or vertical rulers. However be careful if you double click too slow or click on the light grey strip below the horizontal ruler, this will set a manual tab and then open the tab dialog box.

up

A flight simulator in Excel 97?

Did you know Excel 97 has a flight simulator built in to the package? To access the simulator open up excel with a blank document, press F5 and type in the reference box X97:L97 and press enter. Next press tab once (cell M97 should be highlighted) hold down Ctrl and Shift and click on the Chart Wizard, the flight simulator should now be open. Use your mouse to steer left and right, up and down your left button to accelerate and right to stop.

up