Pkafkas
asked on
What kind of Database program to use to sort out information
Hello:
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:
- Year
- Right Leg
- Left Leg
- ACL Reconstruction
- Meniscus repair
- etc.
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?
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:
- Year
- Right Leg
- Left Leg
- ACL Reconstruction
- Meniscus repair
- etc.
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Jeff Darling
I would also recommend SQL Server. If you do decide to use Microsoft Access, make frequent backups because Access tends to become corrupt and will need to be restored from backup.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello,
I do not think the doctor will want to take the time to learn SQL Scripting, this is for his personal collection; hence, it is not an official work function. Perhaps using SQL Server is not such a great idea.
Perhaps MS Access and a field to state where everything is located. i will look into what Filemaker has to offer as well.
I do not think the doctor will want to take the time to learn SQL Scripting, this is for his personal collection; hence, it is not an official work function. Perhaps using SQL Server is not such a great idea.
Perhaps MS Access and a field to state where everything is located. i will look into what Filemaker has to offer as well.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think Access is a better solution than FileMaker, especially if you already have experience with Access (or VBA of any flavor).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.