• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Analyzing Data with Microsoft Access

Chapter 5. Analyzing Data with Microsoft Access

As you’ve discovered over the last couple of chapters, Microsoft Excel is a great software application for analyzing data, especially lists of nonrelational data that comprise a few data rows or up to tens of thousands of data rows. Microsoft Access, however, is better able to handle the creation, storage, and analysis of relational data and is better suited to situations in which data is entered by multiple users at the same time and for large data sources that are several hundred megabytes or larger in size.

Access includes tools and features for sorting, filtering, and querying data. Access also includes a report writer that you can use to present visually compelling reports that group data and calculate totals and trends. In Access 2002, PivotTable views and PivotChart views allow you to bring the powerful data analysis features of PivotTable reports and PivotChart reports to the work you do in Access. Also, Access easily integrates with data stored in Microsoft SQL Server 2000 and provides tools for accessing data over the Web.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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