Not really, no. Microsoft, for whatever reason, has never seen fit to port Access to Mac OS (X). So you're stuck with either installing Windows as a dual boot option a la Boot Camp, or using something like Parallels or VMWare Fusion which runs Windows inside a VM.
You could always try something like WineX, but I would not get my hopes up about it working, and be prepared to spend at least a few hours scouring message boards and what not to figure out how to set it up.
One other possibility, is to use an ODBC (Open Database Connection) setup. If you can have Access running on a Windows box, and then set up ODBC, you could, in theory at least, use some alternate interface to interact with and manipulate the Access database. There may very well be something of a niche market out there for this sort of thing that has been filled by someone if you just look.
I need to run Microsoft Access on my Mac OS X (version 10.6.8). I spoke to an Apple rep, and he said I need to purchase Windows OS ($199.99) and MS Access ($139.99), and then either stick to my current app, Bootcamp or purchase the Fushion app, which will run the MS Access from both Mac/Windows OS. This seems a bit convoluted. Is there an easier way around this?
Any guidance is much appreciated!