内容简介
TheultimatehandbookforExcelanalystswhoneedreportingsolutionsusingAccessExcelandAccessareintendedtoworktogether.ThisbookoffersacomprehensivereviewoftheextensiveanalyticalandreportingfunctionalitythatAccessprovidesandhowitenhancesExcelreportingfunctions.Salesmanagers,operationsanalysts,administrativeassistants,officemanagers,andmanyotherswhorelyheavilyondatacanbenefitfromlearningtointegrateExcelandAccess,andthisbookshowsyouhow.*GainproductivitybyusingAccessasyourdatabaseratherthanExcel*Enhanceyouranalyticstool-setbyincorporatingAccessfunctionality*LeverageAccesstoautomatethecollection,shapingandcrunchingofimpossibleamountsofdata*MovedataeasilybetweenExcelandAccess*StartreportingAccessdatausingExcel'spresentationlayer*SaveitemandincreaseproductivitybyautomatingyourprocessesthroughintegrationofExcelandAccess*UseVBA,ADO,andSQLtomovedatafromoneapplicationtotheother*IntegrateExcelintootherOfficeapplicationsTheExcelAnalyst'sGuidetoAccesshelpsyougetmorefrombothapplications.