File Maker Pro
2011-7-6 I used to work with MS Access in Windows, yet moved to a mac a year ago and bought the office software. As I now would like to buy MS Access to help me manage a small database, I was wondering about whether this is possible as I did not find and MS Access software for macs on the web (or may not have looked sufficiently). Early access with Office Insider. Open an Office app, like Word, then click Help Check for Updates Advanced. If you're looking for previous release downloads for Microsoft AutoUpdate, see Update history for Office for Mac. Need help with Microsoft AutoUpdate? Troubleshoot Microsoft AutoUpdate. Additionally, I plan to do multi-platform software testing for work and found that Microsoft Access runs through Parallels exactly as if I were running it on a PC.” Nevertheless, Parallels Desktop is an easy and cost-effective solution to run Microsoft Access on your Mac.
FileMaker is probably the best known database application for the Mac. It has a feature set comparable to Microsoft Access, but with a strong focus on forms (layouts) as the primary way of accessing databases. Similar to Access, FileMaker stores your database logic and all the data in a single file. It also has some support for scripting, and offers options for publishing databases on the web.
However, it's also necessary to note that FileMaker is very different from Access. There is a strict distinction between application logic and the underlying tables in Access. In FileMaker, logic and data are more closely linked. The underlying tables are more or less hidden from the user, and not as easily accessible via SQL as in Access.
Bento
Bento was the entry level database application from the makers of Filemaker. Unfortunately it has been discontinued in July 2013 and is no longer available for purchase.
Open Office / Libre Office
Open Office and Libre office include a database application that tries to mimic Microsoft Access. It is difficult to use and misses many important features, such as simple import/export tools.
SQLite (using Base)
SQLite is not a full database application like Access. There are no forms or reports in SQLite, there's only your data and a simple, fast SQL engine. SQLite is used by many applications under the hood as an internal format and therefore most interesting to application developers.
A command line utility for SQLite 3 is included with every Mac, aptly named sqlite3. Most people will however prefer working with a graphical application like the excellent Base from Menial (available on the Mac App Store). Base offers a simple interface for viewing tables (with support for images) and creating custom SQL queries.
Apple Numbers and Microsoft Excel
Numbers and Excel are spreadsheet applications and thus not a replacement for Microsoft Access. However, they have good support for working with tables. If your database consists of only few tables and no forms, these apps might just do the trick. You can at least sort and filter your tables.
Converting Access Databases to Apple Numbers with MDB Viewer
Converting Access Databases to Microsoft Excel with MDB Viewer
Microsoft Access in Parallels / VMWare
If none of the above are suitable, you can always ressort to actually running Microsoft Access on your Mac using virtualisation software like Parallels Desktop or VMWare Fusion.
You don't have to leave Microsoft Office if you decide to switch from PC to Mac. Microsoft has a perfectly good version of Office 365 for Mac that comes with Word, Excel, PowerPoint, OneNote, Outlook, and more. If you've been thinking about switching away from the Office productivity suite, there are alternatives that offer many of the features you love in Microsoft's programs, plus some features you can't get anywhere else.
iWork Suite
Apple's alternative to Office is iWork. It's the most comparable alternative to Microsoft's productivity suite, only it comes free with every Mac. The interface is different, and will take some time to get used to, but if you're really interested in kicking Office to the curb, the iWork suite is the best alternative on Mac.
If you're ready for change, and Office's user interface, design, and tools aren't burned into your psyche, get Apple's iWork suite of apps. It comes preinstalled on new Macs, but you can also find it in the Mac App Store.
- Pages - Download now
- Numbers- Download now
- Keynote - Download now
OpenOffice
OpenOffice by Apache is probably the most similar to Microsoft Office in look and design. It comes with a word processor, a spreadsheet maker, and a presentation creator, all with many of the same features their Office counterparts have. Files are saved as open document format files, so they can be opened with any document viewer, including Office apps, without needing to be converted first. The best part is that OpenOffice is completely free.
If you're looking for an alternative to Microsoft Office that looks and works pretty much exactly the same, but doesn't cost a dime, OpenOffice is for you.
LibreOffice
LibreOffice is an open source productivity suite very similar to Microsoft Office that comes with a word processor, spreadsheet maker, and presentation creator. It also includes a vector graphics editor, a math formula editor, and a database manager. Files are saved as open document format files, so you can open them with any document viewer, including Office apps, without needing to be converted first, though it does provide tools for saving a document as an Office-specific file. LibreOffice is totally free. It is very similar in design to Microsoft Office, with some minor differences in the design.
LibreOffice is a solid replacement for the Office apps and includes some useful extra programs that Office doesn't even have.
Google Docs
Google Docs is the easiest replacement for Microsoft office because it's so accessible. If you have a Gmail account, or a Google Hangouts account, or a YouTube account, you have Google Docs. Just visit the web-based app from your browser and you can create word processor documents, spreadsheets, and presentations. There is a Google Drive app you can download onto Mac so you can work offline. The changes will be made when your Mac is back online. Google Docs doesn't look at all like Microsoft Office, and has a very different user interface, but it does have many of the same, familiar features you know from Office.
The thing that makes Google Docs so useful, however, is it's real-time collaboration, which works seamlessly with multiple users. I've worked alongside a dozen other people in one document. I am able to see where everyone is within the documents and can see exactly when changes are made.
If you're looking for a very easy to use Office replacement that is ideal for working with others in real-time, you'll be pleased with Google Docs.
What's your pick?
Do you use a Microsoft Office alternative you'd recommend to our readers that are new to Mac or just want to switch from Microsoft? Put your suggestion in the comments below and tell us why its the one you chose.
MacBook Pro
Like For Like Sales
Main
Microsoft Access Like App For Mac Free
We may earn a commission for purchases using our links. Learn more.
⌚ï¸x8F✨😎We review the subtly blingy LAUT OMBRE SPARKLE Strap for Apple Watch
Microsoft Access Like App For Mac Download
Bring a little bit of sparkle to your wrist, but not too much, with this colorful genuine leather Apple Watch band.