Microsoft Access Small Business Solutions: State-of-the-Art Database Models for Sales, Marketing

915 Pages·2010·15.85 MB·English

by  Hennig, Teresa

How to go to your page

This eBook includes bonus material. In the printed version of the book,
the bonus chapters are paginated separately from the main body of the
book. To avoid duplicate page numbers in the electronic version, we
have inserted the designation “BC” before the page numbers in the bonus
chapters..

For example, to go to page 5 of the bonus material, type BC5 in the
“page #” box at the top of the screen and click “Go.” To go to page 25 of
the bonus material, type BC25… and so forth.

Microsoft® Access®
Small Business Solutions

® ®
Microsoft Access
Small Business Solutions
State-of-the-Art Database Models for
Sales, Marketing, Customer
Management, and More Key
Business Activities
Teresa Hennig, Truitt Bradly,
Larry Linson, Leigh Purvis,
Brent Spaulding
Wiley Publishing, Inc.
Disclaimer: This eBook does not include ancillary media that was packaged with the
printed version of the book.
® ®
Microsoft Access Small Business Solutions: State-of-the-Art Database Models for Sales, Marketing, Customer
Management,andMoreKeyBusinessActivities
Publishedby
WileyPublishing,Inc.
10475CrosspointBoulevard
Indianapolis,IN46256
www.wiley.com
Copyright© 2010byWileyPublishing,Inc.,Indianapolis,Indiana
PublishedsimultaneouslyinCanada
ISBN:978-0-470-52574-6
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:2009939784
Trademarks:WileyandtheWileylogoaretrademarksorregisteredtrademarksofJohnWiley&Sons,Inc.and/orits
affiliates,intheUnitedStatesandothercountries,andmaynotbeusedwithoutwrittenpermission.MicrosoftandAccess
areregisteredtrademarksofMicrosoftCorporationintheUnitedStatesand/orothercountries.Allothertrademarksare
thepropertyoftheirrespectiveowners.WileyPublishing,Inc.isnotassociatedwithanyproductorvendormentioned
inthisbook.
To my parents ... whose lives have inspired me to enjoy and make the
most of life’s challenges and opportunities, and to find joy in sharing with
others. Momma’s radiant smile will light up a room, and her friendly,
positive attitude brings happiness to everyone around her. Papa
exemplifies the principles to live by: to be good to your neighbors and to
have respect for yourself and others. He is ‘‘the salt of the earth,’’
weathered yet softened by love and devotion. And Dad, the best friend
and mentor anyone could have. May we all attain his ability to relish the
unique gifts that life has to offer. They have taught me to learn from
experiences and to appreciate the good in others. I am truly blessed to
have three wonderful parents.
May we all enjoy the precious moments that we have to share with those
who are most important to us.
—Teresa
To my mother and father, my daughter, and my son for inspiring me; to
my high school bookkeeping teacher, Betty Oglesby, for igniting the slow
burning fuse that eventually lead to my degree in accounting; and to my
English 102 instructor at West Texas A&M, Dr. Jerri L. Williams, who
encouraged me to explore and expand my technical writing skills.
—Truitt
For my children, Larry, Alan, and Lee-Ann, and grandchildren, Asa,
Mandie, Melanie, and Ben—their unconditional love and continuing
support and encouragement makes it all worthwhile. And to my friend
and colleague, Kathy Lee Brown, whose devotion to saying it right and
her way with words has made my contribution much more readable.
—Larry
To Hannah and C for being my reason to keep going and also the
reason to stop and enjoy life. To my Mam and brother Gavin for the
never ending support; I wouldn’t be where I am without you. And to my
Dad whose voice still carries on and drives me to be the best I can be.
—Leigh
To my wife and our eight children who have loved me, encouraged me,
and prayed with me throughout the entirety of this adventure!
—Brent

About the Authors
Teresa Hennig loves challenges, solving problems, and mak-
ingthingshappen.Hercompany,DataDynamicsNW,reflects
her dynamic personality and her innate ability to quickly
graspasituationandformulateasolution.Withastrongback-
groundinbusinessmanagement,Teresaprovidescost-effective
solutions tailored to meet her client’s needs. Her projects span the gamut of
industries from title search companies to telemarketing services, and from
managingunioncontractsandnegotiationstosupportinghealthcareservices.
Whether reviewing an existing program or deploying a comprehensive solu-
tion,herfocusisonsolvingproblemsandempoweringothers.Youcanlearn
moreaboutTeresafromherwebsite,www.DataDynamicsNW.com.
In recognition of her expertise and dedication to the Access community,
TeresahasbeenawardedMicrosoftAccessMVP(MostValuableProfessional)
every year, since her first award in 2006. Like several of the authors, Teresa
isone ofthefounding moderatorsonthenewMSDNdatabasedesignforum
at http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver.
Teresa continues to serve as president of both the Pacific Northwest
Access Developer Groups (PNWADG) and of the Seattle Access Group
(www.SeattleAccess.org) and publishes two monthly Access newsletters.
Teresa is the lead author for Access Programmer’s Reference (Wrox) and
co-author of RibbonX: Programming the Office 2007 Ribbon (Wiley). The best
partofbeingtheleadauthorisbeingabletooffercolleaguestheopportunity
tobecomepublishedauthors;formanyitistruly‘‘adreamcometrue.’’
vii