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.