First we will set up a data connection to the Microsoft Access database. Click DataPoint in the PowerPoint menu.
Click the Browse button, navigate to the Microsoft Access database that the user wants to use. In this example, we will connect to the Northwind demo database of Microsoft Access.
Add table or query
Now with this data connection selected, click Add query. The user will get a list of all the tables and queries that are created in the database. For this example select the Orders table.
Data refresh options
Set the Data refresh rate to Continuous updating and change the interval to a desired value. The default here is 5 seconds. So DataPoint will go back to the database and check for new data. When no updates are detected, DataPoint will not update the data on the slides but whenever new data is detected DataPoint will update the text boxes and tables at once with the new content. Now click OK to add the query to the connection.
In the connections overview the user will now see a preview of the data that is available now for the presentation. Click OK to close.
Text box linking
Add a new text box on the slide and click DataPoint and then Text box in the Shapes group. This will bring up the properties of a dynamic text box.
Microsoft Access slide show
Start the slide show and DataPoint will check for data updates and update the slide content continuously. The user can have the information screen or message board running and display the slide show now in full screen. Someone can open the database on another computer, add or modify data, and commit the changes back to the database. The information screen will be updated automatically within the refresh rate interval.