问题 问答题

根据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。 本大题考查的主要是数据库和数据库表的一些基本操作,为数据表建立索引、增加字段和设置有效性规则都是在数据表设计器中完成的,建立数据表之间的关联则是在数据库设计器中完成的。

阅读理解

阅读理解。

     In Western countries people have been using the installment plan since the first half of the twentieth

century. Today, a large number of families in Great Britain buy furniture, household goods and cars by

installments. In the U. S., the figure is much higher than in Great Britain, and people there spend over 10

percent of their income on the installment plan.

     The price of an article bought on installments is always higher than the price that would be paid by cash.

There is a charge for interest. The buyer pays one quarter or one third of the price as a down payment when

the goods are delivered to him. He then makes regular payments, weekly or monthly, until the full price is paid

up. The legal ownership of the goods remains with the seller until the final payment has been made.

     Installment buying has advantages and disadvantages. It can help couples with small incomes to furnish

their homes and start housekeeping. It increases the demand for goods, and in this way helps business and

employment. There is, however, the danger that when business is bad, installment buying may end suddenly,

making business much worse. This may result in a great increase in unemployment. If the people on the

installment plan lose their jobs, they will probably not be able to make their payments. If great numbers of

people are not able to pay their installment debts there is a possibility that businessmen cannot collect their

debts and will therefore lose money. If businessmen lose money or fail to make a satisfactory profit, it

becomes more likely to have a depression. This is why, in some countries, the government controls the

installment plan by fixing the amount of the down payment and installments to discourage people from

buying more than they can pay for on the installment plan.

1. Which of the following is NOT true about the installment plan? [ ]

A. A lot of British families use the installment plan.

B. More than 10 percent American families buy things on installments.

C. Americans depend more on installment than British people do.

D. Americans spend one tenth of their income on installment buying.

2. Goods bought on installments are more expensive than goods bought by cash because _____. [ ]

A. the buyer has to pay extra money as interest

B. the delivery of the goods charges extra money

C. the buyer has to pay a down payment

D. the service offered by installment plan charged extra money

3. What will happen to a buyer if he fails to make the full payment for an item bought on installments? [ ]

A. He might lose his job.

B. He will stop owning the item he has bought.

C. He will have to sell what he has bought.

D. He will go into debt.

4. The advantage of installment buying might include all the following EXCEPT that _____. [ ]

A. purchasing power is strengthened

B. employment might be increased

C. people develop a good habit of saving money

D. young couples are able to furnish their homes

5. In some countries, the governments control the installment plan to _____. [ ]

A. increase employment

B. avoid depressions

C. ensure that businesses make good profits

D. ensure that people can pay for what hey buy

判断题