Dear John
Thanks for your input.
Regarding the design of the database, after finishing the design I
understood that it is not good. Let me explain what is my aim and how did I
design it, so maybe you can give some hints.
What is the aim?
I have a health questionnaire, which is filled in clinics and I want to
input them into access and later I will analyze them statistically. This
questionnaire contains 31 questions and I have put all of them in one table.
Patients are categorized into two types, namely desk-work patients and
non-desk-work patients.
Questions are as follows:
1) Name, Gender, Age, education, patient type, clinic name (totally 8
questions)
2) 5 questions about smoking habits of patient, like:
Do you smoke? How many per day?, For how long do you smoke?
3) 2 questions about sporting activity
4) 4 questions about disease history, like:
Do you have CHD?
If yes, please explain
Do you have Diabetes?
If yes, please explain
5) 8 questions which should be measured like:
Height, Weight, Waist, hips, blood pressure, blood rate
6) 6 questions which need a test, and its result will be input like:
Cholesterol, Glucose, Insulin
Structure of my db:
TblClinic
ClinicID
ClinicName
ClinicAddress
And some other
TblPatientType
ClinicID
PatientTypeID
PatientType (has only two options, desk-work patients and non-desk-work
patients)
TblMain
PatientTypeID
And then most of above-mentioned questions except for those which are
mentioned in above tables.
My relationships are defined as follows:
A one to many relation from Clinic Table to PatientType Table
A one to many relation from PatientType Table to main Table.
I want to design a form for data-entry purpose. Questionnaire comes in the
following order.
Questionnaire for each clinic come separately.
Then for each clinic, type of patients is separated.
So in my form, I want to have 2 subforms in my main form. In the main form,
I want to input clinic name, then in the first subform, I want to input
patient type and finally in second subform to enter all main data.
The reason for this method to design the form, is to ease the data entry.
Let say for 30 patients (10 is type one and 20 is type 2) in clinic A, I want
to enter the clinic name only once for all 30 patients. Then enter patient
type once and then only fill the 2nd subform.
Any help is highly appreciated.
