Using Access database on Mac
Excel 2011 for Mac can execute SQL queries against Microsoft Access databases using Microsoft Query (comes with Microsoft Office) or a PivotTable, both of which require using ODBC.
You can return data to a table:
http://www.dummies.com/how-to/content/how-to-move-data-from-external-sources-into-excel-.html
or a PivotTable
http://www.dummies.com/how-to/content/how-to-make-a-pivottable-in-excel-for-mac-2011.html
Here's an ODBC driver that works with Microsoft Access:
http://www.actualtech.com/product_access.php
In case you are interested in other substitutes for Publisher, Visio, OneNote, FrontPage and Groove ....
Do a Google search 'open publisher files on mac'.
http://goo.gl/yVrsq
How to Open a Pub File on a Mac | eHow.com
http://www.ehow.com/how_4924781_open-pub-file-mac.html
One recommendation was to open them in InDesign, using Markzware's plugin but you might not have InDesign.
OmniGraffle Pro will open Visio files directly. http://forums.macrumors.com/showthread.php?t=1303892
OpenProj is a desktop replacement of Microsoft Project, project management software. OpenProj has equivalent functionality, a familiar user interface and even opens existing MSProject files.
http://www.macupdate.com/app/mac/29072/openproj
iTaskX is a full featured, MS Project compatible project management tool for Mac OS X
http://www.macupdate.com/app/mac/17130/itaskx
Microsoft SharePoint Workspace, previously known as Microsoft Office Groove, is a desktop application designed for document collaboration in teams with members who are regularly off-line or who do not share the same network security clearance.
http://sharepoint.microsoft.com/en-us/Pages/default.aspx
Dropbox is a file sharing solution that's free for 2GB of data. Dropbox is also cross platform.
Excel 2011 for Mac can execute SQL queries against Microsoft Access databases using Microsoft Query (comes with Microsoft Office) or a PivotTable, both of which require using ODBC.
You can return data to a table:
http://www.dummies.com/how-to/content/how-to-move-data-from-external-sources-into-excel-.html
or a PivotTable
http://www.dummies.com/how-to/content/how-to-make-a-pivottable-in-excel-for-mac-2011.html
Here's an ODBC driver that works with Microsoft Access:
http://www.actualtech.com/product_access.php
In case you are interested in other substitutes for Publisher, Visio, OneNote, FrontPage and Groove ....
Do a Google search 'open publisher files on mac'.
http://goo.gl/yVrsq
How to Open a Pub File on a Mac | eHow.com
http://www.ehow.com/how_4924781_open-pub-file-mac.html
One recommendation was to open them in InDesign, using Markzware's plugin but you might not have InDesign.
OmniGraffle Pro will open Visio files directly. http://forums.macrumors.com/showthread.php?t=1303892
OpenProj is a desktop replacement of Microsoft Project, project management software. OpenProj has equivalent functionality, a familiar user interface and even opens existing MSProject files.
http://www.macupdate.com/app/mac/29072/openproj
iTaskX is a full featured, MS Project compatible project management tool for Mac OS X
http://www.macupdate.com/app/mac/17130/itaskx
Microsoft SharePoint Workspace, previously known as Microsoft Office Groove, is a desktop application designed for document collaboration in teams with members who are regularly off-line or who do not share the same network security clearance.
http://sharepoint.microsoft.com/en-us/Pages/default.aspx
Dropbox is a file sharing solution that's free for 2GB of data. Dropbox is also cross platform.
![Mac Mac](/uploads/1/2/5/3/125377231/651069486.jpg)
Dynamodb Database Query Tool For Mac Os X 10.6.8
RazorSQL Database GUI Tool for Amazon DynamoDB. RazorSQL now supports Amazon DynamoDB databases, giving users the ability to connect, query, browse, and manage Amazon DynamoDB databases via the RazorSQL desktop GUI available for Mac OS X, Windows, Linux, and Solaris.