Office Access For Mac

-->Office

Office for Mac that comes with a Microsoft 365 subscription is updated on a regular basis to provide new features, security updates, and non-security updates. The following information is primarily intended for IT professionals who are deploying Office for Mac to the users in their organizations.

Note

Office Access Key Mac

  • Starting with Version 16.21, Microsoft Teams will be installed by default for new installations if you're using the Office suite install package. For more information, see Microsoft Teams installations on a Mac.
  • For security reason, Microsoft has deprecated the use of SHA-1. Learn more
  • Starting with the 16.17 release in September 2018, this information also applies to Office 2019 for Mac, which is a version of Office for Mac that’s available as a one-time purchase from a retail store or through a volume licensing agreement.
  • The update history information for version 16.16 and earlier also applies to Office 2016 for Mac, which is also a version of Office for Mac that’s available as a one-time purchase. Older versions up to and including 16.16 can be activated with an Office 2016 for Mac volume license. You can’t activate version 16.17 or later with an Office 2016 for Mac volume license. For information about Office 2016 for Mac releases from September onward, see Release notes for Office 2016 for Mac
  • For information about the features, security updates, and non-security updates that are included in a given release of Office for Mac, see Release notes for Office for Mac.
  • If you want early access to new releases, join the Office Insider program.

These steps apply only to Office Professional Plus, Visio Professional, or Project Professional. Step 1: Start an Office app, like Word, Project, or Visio, depending on your purchase. Step 2: In the Sign in to set up Office window, select I don't want to sign in or create an account (it's a small link at the bottom of the window). Step 3: Enter your Office product key, without hyphens.

Microsoft Office Access is not available for Mac but there are plenty of alternatives that runs on macOS with similar functionality. The most popular Mac alternative is LibreOffice - Base, which is both free and Open Source.If that doesn't suit you, our users have ranked more than 50 alternatives to Microsoft Office Access and many of them are available for Mac so hopefully you can find a. If you need to uninstall Office first, see Uninstall Office from a PC or Uninstall Office for Mac. Note: The steps to install the 2016 or 2013 versions of Office Professional Plus, Office Standard, or a stand-alone app such as Word or Project might be different if you got Office through one of the following. Access an extended collection of royalty-free creative content, including templates, stock photos, icons, and fonts. OneDrive advanced security Know your files are protected with built-in ransomware detection and recovery and use two-step identity verification to access your. Update Office from the Mac App Store. If you downloaded Office from the Mac App Store, and have automatic updates turned on, your apps will update automatically. But you can also manually download the updates: Open the Mac App Store from your Dock or Finder.

Most current packages for Office for Mac

The following table lists the most current packages for the Office suite and for the individual applications. The Office suite includes all the individual applications, such as Word, PowerPoint, and Excel. All packages are 64-bit only. The build date is listed in parentheses, in a YYMMDD format, after the version number. The install package is used if you don't have the application already installed, while the update package is used to update an existing installation.

Office 365 Microsoft Access For Mac

To view release notes, see Release notes.

October 13, 2020

Microsoft Office Access For Macbook

Version 16.42 (20101102)

Office
ApplicationDownload linksSHA-256 hash for install package
Office suite (with Teams)Install package8AC425F0E31869B32C323F4349FB48E9B1C3A114B77EA68897D97C50D9B8BECB
Office suite (without Teams)Install package5FA1084BD240BF10FAAF94D908492939807EAD8E014582DCB2ADE7ECC484276B
WordInstall package
Update package
21C54A78343B106A93FFD176130DEB9A6C9154F56EB58446FC27192D1E191995
ExcelInstall package
Update package
2235E4FE0741CE013777E2B6811AD9EFF738F9A724860FBA0DFD31976BF96E62
PowerPointInstall package
Update package
EAF6B82C2042BD4D026779CEB4A58E0B92C8E320A9797C77CA3A588FD94B19EB
OutlookInstall package
Update package
566A1BD7AD446FCDD31156EBCA3FBD7F8F8BB2EFBCC8F3217CB55AA16A586420
OneNoteUpdate packageNot applicable

Microsoft Office For Mac Access

Release history for Office for Mac

Microsoft Office For Mac 2019

The following table provides release history information and download links for Office for Mac. The table is ordered by release date, with the most recent release date listed first. The build date is listed in parentheses, in a YYMMDD format, after the version number. All releases after August 22, 2016 are 64-bit only. All releases prior to August 22, 2016 are 32-bit only.

Note

Download links are only provided for the most recent releases.

Release dateVersionInstall packageUpdate packages
October 13, 202016.42 (20101102)Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
September 15, 202016.41 (20091302)Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
August 11, 202016.40 (20081000)Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
July 14, 202016.39 (20071300)Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
June 16, 202016.38 (20061401)Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
May 12, 202016.37 (20051002)Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
April 21, 202016.36 (20041300)Office suite (with Teams)
Office suite (without Teams)
April 14, 202016.36 (20041300)Word, Excel, PowerPoint, Outlook, OneNote
March 10, 202016.35 (20030802)Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
February 11, 202016.34 (20020900)Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
January 14, 202016.33 (20011301)Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
December 10, 2019
16.32 (19120802)
Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
November 12, 2019
16.31 (19111002)
Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
October 15, 2019
16.30 (19101301)
Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
September 18, 2019
16.29.1 (19091700)
Word, Excel, PowerPoint
September 10, 2019
16.29 (19090802)
Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
August 13, 2019
16.28 (19081202)
Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
July 16, 2019
16.27 (19071500)
Office suite (with Teams)
Office suite (without Teams)
Word, Excel, PowerPoint, Outlook, OneNote
June 11, 2019
16.26 (19060901)

May 14, 2019
16.25 (19051201)

April 16, 2019
16.24 (19041401)

March 27, 2019
16.23.1 (19032603)
March 12, 2019
16.23.0 (19030902)

February 20, 2019
16.22 (19022000)


January 24, 2019
16.21 (19011700)
January 16, 2019
16.21 (19011500)
December 11, 2018
16.20 (18120801)
November 13, 2018
16.19 (18110915)
October 16, 2018
16.18 (18101400)
September 11, 2018
16.17 (18090901)
August 14, 2018
16.16 (18081201)
July 10, 2018
16.15 (18070902)
June 13, 2018
16.14.1 (18061302)
June 12, 2018
16.14.0 (18061000)
May 24, 2018
16.13.1 (18052304)
May 23, 2018
16.13.1 (18052203)
May 15, 2018
16.13.0 (18051301)
April 11, 2018
16.12.0 (18041000)
March 19, 2018
16.11.1 (18031900)
March 13, 2018
16.11.0 (18031100)
February 13, 2018
16.10.0 (18021001)
January 26, 2018
16.9.1 (18012504)
January 18, 2018
16.9.0 (18011602)
December 12, 2017
15.41.0 (17120500)
November 14, 2017
15.40.0 (17110800)
October 10, 2017
15.39.0 (17101000)
September 12, 2017
15.38.0 (17090200)
August 15, 2017
15.37.0 (17081500)
July 21, 2017
15.36.1 (17072101)
July 11, 2017
15.36.0 (17070200)
June 16, 2017
15.35.0 (17061600)
June 13, 2017
15.35.0 (17061000)
May 16, 2017
15.34.0 (17051500)
April 11, 2017
15.33.0 (17040900)
March 14, 2017
15.32.0 (17030901)
February 16, 2017
15.31.0 (17021600)
January 11, 2017
15.30.0 (17010700)

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.

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.