Others

Create PowerPoint Presentations from Access Data and Templates

Aamir Naveed AkramAamir Naveed Akram Nov 20, 2026 869 views

Question details

Create a PowerPoint presentation from Access records and a template, placing each part-specific slide within a defined area and displaying its part number.

Create PowerPoint Presentations from Access Data and Templates
Product
Microsoft Access and Microsoft PowerPoint
Device & OS
not provided
Scenario
Access VBA opens part-specific presentations and combines their content with a PowerPoint template.
Observed behavior
Copying a source slide into the target presentation inserts it at full-slide size instead of fitting it into the intended placeholder area.
Before you start

In PowerPoint, open the template and use Home > Select > Selection Pane to identify the content area and the text box for the part number. Make sure each Access record supplies a valid source presentation path and part number, and that your Access database is trusted to run VBA.

Solution 1Recommended

Export each source slide as an image and fit it to the template area

Use this approach when Access VBA already identifies the source presentations and needs to place their first slides inside a template layout.

A slide cannot be pasted directly into a placeholder as a slide. Exporting it as a picture lets VBA position and scale the visual content over the placeholder area without filling the entire target slide.

The inserted picture is static: its individual text boxes and shapes are not editable. The template's header text box remains editable.

1
Name the template shapes

In PowerPoint, open Home > Select > Selection Pane. Name the large target shape ContentArea and the part-number text box PartHeader. Make sure both shapes are available on each target slide used by the code.

2
Add the placement procedure

In Access, press Alt+F11, choose Insert > Module, and add this VBA procedure: Public Sub PlacePartSlide(ppApp As Object, targetSlide As Object, sourcePath As String, partNumber As String, imagePath As String) Dim sourcePres As Object Dim area As Object Dim pic As Object Dim scaleFactor As Double Set sourcePres = ppApp.Presentations.Open(sourcePath, True, False, False) sourcePres.Slides(1).Export imagePath, "PNG" sourcePres.Close Set area = targetSlide.Shapes("ContentArea") Set pic = targetSlide.Shapes.AddPicture(imagePath, False, True, area.Left, area.Top, -1, -1) pic.LockAspectRatio = True scaleFactor = area.Width / pic.Width If pic.Height * scaleFactor > area.Height Then scaleFactor = area.Height / pic.Height pic.Width = pic.Width * scaleFactor pic.Left = area.Left + (area.Width - pic.Width) / 2 pic.Top = area.Top + (area.Height - pic.Height) / 2 targetSlide.Shapes("PartHeader").TextFrame.TextRange.Text = partNumber Kill imagePath End Sub

3
Call the procedure for each part

In your existing Access VBA record loop, create or select a target slide from the template and call the procedure with your PowerPoint application, target slide, source path, part number, and a temporary PNG path. For example: Call PlacePartSlide(ppApp, targetSlide, CStr(rs!SourcePath), CStr(rs!PartNumber), Environ$("TEMP") & "\part-slide.png"). Adjust the recordset field names to match your database.

4
Review and save the presentation

In PowerPoint, check that each picture is centered within ContentArea and that PartHeader contains the correct part number. Save the completed presentation using File > Save As.

Export each source slide as an image and fit it to the template area
Use a safe temporary path: The procedure deletes the PNG at imagePath after embedding it. Use a temporary filename that does not contain a file you need, and use unique names if multiple runs can overlap. Add error handling to close the source presentation and remove temporary files if processing fails.
Free Microsoft Office alternative

Review and edit presentations with WPS Office

WPS Office is a free, lightweight alternative with a familiar presentation interface. Open compatible PowerPoint files to review or edit slides as you migrate your presentation work; it does not replace the Access-to-PowerPoint VBA automation described above.

Open and edit Microsoft PowerPoint PPT and PPTX filesReview part-specific slides and adjust pictures and text boxesUse familiar presentation tools in a lightweight office suiteWork with compatible Office documents during migration
microsoft office alternative - wps office

Frequently Asked Questions

Why does the copied slide fill the entire target slide?

Copying and pasting a slide inserts it as a slide rather than as content inside a placeholder. Export the source slide as a PNG, then use Shapes.AddPicture and size the picture to the target area's bounds.

Can I edit the individual objects after inserting the slide as a picture?

No. The exported PNG is a single static image. Keep the original source presentation if you need to edit its individual shapes or text later.

How can I display the Access part number on each slide?

Add a text box to the template slide, name it PartHeader in Home > Select > Selection Pane, and set its TextFrame.TextRange.Text property from the Access record's part-number field.

How do I keep the source slide from being stretched?

Set the inserted picture's LockAspectRatio property to True, then scale it to fit within the content area's width and height. Center it using the area's Left and Top coordinates.