Need help designing a database

[docpanderson]

I just finished my first class on Access at the local community college. I am trying to set up a database for my office that I could use as a chart noting application for my chiropractic office. I am struggling with the set up. How do I organize the database so that I can have multiple dates of service for a single patient? I have created a table of patients that has their demographic info, and a key that will be the patients ID number for the database. Do I keep each date of service as a separate field?



Need help getting started. Any pointers would help.

Peter

[ItsMe]

...Do I keep each date of service as a separate field? ...

Yes, but as a separate Row and not as a separate Column.

Do you have a table that stores appointments? Does this table have foreign key fields?

[docpanderson]

I was not able to attach a screenshot for you to look at but my idea was to organize it this way:
tblPatient
fields to include: Chart #(key) FirstName, LastName, gender, DOB, PatientType, Address, City, State, Zip, Phone, Insurance ID# etc
tblInsurance
fields to include: Payer ID (key), InsuranceName, Address, City, State, Zip, Telephone
tblSubjective
fields to include: Complaint1, Type of pain, location, Severity, Frequency

Now I need to capture for each date of service the subjective fields listed above for a chart note. Each chart note will be specific to one date so will that be a report or a form? I'm thinking it is a form. I want the previous notes info to still populate the form so I don't have to start from square one each visit, only update and change information as the patients condition improves.

So my question is this...how do I create a table that would capture multiple dates of service for each patient?
Any screen shots would be appreciated, I'm a visual learner.
Peter

[June7]

How is tblSubjective related to other tables?

Advise no spaces or special characters/punctuation (underscore is exception) in naming convention. Better would be ChartNum, ChartNo, Chart_Num.

[ItsMe]

Can you, in 20 words or less, describe the curriculum of the course you took? Use only topics and or buzz words if necessary.