Getting Started on Access2003 Database

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

Hi all-

I hope this is the right place to post this. I'm wanting to create a
database that has a list of symptoms related to a certain disease, and upon
that; telling me what I should do next (one of two options, that I'll be
entering as well). Is there anyone that can help get me started? I've
imported the symptoms/diseases into a table already, I just don't know where
to go from there.

TIA,

Kiddo
 
Well, this is not my "bag" since I´m an engineer and not a doctor ;-)

But I would start with creating THREE tables (tblDisease, tblDiseaseSymptoms
and tblLookUpSymptomes)

tblDisease keeping all the disease and data related ONLY to the desease.
tblLookUpSymptomes keeping all type of symptomes since (i guess) several
disease can have same symptoms!? And finaly
tblDiseaseSymptoms where you link all the symptoms a disease can have. The
structure woud look like this:

tblDisease..................tblDiseaseSymptoms..........tblLookUpSymptomes
DiseaseID (1)----(M) fkDisease
DiseaseName.............fkSymptomID (M) ---- (1) SymptomID
(etc.)..........................(etc.)..................................Symp
tomName
.............................................................................
(etc.)

With this structure you only have DiseaseName in one table and only
SymptomName in one table but you configurate the symptomes for each disease
in table tblDiseaseSymptoms.

This is a standard solution for this type of problem. And if you are going
to develop several databases in the future you will come across this many
times.

One thing I have learnt is to use a lot of time to thinkt through the table
structure and wich data to store. Which question I want to get answere on
from my db (data base). The tables are the heart of the db and you can save
a lot of developing time if you have your table structure set up correct!

You learn by makin mistakes so I have made a few but have many more to do
;-)

// Niklas
 
I do apologize. I didn't explain this well at all. I have imported the data
into 3 separate tables. What I would like to do is be able to put in a
symptom and have it bring up the disease and one other variable. (continated
or incontinated) I'm so stuck, and I've even taken Access courses, I just
have never used it until now!

Thanks again,
Jordan
 
Back
Top