1、首先,打开数据库文件。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/377adab44aed2e730cafc8a28901a18b86d6fafe?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在【创建】功能区的【查询】分组中单击“查询设计”按钮,系统弹出查询设计器。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/faedab64034f78f09a49d47d77310a55b2191cf9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在【显示表】对话框中双击表“tScore”,关闭【显示表】对话框。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/38dbb6fd5266d0165da0d0a6992bd40734fa3586?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、分别双击“tScore”表中的“学号”和“成绩”字段。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d52a2834349b033b91c5b4541bce36d3d439bdeb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、单击【显示/隐藏】分组中的“汇总”按钮,在“成绩”字段的“总计”行下拉列表中选中“平均值”,在“排序”行选中“降序”,在“学号”字段的“总计”行下拉列表中选中“Group By”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a464a6dc3b76563f6246a60aff5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、在“成绩”字段的“字段”行前面添加“平均分:”字样。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8773912b31bb0518578f9a6387adab44bede0e4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、点击“视图”按钮,查看结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4ec2d5628535e5dd1d73105178c6a7efcf1b62e5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)