在下有“学生．mdb”数据库。
(1)以课程成绩表为数据源，创建分组统计查询’“平均分”，统计每个学生的平均分，结果显示学号和平均分字段，按照平均分降序排列。
(2)以学生表为数据源，创建“学生”窗体，布局为“纵栏表”，样式为“标准”。在窗体中添加以“平均分”查询为数据源的子窗体，在窗体显示“平均分”查询的全部信息。学生窗体结果显示入如图所示。
参考答案：
| 完形填空。 | ||||
| When Mary Smith was a student, she wanted to be a 1___________ 2___________ she liked children. When she was twenty 3___________, she taught (教学) in a small school. She was a good teacher, and she 4___________ a lot with her children in her class. They loved her very much. One day, a girl in her class 5___________ to her, " Miss Smith, why does a man's hair become grey (灰白色) before his beard (胡子) does? " Mary laughed and said, " I don't know. Helen, do you know? " " Sorry, but it happened 6___________ my father." The other 7___________ laughed when they heard this. Then a boy said, " I 8___________, Miss Smith! A man's hair becomes grey 9___________ because it's sixteen years older 10___________ his beard! "
|