Analyzing Data with Microsoft Excel
Each of the programs in the Microsoft Office 2007 suite has its particular strengths, but Excel and Access have a lot of similarities. Both programs handle data lists well, but where Excel shines at summarizing data using an incredible variety of calculations and formulas, Access enables you to create powerful queries to draw exactly the data you need from your tables.
If you have a table or query that contains exactly the data you want to analyze and summarize in Excel, using summary functions and operations not readily available in Access, step through the following procedure to bring the power of Excel to bear on your data.
Analyze Data in Excel
Click the table or query you want to analyze.
Click the External ...
Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
