问题 问答题

(1)设计表单my,其中有三个按钮,标题分别为“汇报”、“查看”和“关闭”。单击“汇报”按钮,弹出对话框“您单击的是汇报按钮!”。单击“查看”按钮,弹出对话框“您单击的是查看按钮!”。单击“关闭”按钮则退出表单。
(2)根据“定货”表和“客户”表建立一个查询cha,查询出所有所在地是“上海”的公司的“公司名称”、“订单日期”、“送货方式”,要求查询去向是表,表名是que.dbf,并执行该查询。

答案

参考答案:(1)在命令窗口输入命令:MODIFY FORM my,打开表单设计器新建表单。
单击“表单控件”窗口中的“命令按钮”控件,在表单上放置三个命令按钮控件,将它们的Caption属性值分别改为“汇报”,“查看”和“关闭”,分别编写3个命令按钮的Click事件代码。
******命令按钮Command1(汇报)的Click事件代码******
MESSAGEBOX(“您单击的是汇报按钮!”)
*************************************************
*****命令按钮Command2(查看)的Click事件代码*****
MESSAGEBOX(“您单击的是查看按钮!”)
*************************************************
*****命令按钮Command3(关闭)的Click事件代码*****
Thisform.Release
*************************************************
保存表单设计,在命令窗口输入命令:DO FORM my,运行表单,查看表单运行结果。
(2)在命令窗口输入:CREATE QUERY cha,打开查询设计器,新建一个查询。在查询设计器中,分别将“客户”和“定货”两个数据表文件添加到查询设计器中,系统自动查找两个数据表中匹配的字段进行内部联接,单击“确定”按钮,如图3-66所示。
[*]
在查询设计器中的“字段”选项卡中,将“可用字段”列表框中的“客户.公司名称”、“定货.定单日期”和“定货.送货方式”三个字段添加到右边的“选定字段”列表框中,在“筛选”选项卡的“字段名”下拉框中选择“客户.所在地”,在“条件”下拉框中选择“=”,在实例文本框中输入“上海”。执行菜单命令“查询”—“查询去向”,系统弹出“查询去向”对话框,单击“表”按钮,在“表名”文件框中输入表名que,单击“确定”退出,如图3-67所示。
[*]
执行菜单“查询”—“运行查询”,查询结果将自动保存到que数据表中。

解析: 本大题1小题主要考查的是表单中一些基本控件的建立、属性的设置以及简单程序的编写,属性设置可以直接在属性面板中修改。2小题考查的是多表查询文件的建立以及查询去向。在设置查询去向的时候,应该注意表的选择。

阅读理解

Art museums are places where people can learn about various cultures. The increasingly popular "design museums" that are opening today, however, perform quite a different role. Unlike most art museums, the design museum shows objects that are easily found by the general public These museums sometimes even place things like fridges and washing machines in the center of the hall

Pele have argued that design museums are often made use of as advertisements for new industrial technology. But their role is not simply a matter of sales-it is the honoring of excellently invented products. The difference between the window of a department store and the showcase in a design museum is that the first tries to sell you something, while the second tells you the success of a sale.

One advantage of design museums is that they are places where people feel familiar with the exhihits. Unlike the average art museum visitors, design museum visitors seldom feel frightened or puzzled. This is partly because design museums clearly show how and why mass-produced products work and look as they do, and how design has improved the quality of our lives. Art museum exhibits, on the other hand, would most probably fill visitors with a feeling that there is something between their understanding.

In recent years, several new design museums have opened their door. Each of these museums has tried to satisfy the public’s growing interest in the field with new ideas. London's Design Museum, for example, shows a collection of mass-produced objects from Zippo lighters to electric typewriters to a group of Italian fish-tins. The choices open to design museums seem far less strict than those to art museums, and visitors may also sense the humorous part of our society while walking around such exhibits as interesting and unusually attractive toys collected in our everyday life.

小题1:Showcases in design museums are different from store windows because they_.

A.show more technologically advanced products

B.help increase the sales of products

C.show why the products have sold well

D.attract more people than store windows do小题2:The author believes that most design museum visitors_.

A.do not admire mass-produced products

B.are puzzled with technological exhibits

C.dislike exhibits in art museums

D.know the exhibits very well小题3:The choices open to design museums_

A. are not as strict as those to art museums

B, are not aimed to interest the public

C. may fail to bring some pleasure to visitors

D. often contain precious exhibits

小题4:The best title for this passage is“_”

A.The Forms of Design Museums

B.The Exhibits of Design Museums

C.The Nature of Design Museums

D.The Choices Open to Design Museums

多项选择题