Table Basics

If you’re new to Microsoft Access, you’ll need to learn the basics of working with tables so that you can open, navigate, add information, and edit them. To Open an Existing Table: Open your database and locate the Navigation Pane. In the Navigation Pane, locate the table you would like to open. Tables are marked with the  icon. Double-click the…

Read More

Output to PDF

Outputting your reports to PDF can help you when it comes to sharing with others who do not have Access 2010. Luckily, Microsoft decided to integrate this feature into Access 2010. To perform the task, go to the menu and select File, followed by Save & Publish. Under File Types, click Save Object As. Next,…

Read More

Quickly Share Reports With Non-Access Users

Want to share a report with someone who does not have access to your application? It’s easy to do in Access 2010. From the Navigation Pane (as shown), right click on the report you want to share and click “Export.” Select the file format you want to save in‚ÄîExcel, PDF, HTML or other format. What’s…

Read More

How To Export Data from Microsoft Access 2007 to Microsoft Excel

Open the database you wish to export data from in Microsoft Access 2007 Using the navigation pane, select the table, report, form or query that you wish to export. Choose the External Data tab on the Ribbon. Click the Excel button in the Export section of the External Data tab. Provide an export file name…

Read More