Monthly Archive for October, 2011

Microsoft Access Tips – Convert a Form into a Report

If you have created a form in Microsoft Access and you want to convert it into a report then follow these steps:

      
     

  1. Open the form in Design View
  2. Click on the Microsoft Office Button
  3. Click on Save As
  4.  In the Save As Dialog box Select Report
  5. Click OK
  6. The system creates a report based on the form you have created.

 
Look at our Microsoft Access Courses for more information

Microsoft Word Tips – Edit 2007 Documents in Print Preview

Did you know you can edit your documents in Word 2007 Print Preview? This way you can see what your document would look like when printed, and if something isn’t right you can change it. Here’s how to edit it.

     

  1. Click on the Microsoft Office Button
  2. Go down to the arrow next to print and select Print Preview
  3. Make sure that the Magnifier Box on the Ribbon is Not checked
  4. You can then edit your document if you need to

 

Wea re going to write about the 2010 version next time so keep reading
 
Book yourself onto one of our Microsoft Word Courses if you want to learn more

Microsoft Publisher Tips – Design Checker

Before you print out a design in Microsoft Publisher 2007, try using the Design Checker, to catch out any flaws you may have missed. This utility checks your design looking for any design problems, for example, text that is too close to the edge of a page or an object that is not visible. Design Checker will allow you to correct any mistakes; instead of finding them after you’ve printed your design.

     

  1. On the Menu Bar click on Tools
  2. Choose Design Checker
  3. This will open up the Design Checker Pane
  4. It will list any design errors it has found in the pane
  5. Click on the dropdown arrow next to the error it has found
  6. Click on Fix, if you want it to change it automatically
  7. Click on Go to this Item, if you want to change it yourself
  8. If you don’t want something changed click on Never Run this Check Again
  9. Click on Explain if you don’t understand what it means
  10. Click on Close Design Checker when you have finished

 
Visit our Microsoft Publisher Tips page for more useful information

Microsoft PowerPoint Tips – Re-colouring Clipart Pictures

Did you know in Microsoft PowerPoint 2007, you can re-colour clipart pictures if you don’t like their original colours, if you want to change the colour here’s how to do it:

     

  1. Click on the Insert Tab on the Ribbon
  2. Choose Clipart
  3. In the Search for box, type in an image you want to use
  4. Double click on it to insert it into the slide
  5. Click on the Format Tab on the Ribbon
  6. Click on the Recolour icon
  7. Choose and click on the colour you want the image to have

 
Visit our Microsoft PowerPoint Tips page for more useful information