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.
Click the table or query you want to analyze.
Click the External ...