[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 514
  • Last Modified:

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.
0
inspironcrk
Asked:
inspironcrk
  • 4
  • 3
  • 2
  • +1
2 Solutions
 
Echo_SCommented:
I guess I'm not sure what exactly you need help with.

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?
0
 
inspironcrkAuthor Commented:
@ 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.
0
 
Simon BallCommented:
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.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Echo_SCommented:
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.
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
If I may interject a different thought: you don't really need PowerPoint to do what you are asking about (sorry, Echo!) You can build the data connections directly from Visio to either or both data sources, especially because you've already drawn the hospital ward in Visio. And you can have the data in the diagram refresh either on a mouse click or automatically with a timer. Finally, using Visio Services (requires Visio 2010 and SharePoint 2010), you can create a web-based rendering that anyone can view with a web browser and that automatically updates when the data changes.

There's an overview of Visio Services here:
   http://blogs.msdn.com/b/visio/archive/2009/10/30/introducing-visio-services.aspx
and a decent video demonstration that shows what's possible here:
   http://visio.microsoft.com/en-us/Get_Started/How_To/Pages/How-to-use-Visio-2010-for-Network-Troubleshooting.aspx
Even though this video is about network diagrams, I'm sure you can see how the same ideas are relevant to monitoring patient status.

If you want to see a much more sophisticated example of integration:
   http://visio.microsoft.com/en-us/FeaturesAndCapabilities/Connect/Pages/Visio-Services-Working-With-Other-Microsoft-BI-Technologies.aspx
Don't be put off because there are multiple web-parts and other bits in this demo. Building the connection from Visio to data is very easy. Publishing to Visio Services on SharePoint 2010 is equally easy. However, this demo shows where you can go if you want to.

0
 
Echo_SCommented:
ahhh, even better, Scott! didn't realize Visio Services existed. That's very cool.
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
It is very cool... if you need more help implementing these ideas, just post questions in the Visio zone.
0
 
inspironcrkAuthor Commented:
@ 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
0
 
Echo_SCommented:
0
 
Simon BallCommented:
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!
0
 
inspironcrkAuthor Commented:
@ sudonim: i will try everythong tomorrow since I have an all day hospital shift today, and i will get back to you. Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now