Create PowerPoint Presentations from Access Data and Templates
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.

- 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.
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.
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.
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.
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
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.
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.

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.

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.




