access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007

Access 2007

resolvedResolved · High Priority · Version 2007

replyReply Wed 1 Apr 2009, 15:58Delegate Owen said...

Owen has attended:
Access Introduction course

Access 2007

Hello,

I am trying to use Access' pivotchart tool to quickly create charts that i can then export to powerpoint easily (i do not use excel because i have lots of data!). Is there an easy way of exporting the pivot table/chart to powerpoint?

Many thanks in advance!

Owen

For upcoming training course dates see: Pricing & availability

replyReply Thu 2 Apr 2009, 09:32Trainer Simon said...

RE: Access 2007

Hi Owen,

Thank you for your question.

As far as I am concerned, Access Pivot Tables and Charts cannot be copied into a PowerPoint slide. However, you could create your pivot table or chart and press print screen (PrtSc) on your keyboard. Go to the PowerPoint slide and paste the item in. Use the Crop tool if you need to remove any parts of the picture you don't need.

Alternatively, you could copy the Pivot Chart or Table into Excel using the export to excel option within access. This imports the table and the data.

I hope this answers your question.

Regards

Simon



Thu 9 Apr 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
microsoft-access-courses and other Microsoft training courses.

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard