Hello,

I have a question about integrating Power Point with Access. What I am trying to accomplish is that we are a small manufacturing shop. We have our own access database we use to track jobs through the various departments. Right now each foreman just runs a report (which prints out) showing what jobs need to be moved through his department for the week. The problem is, that customers always change their needs, so the report ends up having to be reprinted sometimes several times a day! We currently have (5) departments. This solution has worked well, but the owner has tasked me with the feasibility of creating a "kiosk" type display. What we are envisioning is a power point presentation that would consist of (5) slides (hence the 5 departments) that would run in kiosk mode, and constantly rotate between them, with a small pause between slides. Security of the displays is not a concern, as I have seen mentioned time and time again as I googled this. Here is where I get lost:

1) How do I get Power Point to pull the data from Access (hopefully the existing report)

2) How do I get Power Point to "Re-Pull" the data each time the report cycles through the slides? (Either each slide, or after all 5, or at some set interval of a minute or something to that effect)

The intended endpoint would be to have a real time update as customer's needs change. Thank you in advance, and I would really appreciate any and all feedback!

Rob