Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2008
    Posts
    12

    Unanswered: MS Acces the right choice for a large medical patient study?

    Hey all.

    First of all, im not sure if this is the right place to post, so feel free to redirect or flame me if its not

    ---

    Anyways, my question is this:

    Im a coming phd student at univercirty of copenhagen, eye pathology department. Im about to start a large study regarding eye cancer.
    The object of the study is to make a database of the roughly 2500 patients who has died of the disease 'Uveal malignant melanoma' in Denmark the last 60 years.
    The database is to include loads of criterias about the cases, patient age, the size of the tumors, how long time went by from when the patient first had the tumor until death etc etc.
    The queries will be for instance: Show me the patients with a tumor larger than 5mm who died within 3 years...
    The database needs to be accessible to people with little to none computer skills, ie. as userfriendly as possible...

    Is MS Acces the right choise? Or is there another database program which is widely used and easy to get I should rather use?
    Last edited by Montanius; 10-07-08 at 06:44.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    sounds fine to me
    the right choice depends on lots of things
    what you have available, or what you can afford
    what you have experience with

    from what you've said so far
    its a historical analysis of data
    there is no special multi user component (ie you are not going to have lots of users slamming in data at the same time)
    depending on the number of users it maybe better to consider using a server back end.. but if you are reading only it shouldn't make that much difference. the precise number of userrs where Access/KET has problems varies.. it usually around 15..30 concurrent users, although it can be more, in some cases vastly more.

    if you have little or no experience ion any db system then Access may be appropriate.. its fairly easy to get something up and running quite quickly.

    the filter by forms should do a creditable job handling most of the what if /selection criteria you are referring to

    if you want a more generic and multi user approach a web based system such as ASP.NET or PHP may be more appropriate.

    I'd suggest you talk to your local systems trolls outlining your requirements and get them to agree to or suggest an appropriate environment.

    however switching to a more "capable" system, and that includes Access can require significant development time. you will probably get to 70..90% of your user requirement using bog standard Access, the final 10..30% may take a heck of a lot of time... it may depend on how the database is organised.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Sounds like the right choice to me too, but I have to point out that asking this question in a Microsoft Access forum is probably going to give you biased results.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Oct 2008
    Posts
    12
    Thank you for the replies guys.

    Quote Originally Posted by healdem
    there is no special multi user component (ie you are not going to have lots of users slamming in data at the same time)
    depending on the number of users it maybe better to consider using a server back end.. but if you are reading only it shouldn't make that much difference. the precise number of userrs where Access/KET has problems varies.. it usually around 15..30 concurrent users, although it can be more, in some cases vastly more.
    The database is not going to be used by a lot of people at once, one of the main critirias of the program is longivity, there will be added data many years from now, so I would like a platform which is capable of exporting data in the furture, or a program which will probobly be upgraded in the furture. Acces is a good bet i guess.

  5. #5
    Join Date
    Oct 2008
    Posts
    12
    Quote Originally Posted by StarTrekker
    Sounds like the right choice to me too, but I have to point out that asking this question in a Microsoft Access forum is probably going to give you biased results.
    Point taken

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    My primary concern would be legal, not performance. Access is inherently less secure than other more robust platforms. In the US, we have HIPAA to contend with, which is very stodgy about ensuring patient data remains confidential.

    Do you have any concerns on that front?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    security a good point....
    if its the usual medical research db I would have expected the patient names to be removed, and any other personal or sensitive data. it does depned on what the db is being used for.

    failing that there is of course the option of using Access with a server back end, or store any sensitive data in a secure medium and link to the access app as required.
    I'd rather be riding on the Tiger 800 or the Norton

  8. #8
    Join Date
    Jun 2008
    Posts
    163
    Would the database need to be accessible via a local network or over the internet?

  9. #9
    Join Date
    Oct 2008
    Posts
    12
    My data is secured on a server on the university, i work via vpn. In denmark we have a authority who looks over people who handle patient information, and they approved the setup including the office pack.

    So the answer to the network/internet question is yes and no, there is no need for tradional browser acces because of the vpn network

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •