{"product_id":"9780470567012","title":"The Excel Analyst's Guide to Access","description":"\u003ch1\u003eThe Excel Analyst's Guide to Access\u003c\/h1\u003e\u003ch3\u003eMichael Alexander\u003c\/h3\u003e\u003cdiv\u003e\u003cb\u003eComputers \/ Database Administration \u0026amp; Management\u003c\/b\u003e\u003c\/div\u003e\u003cbr\u003e\u003cdiv\u003e\n\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\n\u003c\/div\u003e\u003cdiv\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 \u003c\/div\u003e\u003cbr\u003e\u003ctable\u003e\n\u003ctr\u003e\n\u003ctd\u003ePublication Date: \u003c\/td\u003e\n\u003ctd\u003e05 April 2010\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003ePublisher: \u003c\/td\u003e\n\u003ctd\u003eWiley\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eImprint: \u003c\/td\u003e\n\u003ctd\u003eWiley\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eISBN-13: \u003c\/td\u003e\n\u003ctd\u003e9780470567012\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eFormat: \u003c\/td\u003e\n\u003ctd\u003ePaperback \/ softback\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003ePage Count: \u003c\/td\u003e\n\u003ctd\u003e624\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eWeight (oz): \u003c\/td\u003e\n\u003ctd\u003e36.8\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/table\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":44380010479756,"sku":"9780470567012","price":35.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0710\/9545\/1788\/files\/9780470567012_04c6586d-cb64-4558-bfc4-8e2a16a3a683.jpg?v=1780101773","url":"https:\/\/fh90cf-fv.myshopify.com\/products\/9780470567012","provider":"Late Knight Books and Services, LLC","version":"1.0","type":"link"}