欢迎来到天天文库
浏览记录
ID:53050621
大小:1.13 MB
页数:30页
时间:2020-04-16
《微软官网资料Build a database IV Create queries for a new Access database.ppt》由会员上传分享,免费在线阅读,更多相关内容在PPT专区-天天文库。
1、Microsoft®OfficeAccess®2007TrainingBuildadatabaseIV:CreatequeriesforanewAccessdatabase[Yourcompanyname]presents:BuildadatabaseIV:CreatequeriesforanewAccessdatabaseCoursecontentsOverview:Askyourdata—createqueriesLesson:GetanswersfromyourdataEachlessonincludesalistofsuggestedtasks
2、andasetoftestquestions.BuildadatabaseIV:CreatequeriesforanewAccessdatabaseOverview:Askyourdata—createqueriesIt’stimetocreatequeries,oneofthemostpowerfultoolsinyourdatabase.Sayyouwanttoknowhowmanycomputersyouown.Youcanbuildaquerytofetchthatdataandtotalthenumbers.Queriescanalsoprovi
3、dedataforyourformsandreports,whichcanhelpmakeyourdatabaseeasiertobuildanduse.Thiscourseintroducesqueriesandexplainshowtocreatethemostcommontype,aselectquery.BuildadatabaseIV:CreatequeriesforanewAccessdatabaseCoursegoalsUsetheQueryDesignertocreateaselectquerythatreturnsdatafromasin
4、gletable.Createaselectquerythatasksyoutoenterparameters,thenreturnsresultsthatmatchthoseparameters.Useaformulainaquerytocalculateasum.UsetheQueryWizardtocreateaselectquerythatreturnsdatafromtwotables.Useatextexpressiontoconcatenatefields.LessonGetanswersfromyourdataBuildadatabaseI
5、V:CreatequeriesforanewAccessdatabaseGetanswersfromyourdataYournewasset-trackingdatabaseiscomingalong.Youhavetables,relationships,anddata,sothenextstepistobuildsomequeries.Specifically,you’llcreateselectqueries.They’recomponentsthatretrieveandprocessyourdataanddisplaytheresultsinad
6、atasheet.Thequeryinthepicturetakesassetdatafromthefirsttable,thenamesoftechniciansfromthesecondtable,anddisplaystheresultinawaythatyoucanconsume.BuildadatabaseIV:CreatequeriesforanewAccessdatabaseThebasicsofcreatingselectqueriesAccessprovidestwoprimarywaystocreateselectqueries—the
7、QueryWizardandtheQueryDesigner.Regardlessofthetoolyouuse,youfollowsomecommonstepstocreatethequery.Startbychoosingarecordsourceforthequery.Arecordsourcecanbeoneormoretables,oneormorequeries,oracombinationofthetwo.Fromtherecordsource,selectthefieldsthatyouwanttoseeinthequery.Buildad
8、atabaseIV:CreatequeriesforanewAcc
此文档下载收益归作者所有