Software Tips Home

How To Export Data from Microsoft Access 2007 to Microsoft Excel

1. Open the database you wish to export data from in Microsoft Access 2007
2. Using the navigation pane, select the table, report, form or query that you wish to export.
3. Choose the External Data tab on the Ribbon.
4. Click the Excel button in the Export section of the External Data tab.
5. Provide an export file name and select the Excel format you would like to use for your export.
6. Click OK to begin the export.

Make it easy to use an Access database by automatically displaying a form when the database is opened.  Access 2007 has made this process easier than ever before.  Here’s how:

• Open the database and click the Office Button
• Click the Access Options button at the bottom of the menu
• Click Current Database on the left pane
• Under Application Options click the Display form drop-down and choose the form you want user to see when they open the database
• Click OK