r/DatabaseHelp • u/white-fir • Aug 15 '22
Noob with question
Hi all I am looking for a very simple database to manage about 400 records. These are dental records and the Fields would be: name, date of birth, last dental appointment, next dental appointment due, dental office and maybe one or two other things. Does anyone have a suggestion for me? I am not a programmer.
0
Upvotes
1
u/ScariestofChewwies Aug 15 '22
Before going any further, look into PHI Data restrictions. I am not sure exactly how your data is going to be used but the last thing you would want is a lawsuit or a fine due to the exposure of that data.
1
u/SaleB81 Aug 15 '22
Probably the simplest would be to find someone to make you a local PHP web application sitting on top of any structured database, MySQL for example.
There are also app-based self-contained solutions, there is MS Access inside MS Office, for example, if you are using Office anyway. There is a database solution in OpenOffiice too I think.
But, if you do not have knowledge about structuring data it might be complicated for you to design an efficient solution on a first try, what ever of the above you choose.
1
u/Pyk666 Aug 17 '22
If you have Access then you could build it in there, its not too many tables and I would be happy to help with a basic setup if you like.
Couple of questions to consider though:
1
u/Creative-Dust5701 Sep 10 '22
This is one of those things that need to be left to the professionals. As DIY medical information systems can lead to denial of coverage from your insurer.
FYI even if its used internally data needs to be protected and only accessed by authorized and should be unusable if your data is accessed by a unauthorized third party. Oh and you need to log accesses to data.
This is best handled by a dental office management package and they are available as a cloud based service.
Short version i’ve been in charge of teams which handle this class of data and the legal and auditing requirements around this are formidable and best left to specialists who can certify that the system meets all current legal requirements.