在考生文件夹下有一个数据库文件“samp2.mdb”，其中存在已经设_爱下问搜题

搜题请搜索小程序“爱下问搜题”

问题问答题

在考生文件夹下有一个数据库文件“samp2.mdb”，其中存在已经设计好的表对象“tStud”和“tTemp”。tStud表是学校历年来招收的学生的名单，每名学生均有身份证号。对于“在校学生”，均有家长身份证号；对于已经毕业的学生，家长身份证号为空。

例如，表中学生“张春节”没有家长身份证号，表示张春节已经从本校毕业，是“校友”。

表中学生“李强”的家长身份证号为“110107196201012370”，表示李强为在校学生。由于在tStud表中，身份证号“110107196201012370”对应的学生姓名是“李永飞”，表示李强的家长是李永飞，而李永飞是本校校友。

“张夭”的家长身份证号为“110108196510015760”，表示张天是在校学生；由于在tStud表中身份证号“110108196510015760”没有对应的记录，表示张天的家长不是本校的校友。

请按下列要求完成设计。

创建一个查询，‘要求按照身份证号码找出所有家长是本校校友的学生记录。输出学生身份证号、姓名及家长身份证号3列内容，标题显示为“身份证号”、“姓名”和“家长身份证号”，将查询命名为“qT2”。

答案

参考答案：

[微步骤]

步骤1：先单击“查询”对象，再单击“新建”按钮，选中“查找不匹配查询”，单击“确定”按钮。在“显示表”对话框中双击“tStud”表，关闭“显示表”对话框。

步骤2：分别双击“身份证号”、“姓名”和“家长身份证号”字段，将其全部添加到“字段”行。

步骤3：在“家长身份证号”字段对应的“条件”行中输入“In(SELECT[身份证号]FROM[tStud])”，如图9.10所示。

步骤4：单击“保存”按钮

，将该查询命名为“qT2”。关闭设计视图。

选择题

No conclusion _________ about the new product until the result of the experiment has been announced.

A．is drawn

B．was drawn

C．will be drawn

D．has been drawn

完形填空

完型填空（共20小题；每小题1.5分，满分30分）
阅读下面短文，掌握其大意，然后从36—55各题所给的四个选项（A、B、C和D）中，选出最佳选项，并在答题卡上将该项涂黑。
LAST weekend, I helped my friend Alex get money for poor children at Crossroads Mall He 36 needed volunteers, especially of the female. I decided that this was a pretty good 37 , so the next day I got ready to go.
I arrived at Crossroads about five minutes 38 , and helped Alex and   39 of the volunteers. There were only three 40 at first, and we figured we might as well get started 41 just waiting for more to arrive. I held the   42 , and suddenly felt extremely shy. I did not 43 asking people for donations. In fact, I’m usually one of those people who try to   44 those boring stands and ask you for a little contribution. For heaven’s sake, I can contribute to a few,   45 I cannot alone 46 every single cause in the world!
I really didn’t like the idea of asking anyone for donations to our cause.   47 , I watched my friends speak to the strangers, and noticed that they were extra polite to everyone—no matter whether they 48 . I realized that   49 I wasn’t pushy（强求的）, it would be okay, and my conscience could be 50 .
I pasted on a large smile, and started asking people passing by. My mouth tripped over words, and I continually said “um” while I thought of the correct terms.   51 I talked to more and more people. Not only improved, but also started noticing small 52 . Instead of saying “donate”, which made most people walk away 53 .I started suing the word “contribute”. I added the phrase “every little bit counts”, and people started to donate small amounts in larger quantities. As the day went on, I learned how to pull on the hearts of the   54 , and I became a successful fundraiser.
At the end of the day, we all gathered at Alex’s house and   55 how much money we raised. I was so surprised; We raised over $300! We celebrated, and went home tired, but satisfied that we helped a great cause.

C．desperately

A．passers—by

C．in spite of

D．in place of

A．What’s more

D．as short as

B．with happiness

D．in surprise