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

DATAANALYSISWITHMICROSOFTACCESS2010isanintroductiontoAccesswithanemphasisontopicsrelevanttodataanalysis.Thegoalistohelptheanalystgainatrueunderstandingofdataandtheinformationitcontains.Accessqueriesarecoveredindetail,bothintermsofthemechanicsoftheirdesign,andhowtheycanbeusedfortypicaldataanalysistasks.Thebookiswritteninaneasy-to-understandtutorialstyle,withnewtopicsintroducedinalogicalandintuitivesequence.Numerousscreenshotsareincluded,soyouwon'tneedtositwithacomputerasyoureadthebook.Theauthoralsobroadenstheconceptofdataanalysistoencompassbusinessintelligence(BI)topics,includingvaluablematerialonhowtouseAccessandExcelpivottables.Additionalfeaturesinclude"SeetheSQL"sidebarsthatallowinterestedreaderstolearnSQLastheyarelearningAccess,and"FocusonAnalysis"sidebarsthatprovidedetailsonanumberofusefulquantitativetopics.AcompanionwebsitehasasampledatabasethatcorrelateswiththeBImaterialinthebook.Inshort,thisistheonlybookyou'llneedtogainaworkingknowledgeofAccess,andhowitcanbeusedfordataanalysis.