A client has a small rehab clinic. They do everything using paperwork .
There about 5-6 doctors. So it is a multi-user app. They need to keep some forms, medical records etc about each patient. There are some security/privacy requirements.Doctors should not be able to see each other stuff.Like physio seeing psychiatrist notes for a patient. Forms are somewhat big and would require dozen of columns in a relational database. Those who certify the clinic with ISO stated that certified software must be used. However asking what certified software is they responded MS Access. I don't get how MS Access out of the box is certified for storing medical records without developing some forms, vba code etc.
So is MS Access more suitable than a simple web based local app using a database for storage ? I dont have much experience with MS Access and if I go this road then I wont be able to keep up with the deadline as I have zero time to learn access (having other projects running)