How to Format an Access Report in Excel

It is easy to exchange information between Microsoft Office programs.

One of the hallmarks of the Microsoft Office suite of products is that it is so easy to share data between programs and transfer data from one program to another. For instance, users can create a report in Microsoft Access, export the data to Microsoft Excel and save the results to a text file that can be uploaded to a Microsoft Word mail merge document. This information sharing greatly enhances the usefulness of all the programs that make up the Microsoft Office suite.

Instructions

1. Log on to your computer and open Microsoft Access. Open the database you want to work with and go to the reports section.

2. Right-click on the report and choose "Export" from the list. Choose "Microsoft Excel" from the "Save as Type" drop-down box.

3. Browse to the location where the exported information should be saved and click "Export." Close Microsoft Access and open Microsoft Excel.

4. Browse to the location where the extracted information was saved and open the Microsoft Excel document. Highlight the entire spreadsheet by clicking in the upper left-hand corner.

5. Click the "Format" menu and choose "Cells" from the list. Click the "Border" tab and highlight the "Outline" and "Inside" options. This will draw a line around each of the cells and make the report data easier to read.

References

• Microsoft Support: Export Data to Excel