Retrieving and Analyzing Data

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Nearly any solution that stores data also needs to retrieve, analyze, and present the data in a manner that makes it easy to understand. Although there are quick and simple ways to present data, such as in a Microsoft Access report, you may need to design a custom reporting component for your application if you want to create flexible or dynamic reports. There are so many ways to retrieve data and create reports that deciding on the best format for a report can be a challenging task. This chapter discusses some of the options available to you for creating reports in Microsoft Office solutions.

Contents

Retrieving Data from a Data Source

Presenting Data in Office Solutions

Sorting and Filtering Data

Working with PivotTable and PivotChart Reports

Where to Go from Here