How can I get Microsoft Access on my MacBook Pro?

You can install Windows on a Intel Mac using either Bootcamp or Virtualization engines (Parallels, VMware Fusion or VirtualBox) and then install MS Access.

If you have an Apple Mac with Apple M1 CPU, currently Windows is not supported.