You could use Boot Camp of course but that wouldn't be too fun for rebooting the system in the other OS.
So your best bets are VMware Fusion, or Parallels, for running a Windows OS and using Access in it. Then just copy and paste and drag and drop and whatnot if you want to store the file primarily on Mac.
Blame Microsfot for not making Access really available on other than their own OS...