Transcription
(ex ploring)S E RIE S1. Investigating in a systematic way: examining. 2. Searching intoor ranging over for the purpose of discovery.Microsoft Office 365Access 2019 COMPREHENSIVESeries EditorMary Anne PoatsyWilliams RutledgeA01 POAT5816 03 SE FM.indd 111/01/19 11:53 PM
Vice President of Courseware Portfolio Management: Andrew GilfillanExecutive Portfolio Manager: Samantha LewisTeam Lead, Content Production: Laura BurgessContent Producer: Alexandrina WolfDevelopment Editor: Barbara StoverPortfolio Management Assistant: Bridget DalyDirector of Product Marketing: Brad ParkinsDirector of Field Marketing: Jonathan CottrellProduct Marketing Manager: Heather TaylorField Marketing Manager: Bob NisbetProduct Marketing Assistant: Liz BennettField Marketing Assistant: Derrica MoserSenior Operations Specialist: Maura GarciaSenior Art Director: Mary SeinerInterior and Cover Design: Pearson CSCCover Photo: Courtesy of Shutterstock ImagesSenior Product Model Manager: Eric HakansonManager, Digital Studio: Heather DarbyDigital Content Producer, MyLab IT: Becca GoldenCourse Producer, MyLab IT: Amanda LosonskyDigital Studio Producer: Tanika HendersonFull-Service Project Management: Pearson CSC (Amy Kopperude)Composition: Pearson CSCCredits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on the appropriate page within text.Microsoft and/or its respective suppliers make no representations about the suitability of the information contained in the documents and related graphicspublished as part of the services for any purpose. All such documents and related graphics are provided “as is” without warranty of any kind. Microsoftand/or its respective suppliers hereby disclaim all warranties and conditions with regard to this information, including all warranties and conditions ofmerchantability, whether express, implied or statutory, fitness for a particular purpose, title and non-infringement. In no event shall Microsoft and/or itsrespective suppliers be liable for any special, indirect or consequential damages or any damages whatsoever resulting from loss of use, data or profits, whetherin an action of contract, negligence or other tortious action, arising out of or in connection with the use or performance of information available from theservices.The documents and related graphics contained herein could include technical inaccuracies or typographical errors. Changes are periodically added to theinformation herein. Microsoft and/or its respective suppliers may make improvements and/or changes in the product(s) and/or the program(s) describedherein at any time. Partial screen shots may be viewed in full within the software version specified.Microsoft and Windows are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. This book is not sponsored or endorsedby or affiliated with the Microsoft Corporation.Copyright 2020 by Pearson. All rights reserved. Manufactured in the United States of America. This publication is protected by copyright andpermission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by anymeans, electronic, mechanical, photocopying, recording, or likewise. For information regarding permissions, request forms and the appropriate contactswithin the Pearson Education Global Rights & Permissions department, please visit www.pearsoned.com/permissions/.Many of the designations by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in thisbook, and the publisher was aware of a trademark claim, the designations have been printed in initial caps or all caps.Cataloging-in-Publication Data is available on file at the Library of Congress.119ISBN 10: 0-13-543581-1ISBN 13: 978-0-13-543581-6A01 POAT5816 03 SE FM.indd 211/01/19 11:53 PM
DedicationsFor my husband, Ted, who unselfishly continues to take on more than his share to support methroughout the process; and for my children, Laura, Carolyn, and Teddy, whose encouragement andlove have been inspiring.Mary Anne PoatsyI offer thanks to my family and colleagues who have supported me on this journey. I would like todedicate the work I have performed toward this undertaking to my little grandson, Yonason Meir(known for now as Mei-Mei), who as his name suggests, is the illumination in my life.Jerri WilliamsTo Zac: thank you so much for your hard work and dedication on this project. The long (late) hoursyou spent did not go unnoticed. I have very much enjoyed working with you and hope there’s moreto come. To my husband Dan, whose encouragement, patience, and love helped make this endeavorpossible. Thank you for taking on the many additional tasks at home so that I could focus on writing.To Emma and Jane, I love you. You inspire me to reach for my goals and never settle for less.Amy RutledgeA01 POAT5816 03 SE FM.indd 311/01/19 11:53 PM
About the AuthorsMary Anne Poatsy, Series Editor, Common Features AuthorMary Anne is a senior faculty member at Montgomery County Community College, teaching variouscomputer application and concepts courses in face-to-face and online environments. She holdsa B.A. in Psychology and Education from Mount Holyoke College and an M.B.A. in Finance fromNorthwestern University’s Kellogg Graduate School of Management.Mary Anne has more than 20 years of educational experience. She has taught at Gwynedd MercyCollege, Bucks County Community College, and Muhlenberg College. She also engages in corporatetraining. Before teaching, she was Vice President at Shearson Lehman in the Municipal BondInvestment Banking Department.Jerri Williams, Access AuthorJerri Williams is a Senior Instructor at Montgomery County Community College in Pennsylvania,and currently works as a technical editor and content developer in addition to her teachingresponsibilities. Jerri worked as a live and virtual corporate trainer and developer in majorpharmaceutical and other companies for many years prior to joining the Exploring Access 2013,2016, and 2019 teams. She is interested in travel, history, cooking, theater, movies, and tendingto her colonial farmhouse (a work in progress). Jerri is married to Gareth and is the mother oftwo daughters, Holly (an accountant/office manager, and mother of an adorable son, Meir) andGwyneth (a corporate defense/employment attorney). Jerri and Gareth live outside of Philadelphia,and enjoy their home and garden, spending time with family and friends, watching the PhiladelphiaEagles, and visiting the Jersey Shore any time of the year.Amy Rutledge, Access AuthorAmy Rutledge is a Special Instructor of Management Information Systems at Oakland Universityin Rochester, Michigan. She coordinates academic programs in Microsoft Office applications andintroductory management information systems courses for the School of Business Administration.Before joining Oakland University as an instructor, Amy spent several years working for a musicdistribution company and automotive manufacturer in various corporate roles including IT projectmanagement. She holds a B.S. in Business Administration specializing in Management InformationSystems, and a B.A. in French Modern Language and Literature. She holds an M.B.A from OaklandUniversity. She resides in Michigan with her husband, Dan and daughters Emma and Jane.Dr. Robert T. Grauer, Creator of the Exploring SeriesBob Grauer is an Associate Professor in the Department of Computer Information Systems at theUniversity of Miami, where he is a multiple winner of the Outstanding Teaching Award in theSchool of Business, most recently in 2009. He has written numerous COBOL texts and is the visionbehind the Exploring Office series, with more than three million books in print. His work has beentranslated into three foreign languages and is used in all aspects of higher education at both nationaland international levels. Bob Grauer has consulted for several major corporations including IBMand American Express. He received his Ph.D. in Operations Research in 1972 from the PolytechnicInstitute of Brooklyn.ivAbout the AuthorsA01 POAT5816 03 SE FM.indd 411/01/19 11:53 PM
Brief ice 365 Common FeaturesCHAPTER 1CHAPTER 2CHAPTER 3CHAPTER 4CHAPTER 5CHAPTER 6CHAPTER 7CHAPTER 8CHAPTER 9CHAPTER 102Introduction to AccessTables and Queries in Relational DatabasesQuery Calculations and ExpressionsBasic Forms and ReportsData Validation and Data AnalysisAction and Specialized QueriesAdvanced Forms and ReportsGet ConnectedFine-Tuning the DatabaseEnhanced Database TechniquesAccess Application Capstone Exercise (Chs. 1– 4)600Access Comprehensive Application Capstone Exercise (Chs. 5–10) 604Microsoft Office 2019 Specialist Access608GLOSSARYINDEX611616Brief ContentsA01 POAT5816 03 SE FM.indd 570132202248302344388438500552v11/01/19 11:53 PM
ContentsMicrosoft Office 2019CHAPTER ONEOffice 365 Common Features: Taking the First Step 2CASE STUDY SPOTTED BEGONIA ART GALLERYGET STARTED WITH OFFICE APPLICATIONSStarting an Office ApplicationWorking with FilesUsing Common Interface ComponentsGetting HelpInstalling Add-ins245691517MODIFY DOCUMENT LAYOUT AND PROPERTIESChanging Document ViewsChanging the Page LayoutCreating a Header and a FooterConfiguring Document PropertiesPreviewing and Printing a File454546495051HANDS-ON EXERCISE 353HANDS-ON EXERCISE 119FORMAT DOCUMENT CONTENTUsing Templates and Applying ThemesModifying TextRelocating TextReviewing a DocumentWorking with Pictures252527303234HANDS-ON EXERCISE 237CHAPTER OBJECTIVES REVIEWKEY TERMS MATCHINGMULTIPLE CHOICEPRACTICE EXERCISESMID-LEVEL EXERCISESRUNNING CASEDISASTER RECOVERYCAPSTONE EXERCISE5860616265676768Microsoft Office Access 2019CHAPTER ONEviI ntroduction to Access: Navigating anAccess DatabaseCASE STUDY MANAGING A BUSINESS IN THE GLOBALECONOMYDATABASES ARE EVERYWHERE!Opening, Saving, and Enabling Content in a DatabaseRecognizing Database Object TypesModifying, Adding, and Saving DataUsing Database Utilities707272748588HANDS-ON EXERCISE 191FILTERS AND SORTSWorking with FiltersPerforming Sorts9898102HANDS-ON EXERCISE 210470ACCESS DATABASE CREATIONCreating a Database109109HANDS-ON EXERCISE 3115CHAPTER OBJECTIVES REVIEWKEY TERMS MATCHINGMULTIPLE CHOICEPRACTICE EXERCISESMID-LEVEL EXERCISESRUNNING CASEDISASTER RECOVERYCAPSTONE EXERCISE119120121122127129129130ContentsA01 POAT5816 03 SE FM.indd 611/01/19 11:53 PM
CHAPTER TWO ables and Queries in Relational Databases:TDesigning Databases and Extracting InformationCASE STUDY BANK INTERNSHIPTABLE DESIGN, CREATION, AND MODIFICATIONDesigning a TableCreating and Modifying Tables andWorking with Data132134134HANDS-ON EXERCISE 1145MULTIPLE-TABLE DATABASESImporting Data from External SourcesEstablishing Table Relationships149149152HANDS-ON EXERCISE 2157SINGLE-TABLE QUERIESCreating a Single-Table QueryUsing the Query WizardSpecifying Query CriteriaSpecifying Query Sort Order and Running a QueryCopying and Modifying a Query164164167169172172CHAPTER THREE138202204204209210211HANDS-ON EXERCISE 1212THE EXPRESSION BUILDER AND FUNCTIONSCreating Expressions Using the Expression BuilderUsing Built-In Functions217217218HANDS-ON EXERCISE 2222CHAPTER FOURHANDS-ON EXERCISE 3174MULTITABLE QUERIESCreating a Multitable QueryModifying a Multitable Query177177178HANDS-ON EXERCISE 4182CHAPTER OBJECTIVES REVIEWKEY TERMS MATCHINGMULTIPLE CHOICEPRACTICE EXERCISESMID-LEVEL EXERCISESRUNNING CASEDISASTER RECOVERYCAPSTONE EXERCISE186188189190196198199200 uery Calculations and Expressions: PerformingQCalculations and Summarizing Data Using QueriesCASE STUDY REAL ESTATE INVESTORSCALCULATED FIELDS AND EXPRESSIONSCreating a Query with a Calculated FieldFormatting Calculated ResultsRecovering from Common ErrorsVerifying Calculated Results202AGGREGATE FUNCTIONSAdding Aggregate Functions to DatasheetsCreating Queries with Aggregate Functions226226227HANDS-ON EXERCISE 3232CHAPTER OBJECTIVES REVIEWKEY TERMS MATCHINGMULTIPLE CHOICEPRACTICE EXERCISESMID-LEVEL EXERCISESRUNNING CASEDISASTER RECOVERYCAPSTONE EXERCISE236237238239242244245246 asic Forms and Reports: Simplifying Data Entry andBProducing Information248CASE STUDY COFFEE SHOP STARTS NEW BUSINESSCREATE BASIC FORMS TO SIMPLIFY DATA MANAGEMENTCreating Forms Using Form ToolsModifying FormsUsing the Form Layout ControlSorting Records in a Form248250250258261263HANDS-ON EXERCISE 1264CREATE BASIC REPORTS TO PRESENT INFORMATIONCreating Reports Using Report ToolsUsing Report ViewsModifying a ReportSorting and Grouping Records in a Report271272277278281HANDS-ON EXERCISE 2283CHAPTER OBJECTIVES REVIEWKEY TERMS MATCHINGMULTIPLE CHOICEPRACTICE EXERCISESMID-LEVEL EXERCISESRUNNING CASEDISASTER RECOVERYCAPSTONE EXERCISE288290291292296298298299ContentsA01 POAT5816 03 SE FM.indd 7132vii11/01/19 11:53 PM
CHAPTER FIVE ata Validation and Data Analysis: Reducing ErrorsDand Extracting Better InformationCASE STUDY IMPLEMENTING A NEW DATABASE ATTOMMY’S SHELTERRESTRICT TABLE DATAEstablishing Data ValidationControlling the Format of Data EntryControlling Input with a Lookup Field302304304307309HANDS-ON EXERCISE 1311DATA ANALYSIS WITH ADVANCED QUERIES ANDFUNCTIONSCustomizing Output Based on User InputUsing Advanced Functions317317319CHAPTER SIX344346346348351353355HANDS-ON EXERCISE 1357SPECIALIZED QUERIESSummarizing Data with a Crosstab QueryFinding Duplicate Records with a QueryFinding Unmatched Records with a Query364364369371CHAPTER SEVENviiiHANDS-ON EXERCISE 2327CHAPTER OBJECTIVES REVIEWKEY TERMS MATCHINGMULTIPLE CHOICEPRACTICE EXERCISESMID-LEVEL EXERCISESRUNNING CASEDISASTER RECOVERYCAPSTONE EXERCISE332333334335338340341342 ction and Specialized Queries: Advancing BeyondAthe Select QueryCASE STUDY VIRTUAL REGISTRY, INC.ACTION QUERIESDetermining When to Use an Action QueryUpdating Data with an Update QueryAdding Records to a Table with an Append QueryCreating a Table with a Make Table QueryDeleting Records with a Delete Query388390390391394396HANDS-ON EXERCISE 1399CONTROLS AND SECTIONSUnderstanding ControlsUnderstanding Sections405405412344HANDS-ON EXERCISE 2375CHAPTER OBJECTIVES REVIEWKEY TERMS MATCHINGMULTIPLE CHOICEPRACTICE EXERCISESMID-LEVEL EXERCISESRUNNING CASEDISASTER RECOVERYCAPSTONE EXERCISE378379380381384385386387 dvanced Forms and Reports: Moving BeyondAthe BasicsCASE STUDY YELLOWSTONE COUNTY TECHNICAL SERVICESADVANCED FORMSRestricting Edits in a FormUnderstanding Combo BoxesSetting the Tab OrderUnderstanding Subforms302388HANDS-ON EXERCISE 2420CHAPTER OBJECTIVES REVIEWKEY TERMS MATCHINGMULTIPLE CHOICEPRACTICE EXERCISESMID-LEVEL EXERCISESRUNNING CASEDISASTER RECOVERYCAPSTONE EXERCISE427428429430434435436437ContentsA01 POAT5816 03 SE FM.indd 811/01/19 11:53 PM
CHAPTER EIGHT et Connected: Exchanging Data Between AccessGand Other ApplicationsCASE STUDY PROPERTY MANAGEMENT DATA EXCHANGECONNECT ACCESS TO EXTERNAL FILESCreating a Hyperlink FieldAdding an Attachment FieldAdding Attachment Controls to Forms and Reports438440440442445HANDS-ON EXERCISE 1448EXPORT DATA TO OFFICE AND OTHER APPLICATIONSExporting Data to ExcelExporting Data to WordExporting Data to a PDF or XPS DocumentExporting Objects to Another Access Database454454457460462HANDS-ON EXERCISE 2464IMPORT AND LINK DATA IN ACCESS DATABASESLinking to an Access Table471471CHAPTER NINE500502503505507509HANDS-ON EXERCISE 1511BUILT-IN ANALYSIS AND DESIGN TOOLSUsing the Database Documenter ToolUsing the Performance Analyzer ToolUsing the Table Analyzer ToolUsing the Database Splitter Tool515516518520523HANDS-ON EXERCISE 2525HANDS-ON EXERCISE 3480CHAPTER OBJECTIVES REVIEWKEY TERMS MATCHINGMULTIPLE CHOICEPRACTICE EXERCISESMID-LEVEL EXERCISESRUNNING CASEDISASTER RECOVERYCAPSTONE EXERCISE489490491492496497498499DATABASE SECURITYControlling NavigationEncrypting and Password Protecting a DatabaseCreating an Executable Form of a Database530530532534HANDS-ON EXERCISE 3536CHAPTER OBJECTIVES REVIEWKEY TERMS MATCHINGMULTIPLE CHOICEPRACTICE EXERCISESMID-LEVEL EXERCISESRUNNING CASEDISASTER RECOVERYCAPSTONE EXERCISE540541542543546548549550 nhanced Database Techniques: Using Macros andESQL in AccessCASE STUDY RETIREMENT PLAN CONTRIBUTIONSMACRO DESIGNUnderstanding the Purpose of a MacroCreating a Standalone MacroAttaching an Embedded Macro to an Event552554554555557HANDS-ON EXERCISE 1561DATA MACROSIdentifying When to Use a Data MacroCreating an Event-Driven Data MacroCreating a Named Data Macro568568568569HANDS-ON EXERCISE 2572STRUCTURED QUERY LANGUAGEUnderstanding the Fundamentals of SQL578578Interpreting an SQL SELECT StatementUsing an SQL SELECT Statement as a Record Source552579581HANDS-ON EXERCISE 3584CHAPTER OBJECTIVES REVIEWKEY TERMS MATCHINGMULTIPLE CHOICEPRACTICE EXERCISESMID-LEVEL EXERCISESRUNNING CASEDISASTER RECOVERYCAPSTONE EXERCISE587588589590595597597598ContentsA01 POAT5816 03 SE FM.indd 9474476477 Fine-Tuning the Database: Designing for Performance 500CASE STUDY THE METROPOLITAN ZOODATABASE NORMALIZATIONUnderstanding First Normal FormUnderstanding Second Normal FormUnderstanding Third Normal FormFinalizing the DesignCHAPTER TENLinking to and Importing an Excel SpreadsheetImporting an Excel SpreadsheetImporting a Text File438ix11/01/19 11:53 PM
Application Capstone ExercisesAccess Application Capstone Exercise (Chs. 1– 4) 600Access Comprehensive ApplicationCapstone Exercise (Chs. 5–10)x604Microsoft Office 2019 Specialist Access608GLOSSARY611INDEX616ContentsA01 POAT5816 03 SE FM.indd 1011/01/19 11:53 PM
AcknowledgmentsThe Exploring team would like to acknowledge and thank all the reviewers who helped us throughout the years by providing us with theirinvaluable comments, suggestions, and constructive criticism.A. D. KnightNorthwestern State UniversityNatchitoches–LouisianaAaron MontaninoDavenport UniversityAdriana LumpkinMidland CollegeAlan S. AbrahamsVirginia TechAlexandre C. ProbstColorado Christian UniversityAli BerrachedUniversity of Houston–DowntownAllen AlexanderDelaware Technical & Community CollegeAmy RutledgeOakland UniversityAndrea MarcheseMaritime CollegeState University of New YorkBonita VolkerTidewater Community CollegeCraig WatsonBristol Community CollegeBonnie HomanSan Francisco State UniversityDana HooperUniversity of AlabamaBrad WestSinclair Community CollegeDana JohnsonNorth Dakota State UniversityBrian KovarKansas State UniversityDaniela MarghituAuburn UniversityBrian PowellWest Virginia UniversityDavid NoelUniversity of Central OklahomaCarmen MorrisonNorth Central State CollegeDavid PulisMaritime College, State University ofNew YorkCarol BuserOwens Community CollegeCarol RobertsUniversity of MaineCarol WigginsBlinn CollegeCarole PfeifferSoutheast Missouri State UniversityAndrew BlitzBroward College; Edison State CollegeCarolyn BarrenMacomb Community CollegeAngel NormanUniversity of Tennessee–KnoxvilleCarolyn BorneLouisiana State UniversityAngela ClarkUniversity of South AlabamaCathy PoynerTruman State UniversityAnn RovettoHorry–Georgetown Technical CollegeCharles HodgsonDelgado Community CollegeAstrid ToddGuilford Technical Community CollegeChen ZhangBryant UniversityAudrey GillantMaritime College, State University ofNew YorkCheri HigginsIllinois State UniversityBarbara StoverMarion Technical CollegeBarbara TollingerSinclair Community CollegeBen Brahim TahaAuburn UniversityBeverly AmerNorthern Arizona UniversityBeverly FiteAmarillo CollegeBiswadip GhoshMetropolitan State University of DenverCheryl BrownDelgado Community CollegeCheryl HindsNorfolk State UniversityCheryl SypniewskiMacomb Community CollegeChris RobinsonNorthwest State Community CollegeCindy HerbertMetropolitan Community College–LongviewCraig J. PetersonAmerican InterContinental UniversityDavid ThorntonJacksonville State UniversityDawn MedlinAppalachian State UniversityDebby KeenUniversity of KentuckyDebra ChapmanUniversity of South AlabamaDebra HoffmanSoutheast Missouri State UniversityDerrick HuangFlorida Atlantic UniversityDiana BaranHenry Ford Community CollegeDiane CassidyThe University of North Carolina atCharlotteDiane L. SmithHenry Ford Community CollegeDick HewerFerris State CollegeDon DannerSan Francisco State UniversityDon HogganSolano CollegeDon RiggsSUNY Schenectady County CommunityCollegeDoncho PetkovEastern Connecticut State UniversityDonna EhrhartGenesee Community CollegeAcknowledgmentsA01 POAT5816 03 SE FM.indd 11xi11/01/19 11:53 PM
Elaine CrableXavier UniversityJames BrownCentral Washington UniversityKen BusbeeHouston Community CollegeElizabeth DuettDelgado Community CollegeJames PowersUniversity of Southern IndianaKent FosterWinthrop UniversityErhan UskupHouston Community College–NorthwestJane StamOnondaga Community CollegeKevin AndersonSolano Community CollegeEric MartinUniversity of TennesseeJanet BringhurstUtah State UniversityKim WrightThe University of AlabamaErika NadasWilbur Wright CollegeJanice PotochneyGateway Community CollegeKirk AtkinsonWestern Kentucky UniversityEvelyn SchenkSaginaw Valley State UniversityJean LuomaDavenport UniversityKristen HockmanUniversity of Missouri–ColumbiaFloyd WintersManatee Community CollegeJean WelshLansing Community CollegeKristi SmithAllegany College of MarylandFrank LucenteWestmoreland County Community CollegeJeanette DixIvy Tech Community CollegeLaura MarcoulidesFullerton CollegeG. Jan WilmsUnion UniversityJennifer DaySinclair Community CollegeLaura McManamonUniversity of DaytonGail CopeSinclair Community CollegeJill CanineIvy Tech Community CollegeLaurence BoxerNiagara UniversityGary DeLorenzoCalifornia University of PennsylvaniaJill YoungSoutheast Missouri State UniversityLeanne ChunLeeward Community CollegeGary GarrisonBelmont UniversityJim ChaffeeThe University of Iowa Tippie College ofBusinessLee McClainWestern Washington UniversityGary McFallPurdue UniversityGeorge CassidySussex County Community CollegeGerald BraunXavier UniversityGerald BurgessWestern New Mexico UniversityGladys SwindlerFort Hays State UniversityGurinder MehtaSam Houston State UniversityHector FraustoCalifornia State University Los AngelesHeith HennelValencia Community CollegeHenry RudzinskiCentral Connecticut State UniversityIrene JoosLa Roche CollegeIwona RusinBaker College; Davenport UniversityJ. Roberto GuzmanSan Diego Mesa CollegeJacqueline D. LawsonHenry Ford Community CollegeJakie Brown, Jr.Stevenson UniversityxiiJoanne LazirkoUniversity of Wisconsin–MilwaukeeJodi MillinerKansas State UniversityJohn HollenbeckBlue Ridge Community CollegeJohn MeirMidlands Technical CollegeJohn NelsonTexas Christian UniversityJohn SeydelArkansas State UniversityJudith A. ScheerenWestmoreland County Community CollegeJudith BrownThe University of MemphisJuliana CypertTarrant County CollegeKamaljeet SangheraGeorge Mason UniversityKaren PriestlyNorthern Virginia Community CollegeKaren RavanSpartanburg Community CollegeKaren TraceyCentral Connecticut State UniversityKathleen BrenanAshland UniversityLewis CappelliHudson Valley Community CollegeLinda D. CollinsMesa Community CollegeLinda JohnsoniusMurray State UniversityLinda LauLongwood UniversityLinda TheusJackson State Community CollegeLinda WilliamsMarion Technical CollegeLisa MillerUniversity of Central OklahomaLister HornPensacola Junior CollegeLixin TaoPace UniversityLoraine MillerCayuga Community CollegeLori KieltyCentral Florida Community CollegeLorna WellsSalt Lake Community CollegeLorraine SauchinDuquesne UniversityLucy ParakhovnikCalifornia State University–NorthridgeAcknowledgmentsA01 POAT5816 03 SE FM.indd 1211/01/19 11:53 PM
Lynn BaldwinMadison CollegeLynn KeaneUniversity of South CarolinaLynn ManciniDelaware Technical CommunityCollegeNancy GrantCommunity College of AlleghenyCounty–South CampusNanette LareauUniversity of Arkansas CommunityCollege–MorriltonRobyn BarrettSt. Louis Community College–MeramecRocky BelcherSinclair Community CollegeRoger PickUniversity of Missouri at Kansas CityNikia RobinsonIndian River State UniversityRonnie CreelTroy UniversityPam BruneChattanooga State Community CollegeRosalie WesterbergClover Park Technical CollegePam UhlenkampIowa Central Community CollegeRuth NealNavarro CollegePatrick SmithMarshall Community and Technical CollegeSandra ThomasTroy UniversityPaul AddisonIvy Tech Community CollegeSheila GionfriddoLuzerne County Community CollegePaul HamiltonNew Mexico State UniversitySherrie GeitgeyNorthwest State Community CollegePaula RubyArkansas State UniversitySherry LenhartTerra Community CollegePeggy BurrusRed Rocks Community CollegeShohreh HashemiUniversity of Houston–DowntownPeter RossSUNY AlbanySophia WilberscheidIndian River State CollegePhilip H. NielsonSalt Lake Community CollegeSophie LeeCalifornia State University–Long BeachPhilip ValvalidesGuilford Technical Community CollegeStacy JohnsonIowa Central Community CollegeRalph HooperUniversity of AlabamaStephanie KramerNorthwest State Community CollegeMelody AlexanderBall State UniversityRanette HalversonMidwestern State UniversityStephen Z. JourdanAuburn University at MontgomeryMichael DouglasUniversity of Arkansas at Little RockRichard BlamerJohn Carroll UniversitySteven SchwarzRaritan Valley Community CollegeMichael DunklebargerAlamance Community CollegeRichard CacacePensacola Junior CollegeSue A. McCroryMissouri State UniversityMichael G. SkaffCollege of the SequoiasRichard HewerFerris State UniversitySumathy ChandrashekarSalisbury UniversityMichele BudnovitchPennsylvania College of TechnologyRichard SellersHill CollegeSusan FuschettoCerritos CollegeMike JochenEast Stroudsburg UniversityRob MurrayIvy Tech Community CollegeSusan MedlinUNC CharlotteMike MichaelsonPalomar CollegeRobert BantaMacomb Community CollegeSusan N. DozierTidewater Community CollegeMike ScrogginsMissouri State UniversityRobert Dus ekNorthern Virginia Community CollegeSuzan SpitzbergOakton Community CollegeMimi SpainSouthern Maine Community CollegeRobert G. Phipps, Jr.West Virginia UniversitySuzanne M. JeskaCounty College of MorrisMuhammed BadamasMorgan State UniversityRobert SindtJohnson County Community CollegeSven AeltermanTroy UniversityNaLisa BrownUniversity of the OzarksRobert WarrenDelgado Community CollegeSy HirschSacred Heart UniversityLynne SealAmarillo CollegeMackinzee EscamillaSouth Plains CollegeMarcia WelchHighline Community CollegeMargaret McManusNorthwest Florida State CollegeMargaret WarrickAllan Hancock CollegeMarilyn HibbertSalt Lake Community CollegeMark ChomanLuzerne County Community CollegeMary Beth TarverNorthwestern State UniversityMary DuncanUniversity of Missouri–St. LouisMaryann ClarkUniversity of New HampshireMelissa NemethIndiana University–Purdue UniversityIndianapolisAcknowledgmentsA01 POAT5816 03 SE FM.indd 13xiii11/01/19 11:53 PM
Sylvia BrownMidland CollegeTommy LuDelaware Technical Community CollegeWes AnthonyHouston Community CollegeTanya PatrickClackamas Community CollegeTroy S. CashNorthwest Arkansas Community CollegeWilliam AyenUniversity of Colorado at Colorado SpringsTerri HollyIndian River State CollegeVicki RobertsonSouthwest Tennessee CommunityWilma AndrewsVirginia Commonwealth UniversityTerry Ray RigsbyHill CollegeVickie PickettMidland CollegeYvonne GalushaUniversity of IowaThomas RienzoWestern Michigan UniversityVivianne MooreDavenport UniversityTina JohnsonMidwestern State UniversityWeifeng ChenCalifornia University of PennsylvaniaSpecial thanks to our content development and technical team:Barbara StoverLisa BuckiLori DamantiSallie DodsonMorgan HetzlerKen MayerJoyce NielsenChris ParentSean PortnoySteven RubinxivLeeAnn BatesMyLab IT content authorBecca GoldenMedia ProducerJennifer HurleyMyLab IT content authorKevin MarinoMyLab IT content authorRalph MooreMyLab IT content authorJerri WilliamsMyLab IT content authorAcknowledgmentsA01 POAT5816 03 SE FM.indd 1411/01/19 11:53 PM
PrefaceThe Exploring Series and YouExploring is Pearson’s Office Application series that requires students like you to think “beyond thepoint and click.” In this edition, the Exploring experience has evolved to be even more in tune with thestudent of today. With an emphasis on Mac compatibility, critical thinking, and continual updates tostay in sync with the changing Microsoft Office 365, and by providing additional valuable assignmentsand resources, the Exploring series is able to offer you the most usable, current, and beneficial learningexperience ever.The goal of Exploring is, as it has always been, to go farther than teaching just the steps to accomplisha task—the series provides the theoretical foundation for you to understand when and why to apply askill. As a result, you achieve a deeper understanding of each application and can apply this criticalthinking beyond Office and the classroom.New to This EditionContinual eText Updates: This edition of Exploring is written to Microsoft Office 365 , which is constantly updating. In order to stay current with the software, we are committed to twice annual updatesof the eText and Content Updates document available as an instructor resource for text users.Focus on Mac: Mac usage is growing, and even outstripping PC usage at some four-year institutions.In response, new features such as Mac Tips, On a Mac step boxes, Mac Troubleshooting, and Mac tips onStudent Reference Cards help ensure Mac users have a flawless experience using Exploring.Expanded Running Case: In this edition, the Running Case has been expanded to all applications,with one exercise per chapter focusing on the New Castle County Technical Services case, providing acontinuous and real-world project for students to work on throughout the semester.Pre-Built Learning Modules: Pre-built inside MyLab IT, these make course setup a snap. The modules are based on research and instructor best practices, and can be easily customized to meet yourcourse requirements.Critical Thinking Modules: Pre-built inside MyLab IT, these pair a Grader Project with a criticalthinking quiz that requires students to first complete a ha
Access Application Capstone Exercise (Chs. 1– 4) 600 Access Comprehensive Application Capstone Exercise (Chs. 5–10)604 Microsoft Office 2019 Specialist Access 608 GLOSSARY 611
