经典传奇热血传奇装备补丁195真龙合击-课件【PPT演示稿】.ppt

Microsoft Access 2013 Obtain Valuable Information Using Queries Chapter 4 Chapter Overview m Query Criteria – Like, In, And, Or, Between, Null, Relational Operators (>,<,>=,<=,=,<>) m Grouping and Sorting – Avg, Min, Max, Count, Sum m Advanced Query Topics – Unmatched and Parameter Queries, Concatenation, IIf, Update Queries Queries m Allow you to ask questions (queries) about data in the database. m Select, Crosstab, Make Table, Update, Append, Delete m Datasheet, Design and SQL view Who 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?