Hi. I wished to asked whether I should use Excel or Access (or perhaps another program) for the following task:


I am a doctro working at an emergency room, and I need to generate a sheet to summarize several items, such as physicians who were on the last shift, number of patients, diagnosis (using the ICD 10 classification which is on an excel sheet), events during the shift, etc.
The data sheet must be self contained so that each day it gets updated by input from the designated physician, without erasing the previos data so as to keep records of each shift without having to save multiple files.
Which app better suits my requirements? And if possible, could you guys help me build this database or at least point me on the right direction?
Cheers,
Claudio

Hi,
I cannot give you a complete answer to your question. Nevertheless, as the data that you will work with is highly sensitive, I would strongly advise against using Excel, which does a great job as a spreadsheet but a very lousy one when security is involved.

There are lots of database programs out there but I suppose you could find one somewhere that is tailored to your kind of needs and can offer strong protection.
If money is a problem search for open software mostly based on Linux.

Don't worry, Linux is not difficult at all ,is virus free ( and free ) and has many advantages over Windows.

Perhaps some more savvy member can help you better than I can.

Good luck with your endeavour

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post