The Excel Analyst's Guide to Access

628 Pages·2010·9.03 MB·English

by  Michael Alexander

The Excel® Analyst’s
Guide to Access®

®
The Excel Analyst’s
®
Guide to Access
Michael Alexander
Wiley Publishing, Inc.
® ®
TheExcel Analyst’sGuidetoAccess
Publishedby
WileyPublishing,Inc.
10475CrosspointBoulevard
Indianapolis,IN46256
www.wiley.com
Copyright©2010byWileyPublishing,Inc.,Indianapolis,Indiana
PublishedsimultaneouslyinCanada
ISBN:978-0-470-56701-2
ManufacturedintheUnitedStatesofAmerica
10987654321
Nopartofthispublicationmaybereproduced,storedinaretrievalsystemortransmittedinanyformorbyanymeans,
electronic,mechanical,photocopying,recording,scanningorotherwise,exceptaspermittedunderSections107or108
ofthe1976UnitedStatesCopyrightAct,withouteitherthepriorwrittenpermissionofthePublisher,orauthorization
throughpaymentoftheappropriateper-copyfeetotheCopyrightClearanceCenter,222RosewoodDrive,Danvers,
MA 01923, [phone], fax [phone]. Requests to the Publisher for permission should be addressed to the
PermissionsDepartment,JohnWiley&Sons,Inc.,111RiverStreet,Hoboken,NJ07030,[phone],fax[phone],
oronlineathttp://www.wiley.com/go/permissions.
LimitofLiability/DisclaimerofWarranty:Thepublisherandtheauthormakenorepresentationsorwarrantieswith
respecttotheaccuracyorcompletenessofthecontentsofthisworkandspecificallydisclaimallwarranties,including
withoutlimitationwarrantiesoffitnessforaparticularpurpose.Nowarrantymaybecreatedorextendedbysalesor
promotionalmaterials.Theadviceandstrategiescontainedhereinmaynotbesuitableforeverysituation.Thiswork
issoldwiththeunderstandingthatthepublisherisnotengagedinrenderinglegal,accounting,orotherprofessional
services.Ifprofessionalassistanceisrequired,theservicesofacompetentprofessionalpersonshouldbesought.Neither
thepublishernortheauthorshallbeliablefordamagesarisingherefrom.ThefactthatanorganizationorWebsiteis
referredtointhisworkasacitationand/orapotentialsourceoffurtherinformationdoesnotmeanthattheauthororthe
publisherendorsestheinformationtheorganizationorWebsitemayprovideorrecommendationsitmaymake.Further,
readersshouldbeawarethatInternetWebsiteslistedinthisworkmayhavechangedordisappearedbetweenwhenthis
workwaswrittenandwhenitisread.
ForgeneralinformationonourotherproductsandservicespleasecontactourCustomerCareDepartmentwithinthe
UnitedStatesat(877)762-2974,outsidetheUnitedStatesat(317)572-3993orfax(317)572-4002.
Wileyalsopublishesitsbooksinavarietyofelectronicformats.Somecontentthatappearsinprintmaynotbeavailable
inelectronicbooks.
LibraryofCongressControlNumber:2010922044
Trademarks:WileyandtheWileylogoaretrademarksorregisteredtrademarksofJohnWiley&Sons,Inc.and/orits
affiliates,intheUnitedStatesandothercountries,andmaynotbeusedwithoutwrittenpermission.ExcelandAccess
areregisteredtrademarksofMicrosoftCorporationintheUnitedStatesand/orothercountries.Allothertrademarksare
thepropertyoftheirrespectiveowners.WileyPublishing,Inc.isnotassociatedwithanyproductorvendormentioned
inthisbook.
This is dedicated to the fans of DataPigTechnologies.com ...
all 12 of you.

About the Author
MikeAlexanderisaMicrosoftCertifiedApplicationDeveloper(MCAD)and
authorofseveralbooksonadvancedbusinessanalysiswithMicrosoftAccess
and Excel. He has more than 15 years experience consulting and developing
Office solutions. Michael has been named a Microsoft MVP for his ongoing
contributionstotheExcelcommunity.
Inhissparetimeherunsafreetutorialsite,www.datapigtechnologies.com,
wherehesharesbasicAccessandExceltipstotheOfficecommunity.
vii