Results 1 to 3 of 3
  1. #1
    wkenddad is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2012
    Posts
    2

    Red face Help With Patient Tracking Database Design

    I haven't messed with Access in 10 years.
    I now realize that a Database is the best way to go.
    I have gone beyond the capabilities of Excel.

    The task:
    A patient tracking Database.
    I need to track the LDL Cholesterol results for patients.

    My Spreadsheet now has the following fields:

    Name - MRN - Date of LDL - LDL Result - Contact Type - Contact Date - Notes - Retest Date

    The MRN is a unique Medical Record Number

    The Retest Date is either 6 months (182 Days) from LDL Date or 50 Days.
    (If LDL Result < 100, Retest Date = Date of LDL + 182 Days, ELSE Retest Date = Date of Last LDL + 50 Days)

    I invision Splitting the Spreadsheet into the following Tables:

    1. Patients:
    Field 1: Name
    Field 2: MRN *

    2. Results:
    Field 1: Result_ID *
    Field 2: MRN
    Field 3: Result_Date
    Field 4: LDL_Result

    3. Contacts:
    Field 1: Contact_ID *
    Field 2: Contact_Type
    Field 3: Contact_Date
    Field 4: Notes



    4. Contact_Types:
    Field 1: Contact_Type_ID *
    Field 2: Contact_Type (Phone, E-Mail, Message, Appointment, Letter) - For a list Box

    * Denotes Primary Key

    Can any of you Guru's assist me in setting this up, if in fact My structure is sound?
    Or can you make suggestions as to the proper structure.

    I would like to see a list of patients with all data on one line.
    I would only need the most recent LDL Date and Value to show.
    I would like the Contact_Type field to be a drop down box to select fro.m.
    I would also like to be able to edit the Contact_Date, and notes fields

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Not showing relationship between Contacts and Patients. Need PatientID in Contacts?

    "I would like to see a list of patients with all data on one line."
    You want the Results data on one line? Crosstab query might work, if not review:
    http://forums.aspfree.com/microsoft-...ry-322123.html
    http://allenbrowne.com/func-concat.html

    "I would only need the most recent LDL Date and Value to show."
    Review http://office.microsoft.com/en-us/ac...010096309.aspx

    "I would like the Contact_Type field to be a drop down box to select from."
    Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the 3 on comboboxes in Access Forms: Control Basics.

    "I would also like to be able to edit the Contact_Date, and notes fields"
    Build forms, probably even form/subform arrangements for data entry.
    http://office.microsoft.com/en-us/ac...010098674.aspx
    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.

  3. #3
    miraculous is offline Novice
    Windows XP Access 2000
    Join Date
    Apr 2012
    Posts
    1
    I am in a research about our access project, hope you'll post your progress about your patient tracking database task.

    ___________
    Milagros Behrens
    Wilkinsburg PA
    lower cholesterol naturally
    Last edited by miraculous; 04-28-2012 at 02:24 AM.

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

Similar Threads

  1. Asset Tracking Database
    By wgroenewald in forum Access
    Replies: 3
    Last Post: 02-13-2012, 08:26 PM
  2. Simple Fund Tracking Database
    By tday in forum Database Design
    Replies: 2
    Last Post: 10-10-2011, 03:56 PM
  3. Cafeteria tracking system design
    By tsr_83 in forum Programming
    Replies: 2
    Last Post: 07-28-2010, 09:45 PM
  4. Patient Database
    By labadee in forum Database Design
    Replies: 1
    Last Post: 06-27-2010, 10:53 PM
  5. help with tracking within a database
    By martyn in forum Queries
    Replies: 0
    Last Post: 10-07-2009, 02:15 PM

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