Microsoft Office 2000/Visual Basic Programmer's
Guide
Retrieving and Analyzing Data
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