I want to use a Microsoft Access 2007 database on my Mac. However, it appears that Office 2008 for Mac does not have an equivalent to Microsoft Access. I'm new the Mac so can anybody suggest a easy to use alternative to Microsoft Access, preferably something that can import/migrate the existing data.
Thanks a lot.
FileMaker Pro would be your best bet. It's powerful, easy to user and mature.
Check out their website.
OpenOffice.org Base. Its free and cross-platform (windows, mac, linux).
You don't say what you need from a database, so it's hard to predict what product would work for you. I use Bento and think it's pretty good.
I'm not sure if this is even possible with Access 2007 (or 2010 Beta), but I would like information on ways to make a project with forms, macros and modules accessible via the Web.
Any good links or books would be appreciated.
A starting point on what to expect in A2010 is the Access development team's blog.
Also, go to Google Groups and enter this search:
albert kallal 2010 sharepoint group:*access*
Albert is a poster here on SO, but he's been a beta tester for A2010 and has a very good idea of what's possible web-wise. It's a pretty amazing set of features, quite a technical accomplishment by Microsoft, seems to me.
The point is that in conjunction with Sharepoint 2010, an Access app using web forms and web reports (a new object type in A2010) will run identically in the web browser via Sharepoint 2010's Access services and in client Access running on the desktop. These new features allow you to use Access to create an app that is accessible via the web browser, something that was previously impossible in any meaningful sense.
The ability to create, modify, or import data access pages is no longer supported in Microsoft Office Access 2007. See http://office.microsoft.com/en-us/access/HA100308321033.aspx