Home > Support > Hints and Tips > Tip of the Week

Weekly Computer Tip # 151
15 April 2006

Start each week with a free tip

To subscribe, please type your email address in the box below:

export your data to Word or Excel (Microsoft Access)

Flicking through the "Happy Sheets" of a Hands Off training session I did earlier this week, I notice that somebody mentions the fact that you can modify the look of your report using Word was one of her favourite tips she picked up that day. You can also export your data to an Excel spreadsheet so that you can utilize Excel's analytical features.

Here's how:

  1. Select (or Preview) the Report you want to export.
  2. Click the drop-down arrow next to the OfficeLinks button on the toolbar. (The button looks like the blue Word icon. If you cannot find the icon on your toolbar, use the Tools, OfficeLinks command.)
  3. Select either Publish It with Microsoft Office Word or Analyze It with Microsoft Office Excel.

Apart from Reports, you can use the OfficeLinks feature to export Tables, Queries or Forms to Word or Excel. That way you can, for instance, email your data to someone who doesn't use Access.

By the way ... for those of you who are still sceptical about the Hands Off approach, here are some comments taken from last week's evaluation forms ... "Hands Off was great as one could really focus rather than getting bogged down with examples." "I thought I would "switch off" but you can concentrate more on the content knowing you have material to practice on later."

So why not find out for yourself and come along to the next Hands Off Excel with Excel seminar, scheduled for 11 May. There are still places left and existing customers qualify for a 40% discount! See http://www.roem.co.uk/handsoff_excel110506.html for full details or get in touch if you would like any further information. Hope to see you in May!!

Until next week.

Karen
Email this page to a friend

Enter recipient’s email address in the box below:



PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.


Home   Training   Support   Clients   Contact Details   News   Disclaimer  

© Roem Ltd. All Rights Reserved
April 2006