1、首先,打开access数据库软件,再打开你的表格文件。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4ec2d5628535e5dd2b303e5778c6a7efce1b621e?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/8644ebf81a4c510f48dc79926e59252dd42aa51a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、这时弹出新建查询对话框,选择【查找不匹配项查询向导】。点击【确定】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a044ad345982b2b762bea34c3fadcbef76099b11?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、选择【学生信息表】,点击【下一步】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/80cb39dbb6fd5266cf3da69ca518972bd4073627?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、选择另一个表即【学生成绩表】,点击【下一步】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c83d70cf3bc79f3dfaf860b8b4a1cd11728b2918?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/5fdf8db1cb134954e8316cec584e9258d1094a0f?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/cc11728b4710b912c0f57176cdfdfc0392452205?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、这时,可以改一下查询表的名称,如果不需要改变就直接点击【完成】即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6609c93d70cf3bc799095464df00baa1cd112a28?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
9、这样,没有考试成绩的就可以查询出来了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/96dda144ad34598206827c1a02f431adcbef842a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)