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