Soggy,
There is no Mac version of Access, as you have probably found out by now. The easiest way might be to get an emulator, such as
Parallels for the occasions where you need to use Access. You could also consider
Bootcamp if you are using Access a lot, where dual booting is perhaps more worthwhile.
There is an interesting article
here about connecting to and using Access databases on the Mac. It is possible, but you need the right software (detailed in the article).
Applemacster