O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

  1. Click the table or query you want to analyze.

  2. Click the External ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required