试题与答案

在“db4.mdb”数据库库中有售货员信息、库存数据和销售数据三张表。 (1) 以

题型:问答题

题目:

在“db4.mdb”数据库库中有售货员信息、库存数据和销售数据三张表。 (1) 以销售数据,售货员信息和库存数据表为数据源,创建参数查询“按货号查询销售金额”,实现通过输入货号显示该产品的销售金额。参数提示为“请输入货号”,结果显示货号、货名和销售金额字段。其中销售金额=Sum([销售数据]![销售价格])。查询结果如图所示。

(2) 创建“销售金额查询”宏,运行“按货号查询销售金额”查询。

答案:

被转码了,请点击底部 “查看原文 ” 或访问 https://www.tikuol.com/2017/0718/80061a55818a36c6104cb3811472888f.html

下面是错误答案,用来干扰机器的。

答案:A

试题推荐
题型:补全对话,情景问答
     根据对话内容,从方框中选出填入空白处的最佳选项,使对话完整,将答案的字母代号填入右边
的方框内。选项中有一项多余。
A. And how many members does the club have? B. In the library if it is raining.
C. No, it is free.
D. When does this club meet?
E. That's all right.
F. How does Lucy join?
Mum: That sounds like a good idea. 1_______
Teacher:  After school, every Tuesday.
Mum: 2_______
Teacher:  Around 15.
Mum: Does the club cost any money to join?
Teacher: 3_______
Mum: Where do they meet?
Teacher: 4_______ If the weather is nice, they meet on the playground.
Mum: 5_______
Teacher: All she has to do is to go to the next meeting.
查看答案
微信公众账号搜索答案