Welcome to Apple Discussions
Microsoft does not make a Mac version of Access. You could use Boot Camp to create a Windows partition & install Windows & a PC version of Office. This would require restarting in Windows whenever you want to use Windows. Or use Parallels or VMWare Fusion to create a virtual PC & again install Windows & PC Office. I prefer using
Crossover Mac which does not involve installing Windows. I have Office 2007 installed in Crossover to run Publisher when someone sends me a Publisher file. Unlike Boot Camp, Parallels or VMWare Fusion, Crossover doesn't support all Windows programs, but it definitely supports Office.