Designing a patient management
Not an answer to your question, but if you are in the US, keep in mind the
HIPAA privacy and security requirements, Pat. an Access
database cannot be completely secured, so you have to consider whether it
will satisfy HIPAA regulations.
See:
http://www.microsoft.com/office/comm...8-bec2bf26d20c
--
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
"Simba" wrote:
Being a newbie to access, I have been given a task of creating a db for the
patient management and tracking. This DB will have around 50 patients per
year. It will contain the history of patient's contact info, pediatrician,
case manager,Genetic center info, Insurance info and so on. I have created
the tables. pls review them and suggest me your ideas to improve the DB, as
mine maynot be best.
tblPatients
RegID - PK
PatientID,FirstName,LastName,DOB,Gender,Hospital,M A,CaseStatus,Diagnosis,Address,City,Zip,county,MFi rstName(mom),MLastName,MAddress,MCity,MState,MZip, MHomePhone,MCellPhone,MWorkPhone,FFirstName(Father ),FLastName,FAddress,FCity,FState,FZip,FHomePhone, FcellPhone,CurrentPed,FormerPed,GenCenter,Genetici st,CaseManager,CaseManagement
tblPediatrician_1 and also tblPediatrician_2
PedID-PK,LastName,FirstName,MI, Practicie,Address,City,State,Zip,Phone,Fax
tblGenCenter
center_Id-PK,Name,Address,City,state,zip,phone,Fax
tblGencounselor
CounselorID-PK,FName,LName,Phone,Pager,Fax
tblCaseMgr
MgrID-Pk,FName,LName,Phone,Pager,Fax
tblCaseMgmt
MgmtId-Pk,Name, address,........
tblInsurance
InsuranceID-Pk,Type,AgencyName,ContactFName,ContactLName,phone ,fax,insuranceName,policyno,CS_Phone
tblInsuranceType
InsuranceType-ID-Pk,RegID,InsuranceID
tblGuardian
guardianId-pk,Refdate,type,fName,LName,address,state,city,zip ,hPhone,Cphone,wphone
tblpatientguardian
patguardianID-Pk
Regid
GuardianID
|