I have created a very basic Access 2010 DB to track my personal medical records. It seems to work but my skills are limited and I am not sure my tables and relationships are optimal. Nor do I have the skills to create easy user interfaces for data entry and reporting.
The tables I have created are:
--"Conditions" That is, medical conditions for which I have contacted my medical suppliers. Could be from a head cold to cancer.
--"Date of Contact" I have a number of fields. I want to show not only the date of contact but method such as personal visit, email, telephone, etc.
--"Drugs" A list of drugs I have used, when prescribed, for what condition, etc.
--"Names of Medical Personnel" The names, titles, locations, etc of anyone in the medical community with whom I make contact.
I want a nice input form(s) created so I can be led through the entry process rather than entering directly into the tables and so that someone else could do it if I was not able.
I currently download from my medical supplier's online records any email communications to a PDF and attach it to the contact date in my database. That may or may not be the best way to do that but I want to be able to put in a "Contact" record any emails I have.
These tables may not be the best way to accomplish what I want so I am looking for some creativity. I want the data related in such a way that I can easily go to a form and click on a drug and it will show me when it was prescribed, when I had refills, which medical person prescribed it and what condition(s) it was prescribed for.
I want to to the same for Medical Personnel. I want to click on a name and see all contacts with that person, for what conditions and drugs related.
I want the same for Dates of contacts. I want to be able to click on a date of contact and it would show me the name of the person I contacted, the method (in person, email, phone, etc) the medical condition for which I made the contact and any drugs related to this contact.
I could provide the very basic Access DB I have created either to work from or merely to give an idea of what I am after.
27 freelancers are bidding on average $168 for this job
Hello i am expert in MS ACCESS and i can help you. i have done similar project. can you give me your sample DB and more details of forms and reprots do you want ? regards
Hi I have more than 10 years experience in Ms Access Database design and development. I have read all of your requirement very care fully. I can do it perfectly. Please see my profile. Thanks.
Hi I can develop this database for you. Please let me know if you are interested in hiring me. I am a seasoned professional with 13 years of experience. Regards, jawad aman, PMP
Let's have a look at the database which you have created and go on from there. Time cost shall be calculated on per hour basis until completion.. let's say $10 per hour...this could be a very interesting job.
Hi my Dear, i am a statistician engineer working as a data manager and data analyst there is 4 years. What you want it's what i master a lot. I am ready to start it for you.