There is already (and has been for years) a Microsoft Office for Mac (latest version: Office 2008) that runs natively on Mac OS.
Access is not offered on the Mac version of Office, but if you wish to run it (or, for whatever reason, the entire Office/Win suite) you can install Windows under VMWare Fusion on the Mac. Then, using the “invisible” VM option, you can run it just as if it *were* a Mac-native app.
And yes, it would be transferable, because essentially you would *be* programming it on a Windows PC.
That said, I and a billion other people would really appreciate it if you would choose to write DB apps in something other than that buggy POS that is Access. 4D, FileMaker, and mySQL come to mind. :D
If you have never tried the iWorks..look at it ..love it..much nicer that Word..but in a world of Microsoft word..I have both!
Access was a front end to DB that was spun off as a standalone product.
It is a POS IMHO also.
Why mess around with Access? Filemaker is made by Apple and is completely cross-platform compatible. In otherwords, you can use the program and the data files on both the Windows and Apple system.