经典传奇热血传奇装备补丁195真龙合击.ppt

Microsoft Access 2013Obtain Valuable Information Using QueriesChapter 4Chapter OverviewmQuery Criteria –Like, In, And, Or, Between, Null, Relational Operators (>,<,>=,<=,=,<>)mGrouping and Sorting–Avg, Min, Max, Count, SummAdvanced Query Topics–Unmatched and Parameter Queries, Concatenation, IIf, Update QueriesQueriesmAllow you to ask questions (queries) about data in the , Crosstab, Make Table, Update, Append, DeletemDatasheet, Design and SQL viewWho is in MGS351?Who is in MGS351 sorted by person number?Who are Juniors in MGS351?How many Seniors are in MGS351?How many Seniors are in MGS351? (Better way)How many Fr, So, Jr and Sr students are in MGS351?Who has resigned the class?