问题 单项选择题

在Access的数据库中已建立了"tBook"表,若查找“图书编号”是“112266”和“113388”的记录,应在查询设计视图准则行中输入_______。

A."112266"and"113388"

B.not in("112266","113388")

C.in("112266","113388")

D.not("112266" and "113388")

答案

参考答案:C

解析:[知识点] 查询准则[评析] 在查询准则中,特殊运算符In是用于指定一个字段值的列表,列表中的任意一个值都可与查询的字段想匹配。本题的查询准则可以写成in("112266","113388"),或者写成"112266',Or"113388"。 所以本题答案为C。

完形填空

短文填空 阅读下面一段短文,然后在空白处写出适当的单词,单词首字母已经给出。[有的词请注意词形的变化!] (共12个空,做对一个得1分,共10分)

Everyone needs friends. We all like to feel close to someone. We can share 小题1:s      with our friends and turn to them for help when we are in trouble. In a word, it is nice to have a friend to 小题2:t     , laugh and do things with. Certainly, sometimes we need to be alone. We don’t always want people around. But we would feel 小题3:l      if we never had a friend.

To make 小题4:f     , you must be friendly. A cheerful person smiles. A smile always makes the others like you. Smile at someone and you are sure to get a smile 小题5:b      from him.

Try to remember names. It 小题6:m      your new friends feel happy when you call them by their names, 小题7:b      you don’t forget them.

No two people are just the same. If you don’t agree with other people, you should still be friendly. Do not argue, but 小题8:d     . You always lose friends if you argue too much. And you should think more of others than 小题9:o      yourself. It’s good for teenagers to have one or a group of good friends. This is very 小题10:     in children’s growing up, because friends can discuss things which are too difficult to say to their family members.

There’s more good news for people who have friends. They live 小题11:l      than people who don’t have. Why? It could be that they小题12:a      happier. Being happy helps you stay well and it could be good just knowing that someone cares about you.

单项选择题 案例分析题