Lesson 11.5. Analyzing Records with Microsoft Excel
Figure 11-10. The results of a Microsoft Access query exported to a Microsoft Excel spreadsheet.
Access is capable of performing calculations on groups of records, but it can't hold a candle to its Microsoft Office 2003 counterpart, Microsoft Excel, when it comes to number crunching. An Excel spreadsheet is similar to an Access datasheet in many ways, with one important difference. Not only can you enter information in an Excel spreadsheet, but you can also easily add formulas directly into the spreadsheet gridsomething you can't do in Access. It makes sense, then, that more people use Excel together with Access than any other program.
In this lesson you will learn how to create a Microsoft Excel spreadsheet based on an Access query.