Recent content by nightale

  1. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Thanks! I posted a reply on the other thread if you want to take a look. With your help and Dal's, I think I'm very close to the design I was looking for. Your test area is really a good idea, because it falls in line with my research hypothesis. For example, I'll check how cardiovascular...
  2. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Ok. Not storing null values makes a lot of sense now that you say it. 1) As I said in the other thread, I will make sure to put all patient data that will be stable (sex, dob, ...) across the study in the main patient table (tbl_Patient), all the rest (such as weight, waist size, bmi, etc.) in...
  3. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Hi jdraw, Thanks for your time. I just read the etiquette document (I think you added that as an edit, as I haven't seen it before re-reading the thread, sorry!). I didn't delete the post, but I added a reply and specified at the beggining it was a crosspost from this forum. I hope I haven't...
  4. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Oh I see. No. Because this is a clinical research database and not a clinical database per se, I don't see patients if I don't administer at least one questionnaire! (unlike a doctor-patient following database where you record all visits) Edit 2 : e.g. So if only 10 of the 16 questionnaires are...
  5. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Hey there, Yes. It is possible that, for instance, at visit 2, patient 1 completes only the depression and apathy questionnaires, but not the dementia one. I reviewed your model. If we let go the lookup table for the questions, we have now only the Patient and PatientTestDepEval and the...
  6. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Thank you so much for your help. I understand what you meant with that screenshot of yours. However, I've reconsider this aspect : all my tests/questionnaires are standardized and will not change over time. The only thing that may happen is that a test/questionnaire will be added to the...
  7. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Hi, Oh! This is very eye-opening for me! Regarding the quote above, I wasn't clear. I want everything I need for analyses in Access, the rest will stay on the paper file of each patient, because I'll never use them for group analysis and I'll never need them. (for example notes about the...
  8. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Hi, Once again thanks for your time. -It appears you are using both Access and Excel (How are your excel skills?) (My Excel skills are minimum at best) : actually, I only used Excel to show what data will be recorded (Patient x Evaluation x Test). I am OK with Excel, but I find it pretty...
  9. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Hi jdraw, Thanks for your time again. I'd buy you coffee if I could :-P All your affirmations are correct regarding my database design. Please see my attached screenshot entitled "nightale_access.jpg". It is a mock-up patient data sample, with (of course) less questions and questionnaires...
  10. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Hi, Yes the whole depression questionnaire is ALWAYS administered at full. (all the 15 questions) PS: there will be a total of 16 tests/questionnaires, although I showed only 3 in my screenshot. Actually a test is a specific terminology for a task, e.g. a memory test. It has many scores...
  11. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Thank you for your time again. I agree with the patient demographics. I will only put information that won't change in this table, such as Name, Date of birth, etc. I will create another table for the BMI, waist size, etc. data. You are right for "tblApathy, tblDementia and tblDepression...
  12. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    PS: by evaluation, I mean the whole battery. For each iteration of evaluation, the whole battery (or a part of it) was administered). Thank you so much for your patience with me. I did re-read the tutorials and I have a hard time translating examples of the customer/order type to a clinical...
  13. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Hi, Thanks for the help and the tips. However, after going through this file (and also the previous normalization tutorial on roger's blog), I'm still lost with regards to some aspects of my database relationships. The problem is that I can't seem to get my "test1" form to be synchronized...
  14. N

    (newbie) Can't find how to set up my relationship for clinical database with followup

    Hi guys, I am a graduate student and I'm "trying" (very hard though) to create a relational database in Access for my thesis study. Basically, I have recruited patients that I evaluated with a battery of tests and questionnaires. I'm having trouble to set my table relationships so I have the...
Back
Top Bottom