1. Home
  2. MS Office

MS Access 2010: Analyzing Reports With Excel

Undoubtedly Excel is one of the best tool that features; calculations, graphing tools, pivot tables and much more. Analyzing reports with Excel 2010 would be very beneficial, if you want to perform different calculations over Access generated reports. Analyzing report data requires a very simple process to follow.

Open Access 2010, and view the report in Print Preview to take a generic look at the whole report.

Now Navigate to Print Preview tab and click Excel button.

excel preview

Export Wizard dialog will appear, asking for specify the destination file name and format. In Export Options enable Open the destination File to view report immediately in Excel. Click OK.

Export wizard1

Excel Sheet will open and show the report data in columns and rows.

excel analyze

To take the best view of it, customize cell spacing, width and length. Select all the cells to draw borders around them.


Leave a comment