问题 问答题

“成绩管理”数据库中含有三个数据库表学生、分数和课程。为了对“成绩管理”数据库数据进行查询,设计一个表单my,表单标题为“成绩查询”;表单有“查询”和“关闭”两个命令按钮。 表单运行时,单击“查询”按钮,查询每门课程的最高分,查询结果中含“课程名”和“最高分”字段,结果按课程名升序保存在表myt中。 单击“关闭”按钮,关闭表单。

答案

参考答案:

解析:在命令窗口中输入命令:CREATE FORM my,打开表单设计器,通过“表单控件”工具栏向表单添加 2个命令按钮。选中表单,在属性面板中修改Caption的属性值为“成绩查询”,在属性面板顶端的下拉框中选择Command1,修改该命令按钮控件的Caption属性值为“查询”,选择Command2,修改该命令按钮控件的Caption属性值为“关闭”。 双击“查询”按钮,在Click事件中编写程序命令: ******命令按钮Command1(查询)的Click事件代码***** SELECT课程名,MAX(成绩)AS最高分; FROM课程,成绩; WHERE课程.课程号=成绩,课程号; GROUP BY课程.课程号; INTO TABLE myt ******************************************************* 最后双击“关闭”按钮,在Click事件中编写程序命令:Thisform.Release。保存并运行表单。通过BROWSE命令可查看查询结果,如图3-45所示。 本大题考查了表单设计,在设计控件属性时,不要将控件的标题和名称属性弄混淆了;程序部分考查了MAX函数的应用,考生应该熟悉各种函数的应用以及GROUP BY与ORDER BY的区别。

阅读理解

BEIJING, Oct. 8(Xinhua)——There are ten times as many Chinese newspapers and magazines than there were 30 years ago. That’s when the country adopted the reform and opening-up policy.

Figures from the General Administration of Press and Publication (GAPP)show there were 186 newspapers and 930 magazines in China in 1978. Today, the country has 2,081 newspapers and 9,363 different magazines.

In the meantime, official figures show China has some 600 publishing houses producing nearly 300,000 kinds of books. That’s a dramatic increase from the 105 publishers of the past that produced only 10,000 different books.

Rapid economic development and universal education since China adopted the reform has helped fuel the need for more information sources.

Under the market economy, hundreds of publishing houses and newspapers have taken steps to restructure management systems into corporations listed on the stock market.

The legal system overseeing the news and publishing industries in China has also changed over the last three decades. Since 1990 a law and five relevant(相关) regulations were adopted in 1990 to govern the sectors.

Since it started in 1993, digital publishing has flourished. Its industrial volume amounted to 20 billion yuan (2.93 billion U.S. dollars) in 2006. More than 500,000 kinds of digital books were produced last year alone in China, which is more than any other country in the world.

小题1:Which of the following would be the best title for the text?

A.Digital books take the place of common ones in China.

B.China has more newspapers and magazines.

C.More information sources are developing with the economy.

D.A law should be adopted to govern the publishing industries.小题2:There are ten times as many newspapers and magazines because ________.

A.the publishing houses want to make more money.

B.there are more readers along with the bigger population.

C.economic and education have developed under the policy.

D.the legal system overseeing the publishing industries has changed.小题3:Which is true according to this text?

A.The development of publishing industry in the past was out of control.

B.Hundreds of publishing houses have closed down and turned to stock market.

C.China adopted the reform and opening-up policy about 20 years ago.

D.China produces more digital books than any other country.小题4: The underlined word “flourished” in Paragraph 7 probably means ________.

A.first appeared

B.fell down

C.well developed

D.successfully ended小题5: You will probably read this text in the ________ column of XINHUA NET?

A.culture and education

B.entertainment

C.science and technology

D.business

单项选择题