Russ,
My sample db named MedicalDiagnosis might be of interest to you. It is in access 2000 file format and is available at Rogers Access Library. Link:
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45
This db demonstrates an interesting presentation of many to many relationship between symptoms & diseases. Some of the features covered are outlined below.
Diagnosis
As the user selects various symptoms in the subform at left, matching diseases (that exhibit all the selected symptoms) get displayed at right. With the selection of more & more symptoms, list of diseases gets correspondingly narrowed down.
Data Entry
(a) Integrated interface for data entry facilitates smooth population of junction table bridging the many to many relationship between diseases & symptoms.
(b) After entering the disease name on main form, the user can select/enter corresponding symptom in an unbound combo box. If it matches one of the existing ones in the symptoms table, corresponding Symptom_ID gets entered directly in the junction table.
(c) If the symptom entered in the combo box is a new one, it gets appended to the symptom table and newly generated value of Symptom_ID gets entered in the junction table.
(d) In either case (b or c above), newly added symptom for the disease in question is displayed duly highlighted in the subform, in appropriate sort order.
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: tryggvi@sbcglobal.net
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, July 11, 2011 23:55
Subject: [MS_AccessPros] Medical database
I want to put a medical database on a website. My webhost says I can upload an MDB file and users will be able to use it as if the database resided on their own computer. I want users to be able to do three things:
1. Type in the name of a disease and get a list of related diseases
2. Type in the name of a disease and get a list of associated microbes.
3. Type in the name of a microbe and get a list of associated diseases.
I have Access 2007, but I haven't built a database in 15 years. My data is currently in MS Word tables.
I would like to know if Access 2007 is a reasonable choice for this project (MySQL is another option), and if there are templates that will make the task easier. I haven't built a database in fifteen years and the Northwind Trader's sample database is pretty ovewhelming.
Thanks.
Russ Farris
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar