Microsoft Access 2010 is brilliant when it comes to exporting data to other applications offering many file formats…
Exporting data from Microsoft Access 2010 & 2007 is even easier than previous versions as it firstly provides an easy to view Ribbon Bar (External Data tab) displaying clear icons for different file formats and secondly being able to save your export actions for re-use.
I personally like the ability to now export to a PDF file which is also mentioned in this video tutorial as well as easily setup a connection to SharePoint services for publishing over either a network or the internet.
Emailing (as attachments) is a breeze too with a single click of a button locating your default email editor. If your have to export data to an unusual file or system, you can always investigate the ODBC Database option (found under the More drop-down icon).
Finally, this video tutorial clearly highlights working the relationship between Microsoft Access and Microsoft Excel (which the majoirty will have available) taking advantage of the rich set of tools Excel provides.
I welcome your comments below – perhaps you may know of a shortcut to export data in Microsoft Access!