Data Analysis with Microsoft Access 2010: From Simple Queries to Business Intelligence

Rather than emphasizing the mechanics, forms or report modules within Microsoft Access, DATA ANALYSIS WITH MICROSOFT ACCESS 2010: FROM SIMPLE QUERIES TO BUSINESS INTELLIGENCE focuses on data retrieval and how you can transform data into structures useful for a true understanding of the data. The author broadens the concept of data analysis to encompass Business Intelligence (BI) concepts. To help you most effectively utilize Access, the book focuses on the GUI (graphical user interface) that Microsoft Access uses to create queries. You examine underlying SQL concepts as they relate to Access queries. The book also emphasizes tables, while coverage of forms, reports and macros is addressed only briefly in an optional appendix. You also become familiar with various approaches to data analysis as you learn how Access relates to other tools, such as Microsoft Excel.