Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Nov 27, 2012, 06:32 AM   #1
MOFS
macrumors 65816
 
MOFS's Avatar
 
Join Date: Feb 2003
Location: Liverpool, UK
Best program for Audit database

Hi guys

I'm looking for some advice regarding database apps. I'm going to be starting a medical audit. I'll be collecting binary (yes/no), linear (eg blood values) and textual (diagnosis) data for around 50 patients and then presenting my findings. I've used Excel in the past, which has been ok, but is easier to use for group data/interpretation rather than looking at a specific patient. Is there a programme for OS X that would allow me to collate the same variety of date for a number of different patients and then either calculate it for me or allow me to export the data into something else? If there's an associated iPad app that would be even better.

Cheers
MOFS is offline   0 Reply With Quote
Old Nov 27, 2012, 07:12 AM   #2
Efrem
macrumors member
 
Join Date: Jul 2009
In terms of end-user database management systems for Mac, FileMaker Pro is pretty much the only game in town. Fortunately, it's also good.

That said, from your description I'm not sure your application is beyond Excel yet. You might look into its filters and LOOKUP functions to see if they will meet your needs before going to a "real" DBMS. Custom VBA programming in Excel can also do just about anything a DBMS can, some may recommend it, but I'd use FileMaker rather than go that route.
Efrem is offline   0 Reply With Quote
Old Nov 27, 2012, 01:35 PM   #3
MOFS
Thread Starter
macrumors 65816
 
MOFS's Avatar
 
Join Date: Feb 2003
Location: Liverpool, UK
Quote:
Originally Posted by Efrem View Post
In terms of end-user database management systems for Mac, FileMaker Pro is pretty much the only game in town. Fortunately, it's also good.

That said, from your description I'm not sure your application is beyond Excel yet. You might look into its filters and LOOKUP functions to see if they will meet your needs before going to a "real" DBMS. Custom VBA programming in Excel can also do just about anything a DBMS can, some may recommend it, but I'd use FileMaker rather than go that route.
In that case would Bento be an acceptable alternate? I only really need to manage about 50-100 patients with about 20 bits of info per patient.
__________________
Be good
MOFS is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 03:54 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC