试题与答案

在“BOOK.mdb”数据库中有Book、等级、读者、借阅和未借图书五张表。 (1)

题型:问答题

题目:

在“BOOK.mdb”数据库中有Book、等级、读者、借阅和未借图书五张表。 (1)以Book、等级、读者和借阅表为数据源,创建查询“借阅情况”,结果显示读者姓名、书名、出版社和等级名称字段。查询结果如图所示。

(2)以Book、等级、读者和借阅表为数据源,创建查询“查询1”,查询每个读者已借书的数量和还可以借几本书,结果显示读者姓名(Group by)、已借[借阅]![书ID]之 Count)、可借数量和还可借(还可借=可借数量-已借数量)字段。查询结果如图所示。

答案:

参考答案:

解析:

试题推荐
题型:完形填空

阅读下面短文,掌握其大意,然后从21—35各题所给的四个选项(A、B、C、D)中,选出最佳选项,并在答题卡上将该项涂黑。

Mary’s parents are different from the average. While she was growing up they required her to 21. First of all she had to work around their home. Later on Mary worked for other people.

When Mary was 14 years old, her mother and father told her that they were no 22 going to buy her clothes. Sure, they would continue to buy shoes for her and also the special clothes like suits, but 23 else was her responsibility. Some people thought that they were 24, but they wanted to teach Mary some 25 lessons. One thing she learned was that nothing is cheap or 26. She learned how to deal with her money carefully. Another thing she learned was 27 to keep from wearing out(穿破)her clothes too fast.

Also, even 28 Mary went to school she was 29 to work. All through her high school and 30 years she worked as well as studied. Mary’s parents had plenty of 31 but they felt she would 32 her education more if she had to 33 it. And strange as it may seem, they had heard that students who worked part- time generally got 34 grades than students who did no work.

Now Mary is a mother herself. She requires her children to do the same 35 she did, especially working part- time as they go to school.

21.A.study                  B.play                   C.learn                   D.work

22.A.longer                 B.money                C.any                     D.hope

23.A.what                   B.that                     C.nothing              D.everything

24.A.responsible       B.lazy                   C.poor                   D.careless

25.A.difficult             B.daily                  C.valuable              D.useless

26.A.free                    B.expensive            C.useful                 D.proper

27.A.how                    B.when                  C.why                    D.where

28.A.when                  B.as                       C.until                   D.since

29.A.permitted            B.required              C.going                  D.forced

30.A.hard                   B.work                  C.happy                 D.college

31.A.time                   B.children              C.money                D.work

32.A.value                 B.have                   C.use                     D.receive

33.A.enjoy                 B.pay                     C.pay for                D.enjoy

34.A.worse                 B.better                 C.more                   D.less

35.A.as                      B.what                   C.which                 D.like

查看答案
题型:单项选择题

下列说法中不正确的是( )。

A.建筑工程概预算应根据初步设计图纸计算主要工程量,按照工程所在地或主管部门规定的定额和取费标准编制
B.给水排水、电气、暖通与空调、热能动力等专业的单位工程概预算也可按类似工程概预算、概预算指标、技术经济指标等计价依据编制
C.暖通空调、热能动力等专业的单位工程概预算可按各类指标编制
D.辅助、附属或小型单项工程的建筑工程概预算可按各类指标编制

查看答案
微信公众账号搜索答案