inspironcrk
asked on
Powepoint 2010 data connection to Access and Excel
Hello.
I am trying to make an easy way to follow our patients in our department. I have made some drawings of our ward on Visio and inserted it into a Powerpoint Presentation.
We have an MS Access file which is updated daily containg the demografic and clinical data of our patients. The Access file is connected to an Excel file from where we can get other interesting data, such as the thermometric measurements of the patient and get the thermometric diagram in Excel.
In the Powerpoint we want to set an area where clicking on it, will give as a pop up window with data derived from the Access or Excel files (such as Patient Name, Room Number, Current disease, Basic blood results, thermometric and blood pressure diagrams).
How can this be possible?
Any answer is welcome.
I am trying to make an easy way to follow our patients in our department. I have made some drawings of our ward on Visio and inserted it into a Powerpoint Presentation.
We have an MS Access file which is updated daily containg the demografic and clinical data of our patients. The Access file is connected to an Excel file from where we can get other interesting data, such as the thermometric measurements of the patient and get the thermometric diagram in Excel.
In the Powerpoint we want to set an area where clicking on it, will give as a pop up window with data derived from the Access or Excel files (such as Patient Name, Room Number, Current disease, Basic blood results, thermometric and blood pressure diagrams).
How can this be possible?
Any answer is welcome.
ASKER
@ Echo_S
I would really love to hear some more about how I can use a trigger animation & the OLE Action Verb you are talking about.
As for the rest, I don't want real time updates of the Excel data, but I want powerpoint to show data from an external database (Access) by clicking on a certain area of the animation. That is a REPORT or a QUERY or a TABLE from the Access db.
If I am not clear enough, please inform me and I will post an example.
Many thanks.
I would really love to hear some more about how I can use a trigger animation & the OLE Action Verb you are talking about.
As for the rest, I don't want real time updates of the Excel data, but I want powerpoint to show data from an external database (Access) by clicking on a certain area of the animation. That is a REPORT or a QUERY or a TABLE from the Access db.
If I am not clear enough, please inform me and I will post an example.
Many thanks.
i have done something similar to this in access, although its not finished.
I had a board game as a kid which was cool, and my mum gave it away... and i wanted to play it with my kids, but it was selling for £100's on ebay, so i found the game map and images on baordgamegeek, and wrote an access DB version of the game.
We could import you visio image into Access on a form, and place empty image controls over each "bed" which have no image, are invisible, but each has an on click event, which calls a function, passing that function its own "bed code"..
the function would then open the relevant form to show the patients data for that bed code.
I had a board game as a kid which was cool, and my mum gave it away... and i wanted to play it with my kids, but it was selling for £100's on ebay, so i found the game map and images on baordgamegeek, and wrote an access DB version of the game.
We could import you visio image into Access on a form, and place empty image controls over each "bed" which have no image, are invisible, but each has an on click event, which calls a function, passing that function its own "bed code"..
the function would then open the relevant form to show the patients data for that bed code.
Yeah, there are two parts to this -- one is getting the data into PPT, the other is displaying it as you're asking. I think Sudonim might be closer to what you want.
My animation suggestion/question is only to display the data as a popup (of sorts) during a presentation -- it doesn't have anything to do with pulling the data into PPT.
You could get the data from either Excel or Access, though, right? You just don't need real-time updates of it is what I'm understanding.
My animation suggestion/question is only to display the data as a popup (of sorts) during a presentation -- it doesn't have anything to do with pulling the data into PPT.
You could get the data from either Excel or Access, though, right? You just don't need real-time updates of it is what I'm understanding.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ahhh, even better, Scott! didn't realize Visio Services existed. That's very cool.
It is very cool... if you need more help implementing these ideas, just post questions in the Visio zone.
ASKER
@ scott :very inreresting idea . I will give it a try and i will get back asap.
@ Echo_s : mo, i don't want real time updates. Just to pull the data.
I will give a try with scott's guide
@ Echo_s : mo, i don't want real time updates. Just to pull the data.
I will give a try with scott's guide
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
nice one.
Let me know if you want help with this in access. I can put up some code samples, but you should try those cool visio techs first!
Let me know if you want help with this in access. I can put up some code samples, but you should try those cool visio techs first!
ASKER
@ sudonim: i will try everythong tomorrow since I have an all day hospital shift today, and i will get back to you. Thanks
If you just need to click an object and have an Excel sheet open, that's easy enough to do in slide show view using a trigger animation on the area to click and an OLE Action Verb animation on the spreadsheet. Let me know if you need specifics.
Or are you just saying that one area of the slide should show the linked Excel spreadsheet and update it at intervals or something?