The Excel Analyst's Guide to Access - Brossura

Alexander, Michael

Brossura

ISBN 10: 0470567015 ISBN 13: 9780470567012

Casa editrice: Wiley, 2010

Riassunto

Provides information on the features and functions of Microsoft Access, covering such topics as normalizing and storing Excel data in a structured relational database, using Excel pivot tables with Access data, using Access to analyze large amounts of data, and getting external data with SQL, ADO, and XML.

Su questo libro

Informazioni sull?autore

Michael Alexander is a Microsoft MVP and a veteran consultant. He creates and shares video tutorials with the Microsoft Excel and Access communities via www.datapigtechnologies.com. Mike has written several books on advanced business analysis, including Microsoft Access 2007 Data Analysis, also from Wiley.

Dalla quarta di copertina

Use the right tool for the job

Like many managers, accountants, and analysts, you've been usingExcel for data analysis. It's a good tool, but you're beginning tofind its limitations frustrating. You're looking for morescalability. More transparency of analytical processes. The abilityto separate data from presentation.

Access makes it all possible, and this guide helps you addAccess to your analytical toolbox. Learn the essentials of usingAccess, basic and advanced analysis techniques, how to buildreports, and much more. Then you can choose the right tool forevery job.

• Easily move data between Excel and Access

• Normalize and store Excel data in a structured relationaldatabase

• Use Access to analyze large amounts of data

• Use Excel pivot tables with Access data

• Build reports and implement dashboard-style visualizations

• Report Access data using Excel's presentation layer

• Automate redundant reporting and analysis using Excel and Accessmacros

• Save time and increase productivity by automating redundantprocesses using VBA

• Get external data using SQL, ADO, and XML

Dettagli dell'edizione

• Editore: Wiley
• Data di pubblicazione: 2010
• Lingua: Inglese
• ISBN 10: 0470567015
• ISBN 13: 9780470567012
• Rilegatura: Copertina flessibile
• Numero di pagine: 624
• Contatto del produttore: non disponibile
• Persona responsabile: non disponibile