Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2014
    Posts
    5

    Question Need help designing a database

    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

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,863
    Quote Originally Posted by docpanderson View Post
    ...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?

  3. #3
    Join Date
    Jul 2014
    Posts
    5
    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

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,629
    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.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,863
    Can you, in 20 words or less, describe the curriculum of the course you took? Use only topics and or buzz words if necessary.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. database designing
    By tommyried in forum Database Design
    Replies: 1
    Last Post: 02-27-2014, 12:41 PM
  2. Designing my database
    By ldypurple in forum Database Design
    Replies: 11
    Last Post: 03-06-2013, 10:58 PM
  3. Designing a database for a log
    By neo651 in forum Database Design
    Replies: 3
    Last Post: 10-31-2011, 11:45 AM
  4. Help with designing database
    By nimalp in forum Access
    Replies: 6
    Last Post: 09-15-2010, 10:34 AM
  5. Designing Load Database
    By salisbut in forum Database Design
    Replies: 5
    Last Post: 08-02-2010, 10:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums