SQLite is not a full database application like Access. It is difficult to use and misses many important features, such as simple import/export tools. Open Office and Libre office include a database application that tries to mimic Microsoft Access. Unfortunately it has been discontinued in July 2013 and is no longer available for purchase. Bentoīento was the entry level database application from the makers of Filemaker. The underlying tables are more or less hidden from the user, and not as easily accessible via SQL as in Access. In FileMaker, logic and data are more closely linked. There is a strict distinction between application logic and the underlying tables in Access.
However, it's also necessary to note that FileMaker is very different from Access. It also has some support for scripting, and offers options for publishing databases on the web. Similar to Access, FileMaker stores your database logic and all the data in a single file. It has a feature set comparable to Microsoft Access, but with a strong focus on forms (layouts) as the primary way of accessing databases.
The ultimate database program is Filemaker Pro but it's extremely powerful and complex (and expensive) and likely much more than you need.įileMaker is probably the best known database application for the Mac. 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. 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. It all depends on how complex the database is. This page (originally written for people abandoning 'AppleWorks') lists a number of Mac database applications: Run windows games in mac. Their database is rather clunky to use, but at least you can experiment without it costing you anything.įailing 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. LibreOffice (free) should be able to open a MS Access Database, though I don't know how much formatting it can carry over. Previous versions include Access 2016, Access 2013, Access 2010, Access 2007, and Access 2003. Microsoft Access 2019 is the latest version of Access available as a one-time purchase. The most up-to-date version of Microsoft Access is always available with a Microsoft 365 subscription.
Microsoft Access is available for PC only. When installing Office, the only apps that appear in my applications area (I use a Mac) are PowerPoint, Word, Excel, OneNote and Outlook. Microsoft Access for Mac I have purchase Microsoft 360 Home, the $9.99/mo version.