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 Demi-God
 
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 Demi-God
 
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

Similar Threads
thread Thread Starter Forum Replies Last Post
Why can't I find an elegant looking, dark-themed database program for mac? dcnblues Mac Applications and Mac App Store 5 Jun 4, 2014 01:34 PM
GW2 Database- iPhone and iPad database for Guild Wars 2 skoroapps iPad Apps 19 Jul 20, 2013 05:59 AM
GW2 Database - iPhone and iPad database for Guild Wars 2 skoroapps iPhone and iPod touch Apps 14 Jul 20, 2013 05:58 AM
Any way to audit cellular usage? NestOfRobins iPad 9 Sep 6, 2012 10:32 PM
We're gonna audit the FED eric/ Politics, Religion, Social Issues 28 Aug 4, 2012 03:42 PM

Forum Jump

All times are GMT -5. The time now is 05:17 AM.

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

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