{"product_id":"the-excel-analysts-guide-to-access-isbn-9780470567012","title":"The Excel Analyst's Guide to Access","description":"\u003cp\u003e\u003cb\u003eThe ultimate handbook for Excel analysts who need reporting solutions using Access\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExcel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances Excel reporting functions.\u003c\/p\u003e \u003cp\u003eSales managers, operations analysts, administrative assistants, office managers, and many others who rely heavily on data can benefit from learning to integrate Excel and Access, and this book shows you how.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCoverage includes:\u003c\/b\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eData Analysis in Access \u0026amp; the Basics of Access\u003c\/li\u003e \u003cli\u003eBeyond Select Queries\u003c\/li\u003e \u003cli\u003eTransforming Your Data with Access\u003c\/li\u003e \u003cli\u003eWorking with Calculations and Dates\u003c\/li\u003e \u003cli\u003ePerforming Conditional Analysis\u003c\/li\u003e \u003cli\u003eAdding Dimension with Subqueries and Domain Aggregate Functions\u003c\/li\u003e \u003cli\u003eRunning Descriptive Statistics in Access\u003c\/li\u003e \u003cli\u003eScheduling and Running Batch Analysis\u003c\/li\u003e \u003cli\u003eLeveraging VBA to Enhance Data Analysis\u003c\/li\u003e \u003cli\u003eReports, Dashboards, and Visualization in Access\u003c\/li\u003e \u003cli\u003ePresenting Data with Access Reports\u003c\/li\u003e \u003cli\u003eUsing Pivot Tables and Pivot Charts in Access\u003c\/li\u003e \u003cli\u003eEnhancing Queries and Reports with Visualizations\u003c\/li\u003e \u003cli\u003eAdvanced Excel and Access Integration Techniques\u003c\/li\u003e \u003cli\u003eGetting Access Data into Excel\u003c\/li\u003e \u003cli\u003eUsing VBA to Move Data between Excel and Access\u003c\/li\u003e \u003cli\u003eExploring Excel and Access Automation\u003c\/li\u003e \u003cli\u003eIntegrating Excel and Access with XML\u003c\/li\u003e \u003cli\u003eIntegrating Excel and Other Office Applications\u003c\/li\u003e \u003cli\u003eAccess VBA Fundamentals\u003c\/li\u003e \u003cli\u003eUnderstanding and Using SQL\u003c\/li\u003e \u003cli\u003eand more!\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eThe Excel Analyst's Guide to Access helps you get more from both applications.\u003c\/i\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eNote:\u003c\/b\u003e CD-ROM\/DVD and other supplementary materials are not included as part of eBook file.\u003c\/p\u003e \u003cp\u003eIntroduction xxix\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I Fundamentals of Data Analysis in Access 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1 The Case for Data Analysis in Access 3\u003c\/p\u003e \u003cp\u003eChapter 2 Access Basics 13\u003c\/p\u003e \u003cp\u003eChapter 3 Beyond Select Queries 47\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II Basic Analysis Techniques 87\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 4 Transforming Your Data with Access 89\u003c\/p\u003e \u003cp\u003eChapter 5 Working with Calculations and Dates 113\u003c\/p\u003e \u003cp\u003eChapter 6 Performing Conditional Analysis 141\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III Advanced Analysis Techniques 161\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 7 Adding Dimension with Subqueries and Domain Aggregate Functions 163\u003c\/p\u003e \u003cp\u003eChapter 8 Running Descriptive Statistics in Access 189\u003c\/p\u003e \u003cp\u003eChapter 9 Scheduling and Running Batch Analysis 209\u003c\/p\u003e \u003cp\u003eChapter 10 Leveraging VBA to Enhance Data Analysis 243\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV Reports, Dashboards, and Visualization in Access 267\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 11 Presenting Data with Access Reports 269\u003c\/p\u003e \u003cp\u003eChapter 12 Using Pivot Tables and Pivot Charts in Access 291\u003c\/p\u003e \u003cp\u003eChapter 13 Enhancing Queries and Reports with Visualizations 323\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V Advanced Excel and Access Integration Techniques 345\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 14 Getting Access Data into Excel 347\u003c\/p\u003e \u003cp\u003eChapter 15 Using VBA to Move Data between Excel and Access 365\u003c\/p\u003e \u003cp\u003eChapter 16 Exploring Excel and Access Automation 389\u003c\/p\u003e \u003cp\u003eChapter 17 Integrating Excel and Access with XML 423\u003c\/p\u003e \u003cp\u003eChapter 18 Integrating Excel and Other Office Applications 441\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI Appendixes 475\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix A Access VBA Fundamentals 477\u003c\/p\u003e \u003cp\u003eAppendix B Understanding and Using SQL 489\u003c\/p\u003e \u003cp\u003eAppendix C Query Performance, Database Corruption, and Other Thoughts 509\u003c\/p\u003e \u003cp\u003eAppendix D Data Analyst’s Function Reference 521\u003c\/p\u003e \u003cp\u003eIndex 563\u003c\/p\u003e \u003cp\u003eMichael 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.\u003c\/p\u003e   \u003cp\u003eUse the right tool for the job\u003c\/p\u003e \u003cp\u003eLike many managers, accountants, and analysts, you've been using Excel for data analysis. It's a good tool, but you're beginning to find its limitations frustrating. You're looking for more scalability. More transparency of analytical processes. The ability to separate data from presentation.\u003c\/p\u003e \u003cp\u003eAccess makes it all possible, and this guide helps you add Access to your analytical toolbox. Learn the essentials of using Access, basic and advanced analysis techniques, how to build reports, and much more. Then you can choose the right tool for every job.\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eEasily move data between Excel and Access\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eNormalize and store Excel data in a structured relational database\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eUse Access to analyze large amounts of data\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eUse Excel pivot tables with Access data\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eBuild reports and implement dashboard-style visualizations\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eReport Access data using Excel's presentation layer\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eAutomate redundant reporting and analysis using Excel and Access macros\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eSave time and increase productivity by automating redundant processes using VBA\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eGet external data using SQL, ADO, and XML\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47990224453861,"sku":"NP9780470567012","price":39.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780470567012.jpg?v=1761786975","url":"https:\/\/k12savings.com\/es\/products\/the-excel-analysts-guide-to-access-isbn-9780470567012","provider":"K12savings","version":"1.0","type":"link"}