Posted 2014-10-15, 01:52 PM
in reply to WetWired's post starting "MS Access"
Lemme ask you this. I have about 60 patients I need to track authorization for. Authorization is what the insurance gives us to see a patient (like permission). Each patient is different. Their authorization expires within a 30, 60, 90 day period. I have 5 separate disciplines I am tracking for authorizations. For instance
Joe Somebody has 5 SN visits, 3 PT vists, and 8 OT vists. This auth is good from 10/10/14 to 12/8/14.
I need to be able to create something that is visually pleasing that makes it easy to tell when additional auth is required. Is that something Access would do better than excel?
Quite possibly. Access lets you create forms to view records (and joined records), rather than viewing a table. You can also create a query that would include the latest (of possibly many) authorizations for a patient.
Access can be a pain if you're trying to tightly control the procedure to enter information, but if you're currently using Excel, then it's an upgrade in terms of functionality easily added and usability.
Hybrid Mode
