在Access中已建立了“工资”表，表中包括“职工号”、“所在单位”、“基本工资”和“应发工资”等字段，如果要按单位统计应发工资总数，那么在查询设计视图的“所在单位”的“总计”行和“应发工资”的“总计”行中分别选择的是______。
A．sum，group by
B．count，group by
C．group by，sum
D．group by，count
参考答案：C
解析： 在“设计”视图中，将“所在单位”的“总计”行设置成group by，将“应发工资”的“总计”行设置成sum，就可以按单位统计应发工资总数了。其中的 group by的作用是定义要执行计算的组；sum的作用是返回字符表达式中值的总和；而count的作用是返回表达式中值的个数，即统计记录个数。
| 完形填空。 | |||
| Mrs. Jones was over eighty, but she still drove her old car like a woman half her age. She loved driving very fast, and was proud of the fact 1 she had never, in her thirty-five years of driving, been punished 2 a driving offence (犯规,犯法). Then one day she nearly 3 her record. A police car 4 her, and the policemen in it saw her 5 a red light without stopping. Of course, she was stopped. It seemed 6 that she would be punished. 7 Mrs. Jones came up to the judge, he looked at her seriously and said that she was 8 old to drive a car, and that the 9 why she had not stopped at the red 10 was most probably that her eyes had become weak 11 old age, so that she had simply not seen it. When the judge had finished what he was 12 , Mrs. Jones opened the big handbag she was 13 and took out her sewing. Without saying a word, she 14 a needle (针) with a very small eye, and threaded it at her first attempt. When she had 15 done this, she took the thread (n.线) out of the needle again and handed 16 the needle and the thread to the judge, saying, "Now it is your 17 . I suppose you drive a car, and that you are quite sure about your own eyesight." The judge took the 18 and tried to thread it. After half a dozen tries, he had still not succeeded. The case (案例) against Mrs. Jones was 19 , and her record 20 unbroken. | |||
| ( )1. A. which ( )2. A. about ( )3. A. kept ( )4. A. watched ( )5. A. pass ( )6. A. sure ( )7. A. Before ( )8. A. so ( )9. A. cause ( )10. A. light ( )11. A. with ( )12. A. speaking ( )13. A. holding ( )14. A. took ( )15. A. almost ( )16. A. both ( )17. A. time ( )18. A. thread ( )19. A. dismissed ( )20. A. was | B. when B. on B. won B. after B. go B. indeed B. While B. very B. reason B. lamp B. because B. saying B. getting B. brought B. hardly B. all B. turn B. glasses B. passed B. kept | C. that C. to C. missed C. followed C. run C. certain C. Until C. too C. matter C. sign C. for C. talking C. carrying C. picked C. successfully C. neither C. chance C. needles C. settled C. seemed | D. this D. for D. lost D. ran after D. rush D. perhaps D. When D. quite D. trouble D. one D. of D. telling D. bringing D. chose D. successful D. either D. job D. needle D. studied D. remained |