Free Alternative To Microsoft Access For Mac

Dec 13, 2015 I have purchase Microsoft 360 Home, the $9.99/mo version. When installing Office, the only apps that appear in my applications area (I use a Mac) are PowerPoint, Word, Excel, OneNote and Outlook. I believe I get Microsoft Access with my subscription, so my question is- how do I download and install it without it prompting me to purchase 360 again? Nov 23, 2017  Question: Q: Microsoft Access for Mac. Hey there, i am studying the functions of microsoft access and just found out that it is not available on mac. Is there a way to get microsoft access on mac or something really similar and having similar functions and controls. It would be just great if somebody could help me a.s.a.p.

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.

Mac
  • 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

Main

We may earn a commission for purchases using our links. Learn more.

A picture is worth a thousand words

The 'Super Pink Moon' is tonight — here's how to take pictures of it

On April 7, 2020, the stunning Super Pink Moon will make an appearance in the night sky. Here's how to take an incredible photo of it!

File Maker Pro

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.

AccessFor

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.

Free Alternative To Microsoft Access For Mac Free

Converting Access Databases to Apple Numbers with MDB Viewer
Converting Access Databases to Microsoft Excel with MDB Viewer

Free Alternative To Microsoft Access For Mac Pc

Microsoft Access in Parallels / VMWare

Best Alternative To Microsoft Access

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.