In this article I will show you 3 different ways to display information of a database in your PowerPoint presentation by using the DataPoint add-on. These 3 methods are very close to each other but they all have their own characteristics and (dis)advantages.
With DataPoint installed, first the user should have to identify the database that the user wants to connect to and use in the presentation. Common used databases are Microsoft Access, Microsoft SQL Server, Oracle, MySQL and more generic connections like ODBC and OLEDB connections. In this article we will use the sample Microsoft Access database northwind.mdb. First click DataPoint in the PowerPoint menu.
First method: linking a table directly
Make sure that the added connection is selected and click Add query.
Second method: use a database query
As a database administrator, the user can create queries in the Access database. In the northwind.mdb sample database, there are a few queries already defined. A query is filtering and sorting information of a base table. For example it is filtering out the unpaid invoices. Or it is joining information of two or more data tables when the user needs to display or filter out information of more than one table.
Third method: use custom sql statement
Most flexible is this last option to bind data to the presentation. Again click Add query on the connections list and click the Custom SQL option on the form.
Now the user will know 3 ways to get information of a database in the presentation. The user can now add text boxes and tables and start linking this dynamic database information to the presentation.
Note that with data driven presentations the user will always have the latest information in the presentation, in real-time and without any typing mistakes.
Run this slide show and DataPoint will continuously scan the database for updates and update the default PowerPoint shapes accordingly.
Download DataPoint from the PresentationPoint web site. The NorthWind database is a sample Microsoft Access database provided by Microsoft. The user can download a copy of it.