问题 问答题

在考生文件夹下有一个数据库文件“samp3.mdb”,已建立了两个关联表对象(“档案表”和“工资表”)和一个查询对象“qT”,请按以下要求,完成报表的各种操作。

“基本工资”的“平均值”计算控件名称为“savg”,“总和”计算控件名称为“ssum”。按职称汇总出“基本工资”的平均值和总和。
注意:请在组页脚处添加计算控件。

答案

参考答案:[微步骤]
步骤1:执行菜单栏中的“视图→排序与分组”命令,在“字段/表达式”下拉列表选项中单击“职称”,在“组页眉”和“组页脚”右侧下拉列表中均选择“是”,关闭界面。
步骤2:选中报表主体节区的“职称”字段,按住鼠标左键,拖动鼠标到“职称页眉”,放开鼠标。
步骤3:单击工具箱中的“文本框”控件,再单击报表“职称页脚”节区的适当位置,弹出“Text”和“未绑定”两个文本框。
步骤4:用鼠标右击“Text”文本框,在弹出的快捷菜单中选择“属性”命令,在“标题”行中输入“基本工资平均值”,关闭属性界面。
步骤5:用鼠标右击“未绑定”文本框,在弹出的快捷菜单中选择“属性”命令,在“名称”行中输入“savg”,在“控件来源”行中输入“Avg([基本工资])”,关闭属性界面。
步骤6:按照上述步骤3~步骤5的方法添加另一个计算控件。在“名称”行中输入“ssum”,在“控件来源”行中输入“Sum[基本工资]”。

完形填空
One day Daddy and I went out    1    a walk. On the way we   2   a lot of people. We went up and   3   a look. Oh, dear!   4  did we see? There   5   a donkey(驴) in the middle of the road. It would not move. The cars and buses could not get    6  .
Then a policeman came. "   7  donkey is this?" he asked. "It' s   8   ," said a farmer, "but I   9  move it. " The policeman and the farmer did  10  best to move the donkey, but it would not move. We laughed, but the   11   of the cars and the buses were    12   . "We can't move the donkey," the farmer and the policeman said. "What shall we do?"
"Give him a carrot," my father said.
"   13  a good idea!" said the farmer.
Soon he found a    14   and showed it to the donkey. When the donkey saw a carrot, it jumped up and walked after the farmer.   15   the cars and buses could get past at last.
小题1:
A.forB.fromC.atD.on
小题2:
A.saw B.looked C.looked for D.watched
小题3:
A.enjoyed B.had C.played D.gave
小题4:
A.When B.Where C.What D.Which
小题5:
A.is B.was C.has D.had
小题6:
A.pastB.toC.onD.up
小题7:
A.Who B.Who's C.Which's D.Whose
小题8:
A.mineB.meC.youD.my
小题9:
A.can B.can't C.could D.couldn't
小题10:
A.his B.her C.their D.its
小题11:
A.drivers B.workers C.riders D.teachers
小题12:
A.worriedB.happyC.gladD.pleased
小题13:
A.He's B.She's C.Which is D.That's
小题14:
A.carrotB.catC.dogD.camel
小题15:
A.Some of B.Little of C.All D.Few of
单项选择题