Results 1 to 6 of 6
  1. #1
    mi_2 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2019
    Posts
    3

    DB for Evaluation of Studies possible?


    Hi there,

    (i have only mild knowledge of programming, but have used Access before, so please excuse me if my question might be noobish)

    I was given the task to perform a Systematic Review on a medical subject. 2 or more physicians will be evaluating over 400 studies and extract pre-defined data from those published studies.
    Hence, Each study will be evaluated at least twice and the data also will be extracted twice for each study.
    After that an Independent Researcher will integrate "both" datasets and decide if the study is valid and the extracted data will be used.

    So far i have made several tables for the extracted data, an overview table and an Evaluation table.

    My Problem is, that if more users will evaluate the same study i will have multiple unique IDs for the same study. Is there any way of feasibly indexing or designing the tables for this project?

    thank you all so much in advance

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    1. you dont need to know any programming. everything can be done via macros.
    2. you need a tStudy table.
    the study can have an autonum as ID, then this ID used in the other tables, say tEval

    tEval table:
    EvalID (autonum)
    StudyID (long) from the tStudy table
    ResearcherID (long) from the tResearcher table
    Notes
    etc

  3. #3
    mi_2 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2019
    Posts
    3
    wow...thanks alot for that unbelievably fast answer,

    i will get right onto it and try that!

    thank you very much!


    Quote Originally Posted by ranman256 View Post
    1. you dont need to know any programming. everything can be done via macros.
    2. you need a tStudy table.
    the study can have an autonum as ID, then this ID used in the other tables, say tEval

    tEval table:
    EvalID (autonum)
    StudyID (long) from the tStudy table
    ResearcherID (long) from the tResearcher table
    Notes
    etc

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You have provided very little info on what you will be doing.
    I would suggest you first design the tables/relationships on paper, whiteboard, the window, etc..... BEFORE jumping into Access. Then try manually adding data to see how things work.


    2 or more physicians will be evaluating over 400 studies
    What is involved in a Study?



    and extract pre-defined data from those published studies.
    What will be "extracted"? What will be done with the extracted data?



    My Problem is, that if more users will evaluate the same study i will have multiple unique IDs for the same study. Is there any way of feasibly indexing or designing the tables for this project?
    So you are also going to need a table for physicians/users......



    BTW, Welcome to the forum......

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Once you have properly designed your tables, you can indeed do a lot using macros.
    However you certainly can't do everything using that approach.
    After a while you are likely to need things that require the use of code (VBA).
    So it may be better to do that from the start
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    mi_2 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2019
    Posts
    3
    Quote Originally Posted by ssanfu View Post
    You have provided very little info on what you will be doing.
    I would suggest you first design the tables/relationships on paper, whiteboard, the window, etc..... BEFORE jumping into Access. Then try manually adding data to see how things work.
    I did that on paper, so i have a rough idea what it should look like and comprise


    Quote Originally Posted by ssanfu View Post
    What is involved in a Study?
    The data that i Need to extract from These studies are 1. study design, 2. study Population, 3. study Intervention and 4. study Outcome Parameters
    i.e. A double-blind, randomized, study testing if Aspirin is better in reducing the risks of stroke than Placebo in an adult Population with Hypertension. Outcome in this case would be mean # of strokes compared in both Groups (ASS vs. Placebo) as well as disability, Quality of life etc...




    Quote Originally Posted by ssanfu View Post
    What will be "extracted"? What will be done with the extracted data?
    the extracted data will then be summarized in a short Review and presented i.e.: All Aspirin studies combined, all Placebo studies combined....
    the statistical Analysis will be performed in SPSS though, Access really just serves as data extraction form




    Quote Originally Posted by ssanfu View Post
    So you are also going to need a table for physicians/users......B


    TW, Welcome to the forum......
    thank you very much, the Speed of users answering is staggering!

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

Similar Threads

  1. Replies: 2
    Last Post: 08-11-2015, 05:13 AM
  2. Custom Evaluation Code for Access 2007 runtime
    By boywonder in forum Programming
    Replies: 3
    Last Post: 01-20-2013, 12:23 AM
  3. Replies: 7
    Last Post: 10-30-2012, 11:22 AM
  4. Replies: 2
    Last Post: 10-20-2011, 08:31 AM
  5. Replies: 1
    Last Post: 08-06-2011, 10:45 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