At my work our surgeons digitally record a lot of their surgeries. One of the doctors would like to have a system where he has all of his patients in a database and be able to sort with specific categories. Categories such as:
- Right Leg
- Left Leg
- ACL Reconstruction
- Meniscus repair
Then the database should report which patients meet that search criteria. In theory that should also help him find the videos that he is looking for. The videos that are associated with that patient or procedure. Probably where the videos are stored and so forth.
I would think that Microsoft Access should be able to do this. What do you think?
If he wanted the database to actually store the videos (associated with the patient) as well, that may be more tricky. What will be involved with storing the videos inside the database?