资源描述：
《经典传奇热血传奇装备补丁195真龙合击.ppt》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、MicrosoftAccess2013ObtainValuableInformationUsingQueriesChapter4ChapterOverviewQueryCriteriaLike,In,And,Or,Between,Null,RelationalOperators(>,<,>=,<=,=,<>)GroupingandSortingAvg,Min,Max,Count,SumAdvancedQueryTopicsUnmatchedandParameterQueries,Concatenation,IIf,Upd
2、ateQueriesQueriesAllowyoutoaskquestions(queries)aboutdatainthedatabase.Select,Crosstab,MakeTable,Update,Append,DeleteDatasheet,DesignandSQLviewWhoisinMGS351?WhoisinMGS351 sortedbypersonnumber?WhoareJuniorsinMGS351?HowmanySeniorsare inMGS351?HowmanySeniorsare inMG
3、S351?(Betterway)HowmanyFr,So,Jrand SrstudentsareinMGS351?Whohasresignedtheclass?Whodoesn’thavea gradeyet?Whohasalastname beginningwiththeletterM?*representsanything(manycharacters)ornothing?representsanysinglecharacterWhohasafirstname beginningwiththeletterS?*rep
4、resentsanything(manycharacters)ornothing?representsanysinglecharacterWhohasalastname sixcharacterslong?*representsanything(manycharacters)ornothing?representsanysinglecharacterWhohasaGPAgreater than3.5?WhohasaGPA between3.2and3.5?WhoisaSeniorOR Accountingmajor?Wh
5、oisaSeniorAND Accountingmajor?WhoisanAcct(MGA) orMgmt(MG)major?WhoisanAcct(MGA) orMgmt(MG)major?WhoisaJrorSrand aMgmt(MG)major?WhoisaJrorSrand aMgmt(MG)major?WhoisaJrorSranda(MG)majorwithagradeofAorB?WhoisanotaFreshman?WhoisaFr,SoorJr?WhoisaFr,SoorJr?AdvancedQuer
6、yTopicsUnmatchedQueriesIdentifiesrecordsinonetablethatdon’texistinanotherWhatproductshaveneverbeenordered?Whatstudentshaven’tregistered?ParameterizedQueriesThecriteriaisdynamic–everytimeaparameterizedqueryisrun,theuserispromptedtoenterthecriteriavaluetheywanttous
7、e.Whatistheclassandmajor foraspecificpersonnumber?ConcatenationCanbeusedtocombinemultiplequeryfieldstogether,ortoaddextraformattinginaquery.Whatexpressionwillgeneratethisoutput?Studentname(Major)DavidMurray(MG)ConcatenationExampleAmpersandsymbol&isusedtocombinefi
8、eldsandtext.Alltextshouldbeenclosedin“doublequotes”HW3-Ch5AppliedStep4GPA:3.7–Grade:AGPA:3.7–Grade:ASpaceSpaceSpaceSpaceIIFExpressionUsetoconditionallyevaluate
