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.
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.
Excel Sheet will open and show the report data in columns and rows.
To take the best view of it, customize cell spacing, width and length. Select all the cells to draw borders around them.