Tutorial: Query Microsoft Access Tables using Excel for Mac
Part 1 - Overview

By Jim Gordon, co-author of
Office 2011 for Mac All-in-One For Dummies

Mac users have several options for using Microsoft Access on their Macs.

Microsoft Office for Mac can do the following with Microsoft Access ACCDB and MDB files:

Limitations of Office for Mac with Microsoft Access

I need all Access features. Can I run Microsoft Access on my Mac? Yes!

Microsoft Access 2016 is available as a stand-alone product. You will need to have Microsoft Windows installed on your Mac either in Apple's Boot-Camp or in a virtual machine (Parallels or VMware). Using a virtual machine allows you to run Wndows and Windows applications simultaneously with your Mac OS apps. I recommend at least 16 gigabytes of RAM for running a virtual machine on your Mac.
  Click here to purchase Microsoft Access 2016 stand-alone edition from the Microsoft store
  Click here to purchase Microsoft Windows 10 from Amazon.com
  Click here to purchase Parallels Desktop virtual machine from Amazon.com.


This tutorial explains how to query Microsoft Access tables using Excel for Mac.

Jim Gordon's MVP Home