Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

Hasina has attended:
Access Intermediate course

Access 2003

Can we import Access reports to Power Point?

Edited on Tue 6 May 2008, 17:20

RE: Access 2003

Hi Hasina, Thank you for your post, welcome to the forum, in answer to your question, there is no direct link from an Access Report to a PowerPoint Slide, however the accepted method of operation is to export the Report to either Word or Excel where you can tidy it up as necessary and then from PowerPoint Menu, select Insert>Object.
From the Options displayed choose Create from File, Click Browse, navigate to the folder where the file you have imported your Report to is located, and click the file, in the Insert Object dialog box, click the Link tick box and click OK;
You can now resize your Report to fit your chosen space in the slide.
I know its a bit longwinded, bit like changing trains half way through your journey.....
But I hope that helps, best regards Pete.

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.