问题 问答题

根据score数据库,使用查询向导建立一个含有学生“姓名”和“出生日期”的标准查询query31.qpr。 (2)从score数据库中删除视图newview。 (3)用SQL命令向score1表插入一条记录:学号为“993503433”、课程号为“0001”、成绩为“99”。 (4)打开表单myform34,向其中添加一个“关闭”命令按钮(名称为Command1),单击此按钮关闭表单(不可以有多余的命令)。

答案

参考答案:

解析:(1)选择“文件”—“新建”菜单命令,在弹出的“新建”对话框中,选择“查询”,单击“向导”按钮,根据向导的提示,首先选择表student 作为查询的数据源,然后选择student 表的姓名、出生日期字段为选定字段,连续单击下一步,直至“完成”界面,单击“完成”命令按钮,输入保存的查询名为query31。 (2)在命令窗口输入命令:MODIFY DATABASE score,打开数据库设计器,在数据库设计器中的“newview”视图上单击右键,在弹出的菜单中选择“删除”,并在弹出的对话框中选择“移去”。 (3)在命令窗口输入如下命令,为score1表增加一条记录。 INSERT INTO score1(学号,课程号,成绩)VALUES("993503433","0001",99) (4)打开表单后,添加表单控件工具栏中的命令按钮到表单,在属性面板中修改该命令按钮的Caption属性值为“关闭”,双击该按钮,在Click 事件中输入代码:Thisform. Release。 本大题考查的主要是数据库和数据库表的一些基本操作,为数据表建立索引、增加字段和设置有效性规则都是在数据表设计器中完成的,建立数据表之间的关联则是在数据库设计器中完成的。

完形填空

阅读下面的材料,然后根据材料内容回答问题。

Family members of Chinese people on the Malaysia Airlines Flight MH370 had a candlelight prayer ceremony(祈祷仪式) at the Beijing Lido Hotel on Tuesday for all those on the plane.

They lit 239 candles, each standing for one person. The ceremony started at 0:41 a.m., it was the time the plane began its flying from Kuala Lumpur to Beijing before disappearing(消失) on March 8. When the ceremony ended at 8:11 am, the last time the plane sent signals to a satellite(卫星), a lady cried and fell down on the floor because her husband was on the plane. Then, other people had to take her away from the prayer room to the hospital.

In the past month, the family members felt both hopeful and hopeless. People are not sure where the plane is, because no debris(残骸) from the plane has been found. They said they needed more information about the search from Malaysia Airlines and the Malaysian government.

小题1:Where did people have the ceremony?

_____________________________________________________________________________

小题2:What time did the ceremony start?

_____________________________________________________________________________

小题3:Why did that lady cry and fall down?

_____________________________________________________________________________

小题4:How did those people feel in the past month?

_____________________________________________________________________________

小题5:What did they need from Malaysia Airlines and the Malaysian government?

_____________________________________________________________________________

判断题