LibreOffice (free) should be able to open a MS Access Database, though I don't know how much formatting it can carry over. Their database is rather clunky to use, but at least you can experiment without it costing you anything.
Use Access On Mac
Install Office 2016 on a Mac. Once the download has completed, open Finder, go to Downloads, and double-click MicrosoftOffice2016Installer.pkg (the name might vary slightly).
Failing that you should be able to export from Access as a comma-separated or tab-separated text file, which most database programs can open (though you won't carry over formatting or formulas - only the results of formulas) so a certain amount of work may be necessary to get it to behave.
This page (originally written for people abandoning 'AppleWorks') lists a number of Mac database applications:
How To Download Microsoft Access On Mac
It all depends on how complex the database is. If it's just a collection of text and numbers, with no calculations, then you shouldn't have too much trouble with it and should be able to use a fairly basic database application. Several of the applications listed in my page have free trials so that would be the next step to see whether you like the results. The ultimate database program is Filemaker Pro but it's extremely powerful and complex (and expensive) and likely much more than you need.
Access For Mac Free
Sep 11, 2017 3:54 AM