• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Analyzing Data in Excel

Before you can analyze Access data in a workbook, you must convert it to an Excel file. You can either use the Analyze It With MS Excel command in Access to export data as an Excel table file or use the PivotTable And PivotChart Report wizard in Excel to use the Access data as a PivotTable, a table you can use to perform calculations with or rearrange large amounts of data. Once you determine what fields and criteria you want to use to summarize the data and how you want the resulting table to look, the wizard does the rest. You can also copy and paste or drag Access database objects (tables, queries, and so on) from the Database window to an Excel worksheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint