简答题:在“Acc2.mdb”数据库中有“入学登记表”、“系”和“专业”3张表。 (1)以“入学登记表”、“系”和“专业”表为数

  • 题目分类:Access
  • 题目类型:简答题
  • 查看权限:VIP
题目内容:
在“Acc2.mdb”数据库中有“入学登记表”、“系”和“专业”3张表。
(1)以“入学登记表”、“系”和“专业”表为数据源,创建查询“查询1”,实现查询每个系的最高高考分数。结果显示系名称和最高分字段,最高分一[入学登记表].[高考分数]之Sum。查询结果如图1所示。

(2)以“入学登记表”为数据源,创建查询“查询2”,实现查询1980年和1981年之间出生的考生信息。结果显示“姓名”、“性别”、“出生年月日”、“高考所在地”和“高考分数”字段。查询结果如图2所示。

参考答案:
答案解析:

A 15% ~ 20% drop in body water can cause the blood system to

A 15% ~ 20% drop in body water can cause the blood system to fail. TRUE/FALSE

查看答案

For many university students there are two alternatives: one

For many university students there are two alternatives: one is to find a job, t

查看答案

From the text we can see that the author seems______

From the text we can see that the author seems______A.optimistic B.pessimistic C

查看答案

Ed' s encounter with the recycling team shows that ______

Ed' s encounter with the recycling team shows that ______A.Ed was desperate to c

查看答案

How many poems did Dickinson write?

How many poems did Dickinson write?A.Almost 2,000. B.Nearly 1,000. C.800. D.1,20

查看答案