管理信息系统（英文版·第7版）（上篇共上中下3篇）

CollaborationInformationSystemsforDecisionMaking,ProblemSolving,andProjectManagementChapterExtension1StudyQuestionsCopyright©2017PearsonEducation,Inc.Q1:Whatarethetwokeycharacteristicsofcollaboration?Q2:Whatarethreecriteriaforsuccessfulcollaboration?Q3:Whatarethefourprimarypurposesofcollaboration?Q4:Whatarethecomponentsandfunctionsofacollaborationinformationsystem?Q1:WhatAretheTwoKeyCharacteristicsofCollaboration?Copyright©2017PearsonEducation,Inc.Twoormorepeopleworkingtogethertoachieveacommongoal.FeedbackanditerationCooperationlacksfeedbackanditerationloop.ImportanceofEffectiveCriticalFeedbackCopyright©2017PearsonEducation,Inc.Members

learnfromeachother.Mustbewillingtoexpressdifferent,orevenunpopular,ideas.Skillsdonotcomenaturally.Collaboratorbusinessexperiencedoesnotmatter.Beingpopularorwellorganized

notimportant.ImportantCharacteristicsofaCollaboratorCopyright©2017PearsonEducation,Inc.LeastImportantCharacteristicsGuidelinesforGivingandReceivingCriticalFeedbackCopyright©2017PearsonEducation,Inc.Q2:WhatAreThreeCriteriaforSuccessfulCollaboration?Copyright©2017PearsonEducation,Inc.Criteriaforjudgingteamsuccess:Successfuloutcome.Changeinteamcapabilityovertime.Meaningfulandsatisfyingexperience.Q3:WhatAretheFourPrimaryPurposesofCollaboration?Copyright©2017PearsonEducation,Inc.BecomeinformedSharedata&communicateinterpretations.Developanddocumentsharedunderstandings.MakedecisionsSolveproblemsManageprojectsCollaborationNeedsforDecisionMakingCopyright©2017PearsonEducation,Inc.Problem-solvingTasksCopyright©2017PearsonEducation,Inc.

ManagingProjectTasksandDataCopyright©2017PearsonEducation,Inc.Q4:WhataretheComponentsandFunctionsofa

CollaborationInformationSystem?Copyright©2017PearsonEducation,Inc.HardwareSoftwareDataProceduresPeopleCollaborationSystemRequirementsCopyright©2017PearsonEducation,Inc.RequirementsforDifferentCollaborationPurposesCopyright©2017PearsonEducation,Inc.ActiveReviewCopyright©2017PearsonEducation,Inc.Q1:Whatarethetwokeycharacteristicsofcollaboration?Q2:Whatarethreecriteriaforsuccessfulcollaboration?Q3:Whatarethefourprimarypurposesofcollaboration?Q4:Whatarethecomponentsandfunctionsofacollaborationinformationsystem?Copyright©2017PearsonEducation,Inc.CollaborativeInformationSystemsforStudentProjectsChapterExtension2StudyQuestionsCopyright©2017PearsonEducation,Inc.Q1:WhataretheISrequirementsforstudentprojectcollaborations?Q2:Howcanyouusecollaborationtoolstoimproveteamcommunication?Q3:Howcanyouusecollaborationtoolstosharecontent?Q4:Howcanyouusecollaborationtoolstomanagetasks?Q5:Whichcollaborationinformationsystemisrightforyourteam?Q1:WhatAretheISRequirementsforStudentProjectCollaborations?Copyright©2017PearsonEducation,Inc.Q2:HowCanYouUseCollaborationToolsForTeamCommunication?Copyright©2017PearsonEducation,Inc.EnableiterationandfeedbackSharedocuments,spreadsheets,presentations,andwork-productdataShareprojectmetadata(tasks,schedules,calendars,budgets)ApplicationuseandhowteamsharesdatadependontypeofcontentCollaborationToolsforSharingContentCopyright©2017PearsonEducation,Inc.Office365ProfessionalLyncWhiteboardShowingSimultaneousContributionsCopyright©2017PearsonEducation,Inc.VideoconferencingCopyright©2017PearsonEducation,Inc.DiscussionForumsCopyright©2017PearsonEducation,Inc.TeamSurveysCopyright©2017PearsonEducation,Inc.Q3:HowCanYouUseCollaborationToolstoManageSharedContent?Copyright©2017PearsonEducation,Inc.SharedContentwithVersionManagement(cont’d)Copyright©2017PearsonEducation,Inc.GoogleDriveFree,virtualdriveincloudtocreatefoldersandstorefilesMakedocumentsavailabletoothersbyenteringemailaddressesorgoogleaccountsWithGoogleaccount:SimultaneouslyseeandeditdocumentsMergeusers’activitiesintosingledocumentTrackdocumentrevisions;briefsummariesofchangesmadeCollaborationToolsforSharingContentCopyright©2017PearsonEducation,Inc.FormforCreatingaGoogleDriveAccountCopyright©2017PearsonEducation,Inc.AvailableTypesofDocumentsonGoogleDriveCopyright©2017PearsonEducation,Inc.DocumentSharingonGoogleDriveCopyright©2017PearsonEducation,Inc.ExampleofEditingaSharedDocumentonGoogleDriveCopyright©2017PearsonEducation,Inc.SharedContentwithVersionControlCopyright©2017PearsonEducation,Inc.Capabilities:

UseractivitylimitedbypermissionsDocumentcheckoutVersionhistoriesWorkflowcontrolCheckingOutaDocumentCopyright©2017PearsonEducation,Inc.ChapterVersionHistoryCopyright©2017PearsonEducation,Inc.ExampleWorkflowCopyright©2017PearsonEducation,Inc.Q4:HowCanYouUseCollaborationToolsToManageTasks?Copyright©2017PearsonEducation,Inc.SharingaTaskListUsingMicrosoftSharePointCopyright©2017PearsonEducation,Inc.ProductionTaskListSharingaTaskListonGoogleGridCopyright©2017PearsonEducation,Inc.ToDoListWhatWe’veDoneSoFar(Example)Copyright©2017PearsonEducation,Inc.SharePointTaskEmailCopyright©2017PearsonEducation,Inc.Q5:WhichCollaborationInformationSystemIsRightforYourTeam?Copyright©2017PearsonEducation,Inc.Office365FeaturesNeedfortheComprehensiveToolSetCopyright©2017PearsonEducation,Inc.ChoosingtheSetforYourTeamCopyright©2017PearsonEducation,Inc.Don’tForgetProceduresandPeople!Copyright©2017PearsonEducation,Inc.HardwarehostedoncloudMeta-dataforprojectmanagement,teamiterationandfeedbackThinkaboutprocedureandpeoplecomponentsAgreeontoolsandusageTrainingIdentifyspecialjoborrolesneededActiveReviewCopyright©2017PearsonEducation,Inc.Q1:WhataretheISrequirementsforstudentprojectcollaborations?Q2:Howcanyouusecollaborationtoolstoimproveteamcommunication?Q3:Howcanyouusecollaborationtoolstosharecontent?Q4:Howcanyouusecollaborationtoolstomanagetasks?Q5:Whichcollaborationinformationsystemisrightforyourteam?Copyright©2017PearsonEducation,Inc.MobileSystemsChapterExtension3StudyQuestionsCopyright©2017PearsonEducation,Inc.Q1:Whataremobilesystems?Q2:Whyaremobilesystemsimportant?Q3:HowdonativeandWeb-basedmobileapplicationscompare?Q4:Whatcharacterizesqualitymobileuserexperiences?Q5:Whatarethechallengesofpersonalmobiledevicesatwork?Q1:WhatAreMobileSystems?Copyright©2017PearsonEducation,Inc.InformationsystemstosupportusersinmotionComputingDeviceSmallLightweightPower-conservingCapableOfWirelessAccessMajorelementsinamobilesystemUsersinmotionMobiledevicesWirelessconnectivityCloud-basedresourcesElementsofaMobileInformationSystemCopyright©2017PearsonEducation,Inc.Q2:WhyAreMobileSystemsImportant?Copyright©2017PearsonEducation,Inc.Q3: HowDoNativeandWeb-basedMobileApplicationsCompare?Copyright©2017PearsonEducation,Inc.Q3: HowDoNativeandWeb-basedMobileApplicationsCompare?(cont’d)Copyright©2017PearsonEducation,Inc.DevelopingNativeMobileApplicationsCopyright©2017PearsonEducation,Inc.RunonanyoperatingsystemanddeviceSerious,heavy-duty,professionalprogramminglanguagesObjective-C,C#,C++,Swift,Java,VB.NET,etc.Givesclosecontrolovercomputingdevice,enablescreationofsophisticatedandcomplexuserinterfacesFastandefficientusememoryLimitedbytypeofoperatingsystemCostlydevelopmentDevelopingWebMobileApplicationsCopyright©2017PearsonEducation,Inc.Object-orientedlanguages:html5,css3,JavascriptBrowsershandleidiosyncrasiesofoperatingsystemandunderlyinghardwarehtml5supportsgraphics,animation,2Danimations,othersophisticateduserexperiencescss3usedwithhtml5tospecifyappearanceofcontentcodedinhtmlJavaScriptprovidesunderlyinglogicofapplicationNativeMobileApplicationsCopyright©2017PearsonEducation,Inc.MacOSandiOSapplicationsconstructedusingObjective-CorSwiftprogramminglanguagesLinux(Android)applicationsconstructedusingJavaWindowsapplicationsconstructedusingC#,VB.NET,C++,andothersBrowserDifferencesCopyright©2017PearsonEducation,Inc.WebapplicationslimitedbycapabilitiesofbrowserSophisticated

browserscannotofferfullcapabilitiesofunderlyingoperatingsystemandhardwareWebapplicationsunabletosupportveryspecializedandcomplexapplications,lesstrueeachyearGetHuGamesSpiroCanvasCopyright©2017PearsonEducation,Inc.SophisticatedHTML5ApplicationCopyright©2017PearsonEducation,Inc.WhichIsBetter?Copyright©2017PearsonEducation,Inc.DependsonstrategyandgoalsApplicationrequirementsBudgetScheduleToleranceformanagingtechnicalprojectsNeedforapplicationrevenueThin-clientapplicationscheapertodevelopandmaintainMaylackthe“wowfactor”Q4:WhatCharacterizesQualityMobileUserExperiences?Copyright©2017PearsonEducation,Inc.CharacteristicsofaQualityMobileUX

Chrome-lessInterfaceCopyright©2017PearsonEducation,Inc.Notoolbar(chrome)tostartaprogramUserintuitivelyknowstoclickimagetostartapplicationDirectinteractiondrivesapplicationbehaviorExampleofApplicationScalingCopyright©2017PearsonEducation,Inc.ExampleofMicrosoftEdgeCharmSharingCopyright©2017PearsonEducation,Inc.MobileSystemsCloudUseCopyright©2017PearsonEducation,Inc.KindleRoamingMessageDisplaysinFrontofKindleTextCopyright©2017PearsonEducation,Inc.Q5:WhatAretheChallengesofPersonalMobileDevicesatWork?Copyright©2017PearsonEducation,Inc.SixCommonBYODPoliciesCopyright©2017PearsonEducation,Inc.AdvantagesofExample

BYODPoliciesCopyright©2017PearsonEducation,Inc.ActiveReviewCopyright©2017PearsonEducation,Inc.Q1:Whataremobilesystems?Q2:Whyaremobilesystemsimportant?Q3:Howdonativeandbrowser-basedmobileapplicationscompare?Q4:Whatcharacterizesqualitymobileuserexperiences?Q5:Whatarethechallengesofpersonalmobiledevicesatwork?Copyright©2017PearsonEducation,Inc.IntroductiontoMicrosoftExcel2013ChapterExtension4StudyQuestionsCopyright©2017PearsonEducation,Inc.Q1:Whatisaspreadsheet?Q2:HowdoyougetstartedwithExcel?Q3:Howcanyouenterdata?Q4:Howcanyouinsertanddeleterowsandcolumnsandchangetheirsize?Q5:Howcanyouformatdata?Q6:Howcanyoucreatea(simple)formula?Q7:Howcanyouprintresults?Q1:WhatIsaSpreadsheet?Copyright©2017PearsonEducation,Inc.Q2:HowDoYouGetStartedwithExcel?Copyright©2017PearsonEducation,Inc.SavingYourWorkbookinExcelEnteringaFileNameinExcelCopyright©2017PearsonEducation,Inc.ExcelMenuTabsandRibbonBarCopyright©2017PearsonEducation,Inc.RibbonwithPageLayoutTabSelectedCopyright©2017PearsonEducation,Inc.Q3:HowCanYouEnterData?Copyright©2017PearsonEducation,Inc.ThreegeneralmethodsKeyinthedataLetExceladddatabasedonapatternImportfromanotherfileorprogramKeyintheData:EnteringCityNamesinColumnECopyright©2017PearsonEducation,Inc.LetExcelAddDataUsingaPatternCopyright©2017PearsonEducation,Inc.AutomaticallyrepeatitemsalreadyenteredUsefillhandletofilldataFilldataintoadjacentcellsFillformulasintoadjacentcellsFillaseriesofnumbers,dates,orotherbuilt-inseriesitemsFilldatausingacustomfillseriesUsingaFunctionKeytoMakeEntryCorrectionsCopyright©2017PearsonEducation,Inc.UseF2keytomakecorrectionswithoutretypingthewholeentry.EnteringIdenticalDatainMultipleCells:Step1Copyright©2017PearsonEducation,Inc.Littleblackboxinlowerright-handcorner.EnteringIdenticalDataInMultipleCells:Step2Copyright©2017PearsonEducation,Inc.ClickleftmousebuttononlittleblackboxanddragcursortocellG7Click&dragIdenticalDataEnteredinMultipleCellsCopyright©2017PearsonEducation,Inc.ReleasemousebuttonEnteringPatternedDatainMultipleCellsCopyright©2017PearsonEducation,Inc.Selectpattern:100,200PatternedDataEnteredinMultipleCellsCopyright©2017PearsonEducation,Inc.Click,drag,droppatterndowntoG7SophisticatedEntryofPatternedDatainMultipleCellsCopyright©2017PearsonEducation,Inc.SelectcellsforpatternincolumnsAandCFindPatternsWithinTextValuesCopyright©2017PearsonEducation,Inc.SelectcellsJ1andJ2,thendragproducessequenceQ4:HowCanYouInsertandDeleteRowsandColumnsandChangeTheirSize?Copyright©2017PearsonEducation,Inc.InsertrowsLeftclickinrownumberabovewherenewrow(s)tobeinserted.Clickrightmousebutton,selectInsertfrommenu.Deleterows-Clickrightmousebutton,selectInsertfrommenu.ChangerowsizeClickandholdonbottomofrownumber(cursorchangestoverticalbar).Dragmousetodesiredrowheight.AddingNewRowsforColumnHeadingsCopyright©2017PearsonEducation,Inc.InserttwonewrowsMenuforAddingInsertsSuchasNewRowsCopyright©2017PearsonEducation,Inc.Clickrow1andselecttworows.Usingrightmousebutton,clickselectionandmenuboxappears.Left-clickonInsert.UserHasAddedNewRowsforColumnHeadingsCopyright©2017PearsonEducation,Inc.TwonewrowsaddedChangingCursortoaVerticalBartoChangeColumnWidthsCopyright©2017PearsonEducation,Inc.ClicklinebetweenAandB.Cursorchangestoaverticalbarwithanarrowoneachside.Movecursortorighttoincreasesizeandtolefttodecrease.SpreadsheetwithRowsAddedandSizesofColumnsChangedCopyright©2017PearsonEducation,Inc.ColumnAwidthchangedQ5:HowCanYouFormatData?Copyright©2017PearsonEducation,Inc.RibbonoptionsAlignment(left,center,right)withincellFontsize,style,colorNumberstyle–currency,comma,percentage,numberofdecimalplacesCelllinesandbordersCenteringLabelsinCellsCopyright©2017PearsonEducation,Inc.AddingDollarSignsInCellsCopyright©2017PearsonEducation,Inc.Q6:HowCanYouCreatea(Simple)Formula?Copyright©2017PearsonEducation,Inc.FormulaKeyin:=C3+D3+E3Copyandpasteformulatoothercells.Usebuilt-infunctionsuchasSUM.=SUM(C3:E3)SelectingCellstoBeSummedCopyright©2017PearsonEducation,Inc.ResultofApplyingaFormulathatSummedCellsC3,D3,andE3Copyright©2017PearsonEducation,Inc.FormulaResultUsingF2FunctionKeytoShowColorCodingofCellsInvolvedinaCalculationCopyright©2017PearsonEducation,Inc.UsingF2FunctionKeytoConfirmaFormulaWasCorrectlyCopiedintoMultipleCellsCopyright©2017PearsonEducation,Inc.SelectcellG3andselectCopy.Next,highlightcellsG4throughG7,right-click,andselect

Paste.

Rownumbersadjustedwhenformulacopied!AutoSumFunctionCopyright©2017PearsonEducation,Inc.SelectcellC9.ThenselectFormulastabattopofribbon.Attopoftab,clickAutoSum(∑).PressEnter=SUM(C3:C8)SummingSalesbyMonthCopyright©2017PearsonEducation,Inc.TosavepaperandinkPrintPreviewSheetOptionsViewandprintwithgridlinesHeadingsOrientation:LandscapeorPortraitPagelayouttabSpecifyaportionofworksheettoprintPrintareaQ7:HowCanYouPrintResults?Copyright©2017PearsonEducation,Inc.PrintPreviewScreeninExcelCopyright©2017PearsonEducation,Inc.UsingPrintPreviewtoViewtheSpreadsheetwith

GridlinesandHeadingsCopyright©2017PearsonEducation,Inc.UsingPrintPreviewtoSelectOnlyaPortionofthe

SpreadsheetCopyright©2017PearsonEducation,Inc.ActiveReviewCopyright©2017PearsonEducation,Inc.Q1:Whatisaspreadsheet?Q2:HowdoyougetstartedwithExcel?Q3:Howcanyouenterdata?Q4:Howcanyouinsertanddeleterowsandcolumnsandchangetheirsize?Q5:Howcanyouformatdata?Q6:Howcanyoucreatea(simple)formula?Q7:Howcanyouprintresults?Copyright©2017PearsonEducation,Inc.DatabaseDesignChapterExtension5StudyQuestionsCopyright©2017PearsonEducation,Inc.Q1:Whowillvolunteer?Q2:Howaredatabaseapplicationsystemsdeveloped?Q3:Whatarethecomponentsoftheentity-relationshipdatamodel?Q4:Howisadatamodeltransformedintoadatabasedesign?Q5:Whatistheusers’role?Q6:Whowillvolunteer?(continued)Q2:HowAreDataModelsUsedforDatabase

Development?Copyright©2017PearsonEducation,Inc.Q2:HowAreDatabaseApplicationSystemsDeveloped?(cont’d)Copyright©2017PearsonEducation,Inc.InterviewuserstoidentifyanddeveloprequirementsforapplicationsAnalyzeexistingforms,reports,queries,otheruseractivitiesCreatedatamodeltosummarizerequirementsandthemesUsersreviewandvalidatedatamodelUsersapprovedatamodelBuilddatabaseSomethingtotrackOrder,customer,salesperson,item,volunteer,donationEntitiesDescribecharacteristicsofentityOrderNumber,CustomerNumber,VolunteerName,PhoneNumberAttributesUniquelyidentifiesoneentityinstancefromotherinstancesStudent_ID_NumberIdentifierQ3:WhatAretheComponentsoftheEntity-RelationshipDataModel?Copyright©2017PearsonEducation,Inc.StudentDataModelEntitiesCopyright©2017PearsonEducation,Inc.ExampleofDepartment,Adviser,andStudentEntitiesandRelationships(cont'd)Copyright©2017PearsonEducation,Inc.SampleofRelationships―Version1Copyright©2017PearsonEducation,Inc.Crow’sFeet N:MAnAdvisermayhavemanystudents,andonestudentmayhavemanyadvisers

1:NOnedepartmentmayhavemanyadvisers,butanadvisermaybeinonlyonedepartmentSampleofRelationships─Version2Copyright©2017PearsonEducation,Inc.1:NAstudenthasonlyoneadvisor,butanadvisermayadvisemanystudentsN:M

Adepartmenthasmanyadvisors,andanadvisormayadviseformorethanonedepart“Crow’sFoot”Crow’s-FootDiagramVersionCopyright©2017PearsonEducation,Inc.Maximumcardinality─maximumnumberofentitiesinarelationship.Verticalbaronalinemeansatleastoneentityrequired.Minimumcardinality—minimumnumberofentitiesinarelationship.Smallovalmeansentityisoptional;relationshipneednot

haveentityofthattype.Q4:HowIsaDataModelTransformedintoaDatabaseDesign?Copyright©2017PearsonEducation,Inc.NormalizationConvertingpoorlystructuredtablesintotwoormorewell-structuredtablesGoal

ConstructtableswithsinglethemeorentityPurposeMinimizedataintegrityproblemsDataIntegrityProblemsCopyright©2017PearsonEducation,Inc.DataintegrityproblemsSeriousIncorrectandinconsistentinformationUsersloseconfidenceininformationSystemgetsapoorreputationCanonlyoccurifdataareduplicatedPoorlyDesignedEmployeeTableCausesDataIntegrityProblemCopyright©2017PearsonEducation,Inc.TwoNormalizedTablesCopyright©2017PearsonEducation,Inc.SingleThemesSummaryofNormalizationCopyright©2017PearsonEducation,Inc.Representing1:NRelationshipsCopyright©2017PearsonEducation,Inc.REPLACERepresentinganN:MRelationship:StrategyforForeignKeysCopyright©2017PearsonEducation,Inc.Q5:WhatIstheUsers’Role?Copyright©2017PearsonEducation,Inc.Finaljudgesof:WhatdatadatabaseshouldcontainHowtablesshouldberelatedThoroughlyreviewofdatamodelEntitiescontainallofthedatausersneedtodojobs,andrelationshipsaccuratelyreflectuserviewofthebusinessTakeitseriouslyanddevotetimeMistakeswillcomebacktohauntQ6:WhoWillVolunteer?Copyright©2017PearsonEducation,Inc.DataModelforVolunteerDatabaseFirstTableDesignforVolunteerDatabaseCopyright©2017PearsonEducation,Inc.SecondTableDesignforVolunteerDatabaseCopyright©2017PearsonEducation,Inc.VolunteerProspectDataEntryFormCopyright©2017PearsonEducation,Inc.ActiveReviewCopyright©2017PearsonEducation,Inc.Q1:Whowillvolunteer?Q2:Howaredatabaseapplicationsystemsdeveloped?Q3:Whatarethecomponentsoftheentity-relationshipdatamodel?Q4:Howisadatamodeltransformedintoadatabasedesign?Q5:Whatistheusers’role?Q6:Whowillvolunteer?(continued)Copyright©2017PearsonEducation,Inc.UsingMicrosoftAccess2013ChapterExtension6StudyQuestionsCopyright©2017PearsonEducation,Inc.Q1:Howdoyoucreatetables?Q2:Howdoyoucreaterelationships?Q3:Howdoyoucreateadataentryform?Q4:Howdoyoucreatequeriesusingthequerydesigntool?Q5:Howdoyoucreateareport?PROSPECT(ProspectID,Name,Street,City,State,Zip,EmailAddress)WORK(ProspectID,Date,Hour,

NumCalls,TotalDonations)CreatetwotablesfromdatamodelSelectprimarykeysSelectforeignkeysLinktablesQ1:HowDoICreateTables?Copyright©2017PearsonEducation,Inc.AttributesoftheDatabaseCopyright©2017PearsonEducation,Inc.SampleDataCopyright©2017PearsonEducation,Inc.SampleData(cont'd)Copyright©2017PearsonEducation,Inc.OpeningScreenAccess2013Copyright©2017PearsonEducation,Inc.NamingaDesktopDatabaseCopyright©2017PearsonEducation,Inc.AccessOpenswithaStartonanInitialTableDefinitionCopyright©2017PearsonEducation,Inc.ClickonBlankdatabase1Enterfilenameinlowerright-handcornerboxClickonfoldericontobrowsetoafoldertosavedatabaseClickonCreateBlanktableopensReview:SequenceofStepsforCreatingaDatabasewithAccessCopyright©2017PearsonEducation,Inc.2345CreatingaDatabasewithAccess(cont’d)Copyright©2017PearsonEducation,Inc.CreatingTablesinAccess,Step1Copyright©2017PearsonEducation,Inc.ClickViewiconSelectDesignViewindrop-downlistEntertablenameinpop-upboxWindowchangestoDesignViewCreatingTablesinAccess-Step1

DeclaringFieldNamesandDataTypesCopyright©2017PearsonEducation,Inc.UpperpartEnternameofeachattribute(Fields)EnterDataTypeEnterDescriptionBottompartDeclarefieldpropertiesCreatingTablesinAccess-Step2:

DeclaringFieldPropertiesCopyright©2017PearsonEducation,Inc.SettinglengthofaTextDataTypeCompleteSamplePROSPECTTableCopyright©2017PearsonEducation,Inc.FinishedWORKTableCopyright©2017PearsonEducation,Inc.OverviewofStepsinCreatingTablesCopyright©2017PearsonEducation,Inc.EnterDataTypesDeclareFieldPropertiesSelectPrimaryKeySavetableEnterDataNamesGotoDatabaseToolsSelectRelationshipsShowTabledialogboxopensDouble-clickonnamesoftablesTablesaddedtoRelationshipswindowCloseShowTable

dialogboxQ2:HowDoICreateRelationships?Copyright©2017PearsonEducation,Inc.ShowTableDialogBoxinAccess(Step1)Copyright©2017PearsonEducation,Inc.CreatingaRelationshipBetweenTwoTables:Step2Copyright©2017PearsonEducation,Inc.CreatingaRelationshipBetweenTwoTables:Step2(cont’d)Copyright©2017PearsonEducation,I