• DynamicPowerPoint.com
  • SignageTube.com
  • SplitFlapTV.com

PresentationPoint

How to Link PowerPoint to Microsoft Access Databases That Drives Real-Time Presentations

Nov 20, 2014 | DataPoint , DataPoint Real-time Screens , How-To

How to link PowerPoint to a Microsoft Access database? 10

Add connection

browse to select the microsoft access database on your hard disc or network

Webucator is a provider of Microsoft Access training classes.

creating a powerpoint presentation from access data

Dear Sir/Madam, I downloaded the DataPoint tool to connect Access to Powerpoint. I would like to insert pictures to Powerpoint but as I can see all the pictures hold the proportion of the first picture. Is there any solution to use it like a frame with different picture-sizes? Thanks for advance. Attila Vigh

admin

Hi Attila, I assume you mean that you have a difference in landscape and portrait images. Something like that, right? With 1 picture on your slide, you are probably not able to fix that. You probably need 2 picture boxes; one for portrait mode, one for landscape mode and calculate e.g. in your database with your orientation is. Based on the orientation, you either fill in column A or column B, so that only one picture is visible. Without DataPoint, you would have the same problem with 1 picture box only. Does that helps you in the right direction? There is another article on images (not the orientation) at https://presentationpoint.com/blog/dynamic-pictures-in-powerpoint/

M. A. ALGhalayini

Could I automatically color a map presented in Powerpoint based on an ACCESS table?

Admin

We cannot fill or recolor a map but we can make the filename of the linked image (with its specific color) dynamic. We have an article prepared for that. Will email it to you.

Submit a Comment

Your email address will not be published. Required fields are marked *

Pin It on Pinterest

  • StumbleUpon
  • Print Friendly

Access Cookbook by

Get full access to Access Cookbook and 60K+ other titles, with a free 10-day trial of O'Reilly.

There are also live events, courses curated by job role, and more.

Create a PowerPoint Presentation from Access Data

You need to create similar Microsoft PowerPoint presentations over and over. You currently take an existing presentation, copy it to a new location, and modify it as necessary, resulting in a number of copies of the same text littering your hard disk. It seems that you could just store all the text and its formatting information in an Access table and then create the presentation programmatically when necessary. Then, you could choose just the slides you need, make modifications as necessary, and have only one place where you store the data. Is this possible?

Microsoft PowerPoint (part of Microsoft Office) offers an amazingly rich set of objects, methods, and properties. Even though it’s not a developer’s tool, its object model is spectacularly deep, especially in comparison to Access’s. It appears that you can do anything programmatically from an Automation client (such as Access) that you can do manually, using PowerPoint as an Automation server—so the answer to the original question is “Yes!” You can definitely create presentations programmatically from Access using tables to store all the information about your presentation.

This solution involves two major activities: setting up the data in tables and using the interface to create your presentation. This section demonstrates both activities.

To try out the sample application, load and run frmPowerPoint from 12-07.MDB . First choose a template from the combo box’s ...

Get Access Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Don’t leave empty-handed

Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.

It’s yours, free.

Cover of Software Architecture Patterns

Check it out now on O’Reilly

Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.

creating a powerpoint presentation from access data

creating a powerpoint presentation from access data

  • Search forums
  • Microsoft Access Discussion
  • Modules & VBA

Creating PPT presentation automatically from Access

  • Thread starter doma23
  • Start date May 25, 2010

Registered User.

  • May 25, 2010

DCrake

Try this Link  

Similar threads

  • Jan 21, 2024
  • Nov 28, 2023
  • Jan 6, 2024
  • Oct 7, 2023

Uncle Gizmo

Users who are viewing this thread

creating a powerpoint presentation from access data

Top Contributors in Access: GroverParkGeorge  -  Ken Sheridan  -  Scottgem  -  Duane Hookom  -  Tom van Stiphout   ✅

February 13, 2024

Top Contributors in Access:

GroverParkGeorge  -  Ken Sheridan  -  Scottgem  -  Duane Hookom  -  Tom van Stiphout   ✅

  • Search the community and support articles
  • Microsoft 365 and Office
  • Search Community member

Ask a new question

Populate Powerpoint out of Access database

Hello, I want to create a Powerpoint presentation with data out of an Access database.

Filling Textboxes in the PPT is no problem. But in my Access table I also have a "OLE-object" field containing a picture.

Can anybody tell me how I can transfer this OLE-object field into the PPT?

Thank you in advance

createslide: Set currentSlide = pptPres.Slides(xslide) currentSlide.Shapes("Textbox1").TextFrame.TextRange.Text = rs1![field1] currentSlide.Shapes("Textbox2").TextFrame.TextRange.Text = rs1![field2] currentSlide.Shapes("Textbox3").TextFrame.TextRange.Text = rs1![field3] currentSlide.Shapes("Textbox4").TextFrame.TextRange.Text = rs1![field4] Debug.Print currentSlide.Name Return

Report abuse

Replies (1) .

Tom van Stiphout

  • Volunteer Moderator |
  • Article Author

Was this reply helpful? Yes No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

Thanks for your feedback.

Question Info

  • Norsk Bokmål
  • Ελληνικά
  • Русский
  • עברית
  • العربية
  • ไทย
  • 한국어
  • 中文(简体)
  • 中文(繁體)
  • 日本語

FPPT

MS Access and PowerPoint

Sending data from MS Access database to Microsoft Office PowerPoint slides is possible and that is exactly what Tim Getch did in this post ,  here you can learn how to transfer data from a Microsoft Office Access database into a PowerPoint presentation.

The immediate answer is that you can’t export data directly from Access to PowerPoint however you can automate the task to fit your needs and write VBA code to process this task.

MS Access and PowerPoint

In the article we can learn two different ways of interacting between Access and PowerPoint .

The first example will show you how to create a PowerPoint presentation from the data inside a MS Access table using Automation.

The second approach shows how to display and manipulate an existing PowerPoint presentation inside of a MS Access form, also using Automation.

Automation gives you the ability to control one application from another by manipulating the controlled application’s exposed properties and methods, and responding to events.

You can learn about this approach in the original article here  but also in Database Lessons in another article here that explains how to send data from MS Access to PowerPoint.

What if I need to import data from SQL to PowerPoint?

Later you might be tempted to migrate data from other DBMS like MySQL or Oracle to PowerPoint presentations. To accomplish this we can use other free and commercial tools that helps to run SQL queries and import the data into PowerPoint, ODBC is also a good alternative to import data from database into PowerPoint to create charts or tables dynamically.

We will send you our curated collections to your email weekly. No spam, promise!

creating a powerpoint presentation from access data

Microsoft Access Forums - Powered by vBulletin

  • Mark Forums Read
  • What's New?
  • How to Post a Question
  • How to Mark Thread Solved
  • How to Attach Files
  • Advanced Search

Home

  • Access Forums

Adding Data From Access To Powerpoint

  • AccessForums.net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please join our community , the registration is free and takes only one minute.

Thread Tools

  • Show Printable Version
  • View Profile
  • View Forum Posts

DMT Dave is offline

Hi Guy's, i have done some searching and adapting what i can find so far, i am trying add data from Access to Powerpoint, has anyone achieved this or know a solution (adsbygoogle = window.adsbygoogle || []).push({}); I am receiving a Msg object doesn't support this method on this line: pptPres.Slides(i) = rs.Fields("Name") & " - " & rs.Fields("Town") & vbCrLf Code: Dim rs As DAO.Recordset Dim pptApp As New PowerPoint.Application Dim pptPres As PowerPoint.Presentation Dim sFile As String Dim currentSlide As Slide Dim i As Integer sFile = "C:\Users\davem\Desktop\Driver.pptx" Set rs = CurrentDb.OpenRecordset("Query28") Set pptPres = pptApp.Presentations.Open(sFile) For i = 1 To pptPres.Slides.Count Set currentSlide = pptPres.Slides(i) Do Until rs.EOF pptPres.Slides(i) = rs.Fields("Name") & " - " & rs.Fields("Town") & vbCrLf rs.MoveNext Loop Debug.Print pptPres Next Set currentSlide = Nothing pptPres.Close Set pptPres = Nothing pptApp.Quit Set pptApp = Nothing Application.FollowHyperlink sFile

Welshgasman is offline

No idea Dave TBH, but YouTube has plenty of videos? https://www.youtube.com/watch?v=nuPDDfLjOBM However just looking at your code, you put all the recordset in the first slide and nothing in the others? Plus what is the point of CurrentSlide?, you do nothing with it?
Please use # icon on toolbar when posting code snippets. Cross Posting: https://www.excelguru.ca/content.php?184 Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
WGM, thank you for spotting my silly error

Please reply to this thread with any new information or opinions.

Similar Threads

Access delivery from within powerpoint, access form to powerpoint, access reports into powerpoint, insert a powerpoint presentation into access, exporting data to powerpoint, posting permissions.

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  • BB code is On
  • Smilies are On
  • [IMG] code is On
  • [VIDEO] code is On
  • HTML code is Off

Forum Rules

  • Microsoft Access Forums
  • Privacy Statement

creating a powerpoint presentation from access data

All Formats

Microsoft Office

How to link powerpoint to a microsoft access database.

Microsoft PowerPoint has a feature, DataPoint, which allows you to link your PowerPoint presentation to a Microsoft Access database.

creating a powerpoint presentation from access data

Step 1: Go to the DataPoint Tab in the PowerPoint Menu

how to link powerpoint to a microsoft access database step

Step 2: Browse the Microsoft Access Database File

how to link powerpoint to a microsoft access database step 0

Step 3: Add a Query

how to link powerpoint to a microsoft access database step 0

Step 4: Link Using a Text Box

how to link powerpoint to a microsoft access database step 0

What is the function of Microsoft PowerPoint DataPoint?

Where can i locate the datapoint tab, why connect a powerpoint presentation to a microsoft access database, more in microsoft office, all saints day quote linkedin post template, white day linkedin post template, construction technology linkedin post, construction industry news linkedin post, sustainable construction linkedin post, construction safety awareness linkedin post, construction testimonial linkedin post, construction tips and tricks linkedin post, construction linkedin post, father's day linkedin post.

  • Microsoft Word + ChatGPT
  • Microsoft Teams + ChatGPT
  • Microsoft Outlook + ChatGPT
  • Microsoft PowerPoint + ChatGPT
  • Microsoft Excel + ChatGPT
  • Microsoft Copilot + ChatGPT
  • How to Create a Microsoft Form in SharePoint
  • How to Change Language in Microsoft SharePoint
  • How to Connect Access with Microsoft SharePoint
  • How to Extend Microsoft Visio 2010 Trial
  • How To Create Fillable Forms in Microsoft Word
  • How to Send Notifications to SharePoint User Group
  • How Does Microsoft Visio Relate to Network Documentation
  • How to Build/Publish in Microsoft SharePoint
  • How to Check Microsoft Visio Product Key

Indezine Logo

  • PowerPoint Cool Stuff

Access in PowerPoint

Integrate a Microsoft Access database within a PowerPoint slide.

Author: Naresh Nichani

Product/Version: PowerPoint

Date Created: February 16, 2009 Last Updated: February 28, 2009

Naresh Nichani

Naresh Nichani is a Most Valuable Professional (MVP) for Microsoft Access based in Chennai, India. Naresh runs a software development firm that specializes in Visual Basic development and Office integration. He enjoys programming with Microsoft technologies as they are fairly easy to use and developers can build fairly complex solutions for customers with visually appealing interfaces quickly. Naresh does custom development.

First of all, this is not a tutorial rather it is a walkthrough that shows proof of concept of integrating a Microsoft Access database within a PowerPoint slide. What's more? the sample presentation that has been provided let's you use any Access database as the source for your presentation slides!

You can download the sample presentation and database files here (140 kb). You will need to have both Microsoft Access and PowerPoint installed on the same system for this to work also it works best if versions of both the products are identical, as in PowerPoint 2003 and Access 2003 or PowerPoint 2007 and Access 2007.

In this proof of concept example I have created an Access database called Inventory.mdb -- the database contains two tables Product and ProductFeatures , details as below:

  • Product table is a listing of products.
  • ProductFeatures is a listing of features for each product -- each product can have many features.
  • The Product and ProductFeatures are joined on the ID field in the Product table, and on the MasterID field in the ProductFeature table.

Follow these steps:

  • Unzip the ZIP file you downloaded. You'll find two files: a PowerPoint PPT file, and an Access MDB file.
  • Start PowerPoint, and open the “PPT from MS-Access.ppt” file within the unzipped archive. PowerPoint 2003 users may see a warning message window while opening the file. Click the Enable Macros option, and continue opening the file. Also set your security level to Medium using the Tools | Macros | Security option. PowerPoint 2007 users will see a warning within a bar below the Ribbon -- click the Options button, and select the Enable this content option in the resultant dialog box.
  • Play the presentation in slide show mode (or press F5).
  • In slide show mode, click the prominent button that says “Generate PPT from Access”.
  • We basically clicked on ID and MasterID , and clicked the Join button (refer to Figure 8 ).
  • Now click Finish button, and PowerPoint will generate a presentation from the Access database.

Feature List 01 (Layout with Tabs)

Feature List 01 (Layout with Tabs)

The Feature List Layout comprises three sample PowerPoint presentations: one each to create a visual list for 4 features, 5 features, and 6 features. These work great when you have too much information to fit within one slide. This solution lets you use multiple slides, but the visual result is still that of one single slide!

Buy and Download Feature List 01 (Layout with Tabs) for $4.99+ (671 kb)

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Home | PowerPoint | Photoshop | PowerPoint Templates | PowerPoint Tutorials | Blog | Notes | Ezine | Media Kit | Feedback | Site Map | About Us | Contact Us Link to Us | Privacy | Testimonials PowerPoint Backgrounds | Christian PowerPoint Backgrounds | Business PowerPoint Presentation Templates

Plagiarism will be detected by Copyscape

  • Site Search
  • ENGINEERING.com
  • Eng-Tips Forums
  • Tek-Tips Forums

Tek-Tips Information Technology Professional Forums

Join Tek-Tips ® Today!

Join your peers on the Internet's largest technical computer professional community. It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

  • Notification Of Responses To Questions
  • Favorite Forums One Click Access
  • Keyword Search Of All Posts, And More...

Register now while it's still free!

Already a member? Close this window and log in.

Join Us               Close

Access export to PowerPoint

How could one export information from an Access Inquiry into a PowerPoint presentation page, if at all possible? I have several tables, one for the title and number of tables with different types of related data. I would like to use an inquiry for various formats of out put to PowerPoint pages, perhaps using a report or some other method. Thanks in advance, Dave

User: spicehead-zfkwxkmo

Popular Topics in Data Management

Author previous_toolbox_user

This topic has been locked by an administrator and is no longer open for commenting.

To continue this discussion, please ask a new question .

Read these next...

Curated Snap! -- Lunar Lander, Hologram Marriage, ChromeOS Flex, Defeating Patent Trolls

Snap! -- Lunar Lander, Hologram Marriage, ChromeOS Flex, Defeating Patent Trolls

Your daily dose of tech news, in brief. Welcome to the Snap! Flashback: February 15, 1995: Computer hacker Kevin Mitnick is arrested (Read more HERE.) Security News: • New Qbot malware variant uses fake Adobe installer popup for evasio...

Curated Spark! Pro series - 15th February 2024

Spark! Pro series - 15th February 2024

Today in History: 1950 Disney’s “Cinderella” opens in theaters On February 15, 1950, Walt Disney’s animated feature Cinderella opens in theaters across the United States. The Chicago-born Disney began his career as an advertising cartoonist in Kan...

Curated Asus, Dell or Lenovo laptops and computers

Asus, Dell or Lenovo laptops and computers

For the last couple of decades I have been buying Fujitsu computers, laptops and servers here in the UK. I have found their reliability to be fantastic. Sadly, Fujitsu are abandoning the European market and after April you will not be able to buy Fujitsu ...

Curated Users cannot change password since July 2023

Users cannot change password since July 2023

Hello all,I just started a new job and am relatively new to IT in general. My current job has had an issue with their domain since July 2023.Essentially, all users have a permanent password only IT can change because if they try, they receive the message ...

Curated Snap! -- Cultured Beef-Rice, Sarcasm Detection, Digital Memory, Free ESXi Axed

Snap! -- Cultured Beef-Rice, Sarcasm Detection, Digital Memory, Free ESXi Axed

Your daily dose of tech news, in brief. Welcome to the Snap! Flashback: February 14, 1946: Unveiling of the ENIAC (Read more HERE.) Security News: • Romantic AI Chatbots Fail the Security and Privacy Test (Read more HERE.) • Ubuntu ...

PowerShow.com - The best place to view and share online presentations

  • Preferences

Free template

Access Tutorial 1 Creating a Database - PowerPoint PPT Presentation

creating a powerpoint presentation from access data

Access Tutorial 1 Creating a Database

Access tutorial 1 creating a database objectives define the terms field, record, table, relational database, primary key, and foreign key create a blank database ... – powerpoint ppt presentation.

  • Define the terms field, record, table, relational database, primary key, and foreign key
  • Create a blank database
  • Identify the components of the Microsoft Access window
  • Create and save a table in Datasheet view
  • Enter field names and records in a table datasheet
  • Open a table using the Navigation Pane
  • Open an Access database
  • Copy and paste records from another Access database
  • Navigate a table datasheet
  • Create and navigate a simple query
  • Create and navigate a simple form
  • Create, preview, navigate, and print a simple report
  • Learn how to manage a database by compacting, backing up, and restoring a database
  • Your first step in organizing data is to identify the individual fields
  • The specific value, or content, of a field is called the field value
  • Next, you group related fields together into tables
  • A collection of related tables is called a database, or a relational database
  • You connect the records in the separate tables through a common field
  • A primary key is a field, or a collection of fields, whose values uniquely identify each record in a table
  • When you include the primary key from one table as a field in a second table to form a relationship between the two tables, it is called a foreign key in the second table
  • A database management system (DBMS) is a software program that lets you create databases and then manipulate data in them
  • In a relational database management system, data is organized as a collection of tables
  • Click the Create tab on the Ribbon
  • In the Tables group, click the Table button
  • Accept the default ID primary key field with the AutoNumber data type, or rename the field and change its data type, if necessary
  • Double-click the Add New Field column heading, and then type the name for the field you are adding to the table
  • Press the Tab key or the Enter key
  • Add all the fields to your table by typing the field names in the column headings and pressing the Tab key or the Enter key to move to the next column
  • In the first row below the field names, enter the value for each field in the first record, pressing the Tab key or the Enter key to move from field to field
  • After entering the value for the last field in the first record, press the Tab key or the Enter key to move to the next row, and then enter the values for the next record. Continue this process until you have entered all the records for the table
  • Click the Save button on the Quick Access Toolbar, enter a name for the table, and then click the OK button
  • Click the Save button on the Quick Access Toolbar. The Save As dialog box opens
  • In the Table Name text box, type the name for the table
  • Click the OK button
  • Start Access and display the Getting Started with Microsoft Office Access page
  • Click the More option to display the Open dialog box
  • Navigate to the database file you want to open, and then click the file
  • Click the Open button
  • The navigation buttons provide another way to move vertically through the records
  • A query is a question you ask about the data stored in a database
  • The Simple Query Wizard allows you to select records and fields quickly
  • A form is an object you use to enter, edit, and view records in a database
  • You can design your own forms, use the Form Wizard, or use the Form tool to create a simple form with one mouse click
  • A report is a formatted printout (or screen display) of the contents of one or more tables in a database
  • The Report tool places all the fields from a selected table (or query) on a report, making it the quickest way to create a report
  • Open the report in any view, or select the report in the Navigation Pane
  • To print the report with the default print settings, click the Office Button, point to Print, and then click Quick Print
  • To display the Print dialog box and select the options you want for printing the report, click the Office Button, point to Print, and then click Print (or, if the report is displayed in Print Preview, click the Print button in the Print group on the Print Preview tab)
  • Compacting a database rearranges the data and objects in a database to decrease its file size
  • Make sure the database file you want to compact and repair is open
  • Click the Office Button, point to Manage, and then click Compact and Repair Database
  • Backing up a database is the process of making a copy of the database file to protect your database against loss or damage
  • The Back Up Database command enables you to back up your database file from within the Access program, while you are working on your database
  • To restore a backup database file, you simply copy the backup from the drive on which it is stored to your hard drive

PowerShow.com is a leading presentation sharing website. It has millions of presentations already uploaded and available with 1,000s more being uploaded by its users every day. Whatever your area of interest, here you’ll be able to find and view presentations you’ll love and possibly download. And, best of all, it is completely free and easy to use.

You might even have a presentation you’d like to share with others. If so, just upload it to PowerShow.com. We’ll convert it to an HTML5 slideshow that includes all the media types you’ve already added: audio, video, music, pictures, animations and transition effects. Then you can share it with your target audience as well as PowerShow.com’s millions of monthly visitors. And, again, it’s all free.

About the Developers

PowerShow.com is brought to you by  CrystalGraphics , the award-winning developer and market-leading publisher of rich-media enhancement products for presentations. Our product offerings include millions of PowerPoint templates, diagrams, animated 3D characters and more.

World's Best PowerPoint Templates PowerPoint PPT Presentation

A collage of colorful PowerPoint designs organized into tidy rows

5 golden rules of PowerPoint design

february 6, 2024

A smiling woman with blonde hair, glasses, and a leopard print cardigan poses with her hands on her hips in front of an olive green background.

by Deb Ashby

Wondering how to design the perfect PowerPoint presentation? It's easier than you think–just follow five simple rules to get started:

1. Consider using templates

When building a slide deck, it’s important to maintain consistency throughout. We want to ensure we are using consistent font styles, colors and themes. This can be tricky when designing from scratch, so why not start from a template?

Microsoft Create contains hundreds of pre-made, customizable PowerPoint templates, which means you don’t have to start from scratch and the fonts and colors are already set for you.

Simply choose a template from the gallery, customize it as needed, and you are done!

Screenshots of slides in a branded PowerPoint presentation, in hues of navy, maroon, and brown.

2. No walls of text

We’ve all seen PowerPoint presentations where slides contain too much text. The human brain struggles to listen and read at the same time. If you are presenting to an audience, keep the text on slides to a minimum.

Consider employing the “5-5-5" rule. No more than 5 lines, no more than 5 words, no more than 5 minutes. Think short and sharp memory joggers instead of rambling paragraphs.

Where possible, consider replacing text with visuals to represent your point. People remember images more than words.

A minimalist, black and white PowerPoint template

3. Be mindful of colors and fonts

No one wants their audience to leave with a headache after an hour of straining to read slides. We need to ensure that our presentation is easy to read for everyone – even for those in the nosebleed seats at the back! Think about the font you are using. Is it appropriate for the presentation? What about the font size? Can people at the back easily read? What about people with visual impairment? Ensure all text is at least 24pts.

When it comes to color, ensure all slides have good contrast. Dark backgrounds should have light font and vice versa.

4. Use animation sparingly

Animation can really liven up an otherwise flat presentation. However, it should be used thoughtfully and sparingly. Too much of the wrong type of animation with objects flying in and zooming around the screen, while fun, can look confusing and unprofessional.

Animation should be subtle. With every animation you add, ask yourself, "Is this going to enhance my presentation or distract from it?"

5. Engage your audience

When presenting to an audience, there is usually an awkward time before the presentation begins while the speaker waits for everyone to arrive. During this time, people may start scrolling on their phones or get distracted with work emails, and it can be hard to pull the audience back.

To avoid this issue, work to grab your audience's attention before the presentation even starts. Instead of just having the title slide on the screen, consider creating "kiosk slides." These are a series of slides that contain a combination of interesting things for the audience to look at or engage with. Maybe you have an interesting image? A funny quote or fun facts? Or maybe there is a question you want them to think about prior to the session?

Create these slides and have them automatically cycle round before the presentation starts.

A PowerPoint presentation for a whitepaper proposal.

Related topics

  • Manage your subscription
  • Manage payment method
  • Renew your subscription

Turn recurring billing on or off

  • When subscription expires
  • Cancel Microsoft 365
  • Share Microsoft 365 Family
  • Stop sharing Microsoft 365 Family
  • You received an invitation to share
  • Switch between Microsoft 365 subscriptions
  • Switch to a business subscription
  • Transfer to a different Microsoft account
  • About accounts
  • Sign in to Microsoft 365
  • Why you need to sign in
  • Forgot account or password
  • Get started at Microsoft 365.com
  • Meet the Microsoft 365 app launcher
  • Check version
  • Microsoft 365 for home or business
  • What business product do I have?
  • Difference between Microsoft 365 and Office 2021
  • Difference between home and business plans
  • Difference between Microsoft 365 and free web apps
  • Can't install or manage Office or Microsoft 365
  • Parental permission when signing in to Office or Microsoft 365

creating a powerpoint presentation from access data

Manage your Microsoft 365 subscription or Office product

For most Microsoft 365 subscriptions and versions of Office (2013 and later), you need to associate an account with your product. This is the account you use to sign in to Microsoft365.com and what you use to install or reinstall the apps, or to manage your subscription. Depending on your product, this account can be a personal Microsoft account (such as Hotmail.com, Outlook.com, Live.com), or a work or school account assigned by someone in your organization.

Note:  Some products purchased through an employee  Microsoft Workplace Discount Program  (formerly known as Home Use Program) benefit or volume license versions (managed by an organization's IT department) might not require an account. The information below doesn't apply to these Office versions or Microsoft 365 subscriptions.

Sign in to the dashboard for your account

Open a desktop app like Word or Excel, or go to Microsoft365.com .

Tip:  You might be prompted to sign in. Make sure to sign in with the account associated with Microsoft 365 or Office. If you can’t remember which email address you associated with your subscription or Office product, see I can't remember the Microsoft account I use with Microsoft 365 .

From the header, select your Account manager .

Depending on your account type, select  My Microsoft account or  View  account .

Your account dashboard is displayed and what you can do next depends on if you're signed in with a Microsoft account , or a work or school account .

Select the tab below for the type of account you're signed in with.

If you selected My Microsoft account , the Microsoft account dashboard will open. This is where you manage your Microsoft account and any Microsoft products associated with this account.

On the Microsoft account dashboard, select  Services & subscriptions to view all Microsoft products associated with this account. 

For non-subscription versions of Office (such as Office 2013 and later): Find your Office product and select Install . Follow the prompts to install or reinstall the desktop apps.

For Microsoft 365 Family or Personal subscriptions: Select Install premium Microsoft 365 apps and follow the prompts to install or reinstall the desktop apps.

On the Microsoft 365 subscription tab, select Manage . From here you can:

Renew your subscription with a prepaid code or card

Cancel a subscription

For Microsoft 365 Family subscriptions, you can start sharing your subscription, and add or remove people you're already sharing with. If you're not the subscription owner, you can see who's sharing Microsoft 365 with you, or choose to leave the subscription.

If you selected View account , the  My Account dashboard for your work or school account will open. Here you can:

Install and manage your apps. On the Office apps card, select Manage , and select Install to install or reinstall the latest desktop apps, or other apps such as Project or Visio. (An install option is available as long as your admin assigned you a license and gave you permission to self-install.)

Manage your devices.

View your subscriptions, and any other licenses assigned to you.

Note:  For Microsoft 365 admins only     If you're the Microsoft 365 admin in your organization, you control what you want your users to have access to. Go to the Microsoft 365 Admin help center for more information about setting up users.

Facebook

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

creating a powerpoint presentation from access data

Microsoft 365 subscription benefits

creating a powerpoint presentation from access data

Microsoft 365 training

creating a powerpoint presentation from access data

Microsoft security

creating a powerpoint presentation from access data

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

creating a powerpoint presentation from access data

Ask the Microsoft Community

creating a powerpoint presentation from access data

Microsoft Tech Community

creating a powerpoint presentation from access data

Windows Insiders

Microsoft 365 Insiders

Find solutions to common problems or get help from a support agent.

creating a powerpoint presentation from access data

Online support

Was this information helpful?

Thank you for your feedback.

IMAGES

  1. How to link PowerPoint to a Microsoft Access database?

    creating a powerpoint presentation from access data

  2. creating a powerpoint presentation from access data

    creating a powerpoint presentation from access data

  3. creating a powerpoint presentation from access data

    creating a powerpoint presentation from access data

  4. How to link PowerPoint to a Microsoft Access database?

    creating a powerpoint presentation from access data

  5. Global Data Access Management Ppt Powerpoint Presentation Template Cpb

    creating a powerpoint presentation from access data

  6. Creating a New Presentation

    creating a powerpoint presentation from access data

VIDEO

  1. How to quickly access any function in Powerpoint

  2. Another one! #powerpoint #microsoft365

  3. Creating PowerPoint Presentation Rapidly with AI Tools

  4. Creating powerpoint presentation containing components of computer

  5. 01. Navigating PowerPoint

  6. Lesson 1: Introduction to PowerPoint Presentation

COMMENTS

  1. Recipe 12.7 Create a PowerPoint Presentation from Access Data

    Use frmPowerPoint to create PowerPoint presentations from within Access To use this technique to create your own presentations, follow these steps: Import from 12-07.MDB the tblParagraphs, tblSlides, tlkpLayouts, and tlkpOptions tables.

  2. How to link PowerPoint to a Microsoft Access database?

    First install PowerPoint and DataPoint on the machine and start PowerPoint. Set up a new presentation based on an empty template or the default company template. Connect to First we will set up a data connection to the Microsoft Access database. Click DataPoint in the PowerPoint menu. Then click the List button of the Connections group.

  3. Create a PowerPoint Presentation from Access Data

    Problem You need to create similar Microsoft PowerPoint presentations over and over. You currently take an existing presentation, copy it to a new location, and modify it as necessary, resulting in a number of copies of the same text littering your hard disk.

  4. Creating PPT presentation automatically from Access

    This is the sub which I'm calling to open ppt file: Code: Sub PPT_OPEN () ' Create powerpoint page Dim pptPres As PowerPoint.Presentation Dim pptApp As PowerPoint.Application Dim pptSlide As PowerPoint.Slide Dim file As String file = "C:\access\test_v1.ppt" Set pptApp = CreateObject ("PowerPoint.Application") pptApp.Visible = True Set pptPres ...

  5. Populate Powerpoint out of Access database

    Populate Powerpoint out of Access database. Hello, I want to create a Powerpoint presentation with data out of an Access database. Filling Textboxes in the PPT is no problem. But in my Access table I also have a "OLE-object" field containing a picture. Can anybody tell me how I can transfer this OLE-object field into the PPT? Thank you in advance.

  6. How to link PowerPoint to a Microsoft Access database

    0:00 / 6:07 How to link PowerPoint to a Microsoft Access database Webucator 7.29K subscribers Subscribe Subscribed Share 23K views 8 years ago Microsoft Office Solutions In this video, we show...

  7. Populating Powerpoint slides from Access VBA

    Private Sub OpenPPT_Click () Dim pptPres As PowerPoint.Presentation Dim pptApp As PowerPoint.Application Dim currentSlide As Slide Set pptApp = CreateObject ("Powerpoint.Application") Set pptPres = pptApp.Presentations.Open ("C:\Users\Magda\Desktop\TestReport.pptx") Set currentSlide = pptPres.Slides (pptPres.Slides.Count) 'Slide 1 currentSli...

  8. Create PowerPoint charts from MS Access queries

    3 I have an Access db to track metrics and "number crunch" data to build PowerPoint presentations. I do about 40 presentations per month, and they are 98% charts.

  9. MS Access and PowerPoint

    The first example will show you how to create a PowerPoint presentation from the data inside a MS Access table using Automation. The second approach shows how to display and manipulate an existing PowerPoint presentation inside of a MS Access form, also using Automation.

  10. Connect PowerPoint to Microsoft Access database for real time ...

    In this video I will show you how you can connect a Microsoft PowerPoint presentation to a Microsoft access database to display real time information on your...

  11. Adding Data From Access To Powerpoint

    Hi Guy's, i have done some searching and adapting what i can find so far, i am trying add data from Access to Powerpoint, has anyone achieved this or know a solution I am receiving a Msg object doesn't support this method on this line: pptPres.Slides(i) = rs.Fields("Name") & " - " & rs.Fields("Town") & vbCrLf Dim rs As DAO.Recordset Dim pptApp As New PowerPoint.Application Dim pptPres As ...

  12. How to Link PowerPoint to a Microsoft Access Database

    Step 1: Go to the DataPoint Tab in the PowerPoint Menu. First, install PowerPoint and DataPoint on your computer, launch PowerPoint, and create a new presentation using your default company template or an empty template. After that, go to the PowerPoint menu and select the DataPoint tab. Select the List option in the Connections group.

  13. Access in PowerPoint

    Now click Finish button, and PowerPoint will generate a presentation from the Access database. Feature List 01 (Layout with Tabs) The Feature List Layout comprises three sample PowerPoint presentations: one each to create a visual list for 4 features, 5 features, and 6 features.

  14. Creating a Powerpoint with Graphs from Access

    Ideally, when the graphs move over to PowerPoint they will become static pictures and not graphs still linked to the access data. Private Sub Command1_click () Dim pwrpnt as Object Dim Presentation as Object set pwrpnt = CreateObject ("Powerpoint.Application") pwrpnt.Activate Set Presentation = pwrpnt.Presentation.Open ("C:\test.ppt") Me.Graph1 ...

  15. Access data to Powerpoint Slides

    Access data to Powerpoint Slides thread705-1792348 Forum Search FAQs Links MVPs air1access (TechnicalUser) (OP) 25 Jan 19 12:28 I have lots of powerpoint slides I need to create every month. The slides are the same for every one. So I have a template basically that never changes.

  16. Access export to PowerPoint

    You can create a main report, and place. > sub-reports on. > it for each of the "different types of related data." > Once you have the report, use the Export function in Access to store the. > contents of the report in .RTF or .HTML format. You should then be able. > to. > Import that file into PowerPoint.

  17. Make your PowerPoint presentations accessible to people with

    Create accessible slides The following procedures describe how to make the slides in your PowerPoint presentations accessible. For more info, go to Video: Create slides with an accessible reading order and Video: Design slides for people with dyslexia. Use an accessible presentation template

  18. create a powerpoint chart from Access data

    1 Sign in to vote 99.9% of the time people use Excel automation to make the charts in PowerPoint. Google and you'll find many examples. That said, here is a quick example of automating ppt to insert a new chart and create series (you could easily pull data from with Access)

  19. MS ACCESS PPT.pptx

    Using Access, we can do the following : • Add new data to a database, such as a new item in an inventory • Edit existing data in the database, such as changing the current location of an...

  20. How to use Microsoft Copilot in your day-to-day work

    Here are some ideas for how to use Copilot in PowerPoint: Create a new presentation from scratch. Create a presentation based on a file. Add a new slide to a presentation. Redesign slides to use a new theme or style. Let's give that first bullet point a try with this prompt: "Create a presentation about Q1 sales for AdventureWorks.

  21. Linking Powerpoint and Access through VBA?

    1 Answer. It's certainly possible to get Access data from Powerpoint. You need to make sure you have the correct references set to the Microsoft DAO Object Library in your VBA project. Then, to populate your textbox in your PowerPoint presentation, you can call something like the following function, say, to return a string containing a list of ...

  22. PPT

    Creating an Append Query in Microsoft Access - This article talks about the importance of the Append Query and the appropriate way of creating them in Microsoft Access. In Microsoft Access and all the other database management systems, queries as the heart of the software system which can execute numerous actions to make your database more systematised and functional.

  23. The 5 golden rules of PowerPoint design

    Wondering how to design the perfect PowerPoint presentation? Follow these five simple golden rules from one of our creative experts. ... Instead of just having the title slide on the screen, consider creating "kiosk slides." These are a series of slides that contain a combination of interesting things for the audience to look at or engage with ...

  24. Example prompts to try with Microsoft Copilot with Graph-grounded chat

    Create content. Brainstorm ideas and draft new content based on information at work. Here are some examples: You want to draft a one-page description of a new project (let's call it Project Foo) that's just about to kick off at work. Using information in file1, file2, and file3, write a one-page description of Project Foo.

  25. Manage your Microsoft 365 subscription or Office product

    If you selected My Microsoft account, the Microsoft account dashboard will open.This is where you manage your Microsoft account and any Microsoft products associated with this account. On the Microsoft account dashboard, select Services & subscriptions to view all Microsoft products associated with this account. For non-subscription versions of Office (such as Office 2013 and later):