• Microsoft Access 2007 Data Analysis See large image

    Microsoft Access 2007 Data Analysis (Paperback) By (author) Michael Alexander

    $28.02 - Save $15.75 35% off - RRP $43.77 Free delivery worldwide Available
    Dispatched in 4 business days
    When will my order arrive?
    Add to basket | Add to wishlist |

    DescriptionChart a course for more effective data analysis with Access 2007. With this resource, you'll learn how Access 2007 offers powerful functionality that may be better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful ways, quickly and easily slice it into various views, automate redundant analysis, and save time-all using Access. If you know a bit about table structures and formulas as well as data analysis, start thinking outside the chart.


Other books

Other people who viewed this bought | Other books in this category
Showing items 1 to 10 of 10

 

Reviews | Bibliographic data
  • Full bibliographic data for Microsoft Access 2007 Data Analysis

    Title
    Microsoft Access 2007 Data Analysis
    Authors and contributors
    By (author) Michael Alexander
    Physical properties
    Format: Paperback
    Number of pages: 552
    Width: 183 mm
    Height: 234 mm
    Thickness: 33 mm
    Weight: 726 g
    Language
    English
    ISBN
    ISBN 13: 9780470104859
    ISBN 10: 0470104856
    Classifications

    BIC E4L: COM
    Nielsen BookScan Product Class 3: S10.2
    B&T Book Type: NF
    B&T Modifier: Region of Publication: 01
    B&T Modifier: Subject Development: 20
    B&T Modifier: Academic Level: 01
    B&T Modifier: Text Format: 01
    LC subject heading:
    B&T Merchandise Category: COM
    Warengruppen-Systematik des deutschen Buchhandels: 26350
    DC22: 005.7565
    LC subject heading: ,
    BIC subject category V2: UNSC
    Ingram Subject Code: XD
    Libri: I-XD
    BISAC V2.8: COM021000
    B&T General Subject: 228
    LC subject heading:
    DC22: 005.75/65
    BISAC V2.8: COM084010
    LC classification: QA76.9.D3 A4945 2007
    Thema V1.0: UNS
    Illustrations note
    Illustrations
    Publisher
    John Wiley and Sons Ltd
    Imprint name
    John Wiley & Sons Ltd
    Publication date
    26 March 2007
    Publication City/Country
    Chichester
    Author Information
    Michael Alexander is a Microsoft Certified Application Developer (MCAD) with more than thirteen years of experience consulting and developing office solutions. He currently serves as the director of an analytical services department for a $700 million company. He also runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips with intermediate users.
    Back cover copy
    Chart a course for more effective data analysisData analysis is more than crunching numbers and turning them into charts and graphs. Certainly Excel can do that, but you may be surprised to discover that Access 2007 offers powerful functionality that may be even better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful ways, quickly and easily slice it into various views, automate redundant analysis, and save time, all using Access. If you know a bit about table structures and formulas as well as data analysis, start thinking outside the chart.Apply Access 2007 to the task of collecting, transforming, analyzing, and presenting dataCreate custom functions, perform batch analysis, and develop automated procedures that essentially run themselvesBuild effective query skillsLearn to clean and shape raw data, create and utilize custom calculations, work with dates, and perform advanced time analysisWork with SQL statements, PivotTables, and PivotChartsPerform advanced statistical analysis using subqueries and domain aggregate functionsSee how to use macros and Visual Basic(R) for Applications to enhance data analysisCompanion web siteFind all the examples from the book in the sample database located at www.wiley.com/go/access2007dataanalysis
    Table of contents
    About the Author. Acknowledgments. Introduction. Part I Fundamentals of Data Analysis in Access. Chapter 1 The Case for Data Analysis in Access. Chapter 2 Access Basics. Chapter 3 Beyond Select Queries. Part II Basic Analysis Techniques. Chapter 4 Transforming Your Data with Access. Chapter 5 Working with Calculations and Dates. Chapter 6 Performing Conditional Analysis. Part III Advanced Analysis Techniques. Chapter 7 Understanding and Using SQL. Chapter 8 Subqueries and Domain Aggregate Functions. Chapter 9 Running Descriptive Statistics in Access. Chapter 10 Analyzing Data with Pivot Tables and Pivot Charts. Part IV Automating Data Analysis. Chapter 11 Scheduling and Running Batch Analysis. Chapter 12 Leveraging VBA to Enhance Data Analysis. Chapter 13 Query Performance, Database Corruption, and Other Final Thoughts. Part V Appendixes. Appendix A Data Analyst's Function Reference. Appendix B Access VBA Fundamentals. Appendix C Error Message Reference. Index.