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.