Microsoft Access is designed to scale to support more data and users by linking to multiple Access databases or using a back-end database like Microsoft SQL Server. With the latter design, the amount of data and users. Assign a meeting policy to users. In the left navigation of the Microsoft Teams admin center, go to Users, and then click the user. Select the user by clicking to the left of the user name, and then click Edit settings. Under Meeting policy, select the policy you want to assign, and then click Apply.
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 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.
Today, we are announcing the general availability of Office 2019 for Windows and Mac. Office 2019 is the next on-premises version of Word, Excel, PowerPoint, Outlook, Project, Visio, Access, and Publisher.
Get more with Office 365 ProPlus
Office 365 ProPlus is the most productive and most secure Office experience for enterprises.Learn more
Office 365 ProPlus, the cloud-connected version of Office, delivers the most productive and most secure Office experience—with the lowest total cost of ownership for deployment and management. However, for customers who aren’t ready for the cloud, Office 2019 provides new features and updates to the on-premises apps for both users and IT professionals. Like Windows Long Term Servicing Channel (LTSC) releases, Office 2019 provides a set of valuable enhancements for customers who can’t be cloud-connected or receive regular updates.
The new enhancements in Office 2019 are a subset of a long list of features that have been added to Office 365 ProPlus over the last three years. Office 2019 is a one-time release and won’t receive future feature updates. However, we’ll continue to add new features to Office 365 ProPlus monthly, including innovations in collaboration, artificial intelligence (AI), security, and more.
Office 2019 delivers features across apps to help users create amazing content in less time. In PowerPoint 2019, you can create cinematic presentations with new features like Morph and Zoom. And improved inking features across the apps in Windows—like the roaming pencil case, pressure sensitivity, and tilt effects—allow you to naturally create documents.
Excel 2019 adds powerful new data analysis features, including new formulas and charts and enhancements to PowerPivot.
Word 2019 and Outlook 2019 help you focus on what matters most. Learning Tools, like Read Aloud and Text Spacing, make it easier to engage with your content. Focus Mode blocks out distractions and puts your content front and center. And Focused Inbox moves less important emails out of the way—so you can get straight to taking care of business. For a longer list of the new features in Office 2019, see our FAQs.
Microsoft Access For Mac
Office 2019 also includes new IT value for enhanced security and streamlined administration. We introduced Click-to-Run (C2R), a modern deployment technology, in Office 2013, and it’s now used to deploy and update Office across hundreds of millions of devices worldwide. With Office 2019, we’re moving the on-premises versions of Office to C2R to reduce costs and improve security. The advantages of C2R include predictable monthly security updates, up-to-date apps on installation, reduced network consumption through Windows 10 download optimization technology, and an easy upgrade path to Office 365 ProPlus. C2R offers the same enterprise-focused management capabilities as Microsoft Installer (MSI) based products and will also support an in-place upgrade when you move to Office 2019 from older MSI-based products. To learn more, refer to the Office 2019 Click-to-Run FAQ.
The 2019 release of Office products also includes updates to our servers, and in the coming weeks, we will release Exchange Server 2019, Skype for Business Server 2019, SharePoint Server 2019, and Project Server 2019.
Office 2019 is a valuable update for customers who aren’t yet ready for the cloud. And each time we release a new on-premises version of Office, customers ask us if this will be our last. We’re pleased to confirm that we’re committed to another on-premises release in the future. While the cloud offers real benefits in productivity, security, and total cost of ownership, we recognize that each customer is at a different point in their adoption of cloud services. We see the on-premises version of Office as an important part of our commitment to give customers the flexibility they need to move to the cloud at their own pace.
Microsoft Access For Mac Computers
Microsoft Access Equivalent For Mac
- Commercial volume-licensed (trusted) customers can access Office 2019 starting today.
- Office 2019 is now available for consumer and commercial customers. For consumer customers in China, India, and Japan, Office 2019 suites will be available in the next few months.
- Certain features are only available in the Mac or Windows versions of Office 2019. For details, see the FAQ.