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, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the PermissionsDepartment,JohnWiley&Sons,Inc.,111RiverStreet,Hoboken,NJ07030,(201)748-6011,fax(201)748-6008, 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