问题 问答题

(1)建立一个名为my的菜单,菜单中有两个菜单项“文件”和“返回”。“文件”菜单项下还有两个子菜单“打开”和“新建”。在“返回”菜单项下创建一个命令,负责返回系统菜单,其他菜单项不做要求。
(2)根据数据库stu中的表“宿舍情况”和“学生信息”建立一个查询,该查询包含学生信息表中的字段“学号”和“姓名”及宿舍情况表中的字段“宿舍”和“电话”。要求按“学号”升序排序,并将查询保存为myq。

答案

参考答案:(1)在命令窗口中输入命令:CREATE MENU my,系统弹出一个“新建”对话框,在对话框中单击“菜单”按钮,进入菜单设计器环境。根据题目要求,首先输入两个主菜单名称“文件”和“返回”。在“文件”的“结果”下拉框中选择“子菜单”,在“返回”的“结果”下拉框中选择“命令”。在“返回”菜单项的命令文本框中编写程序代码:SET SYSMENU TO DEFAULT。接着单击“文件”菜单项同一行中的“创建”按钮进入下级菜单的设计界面,此设计窗口与主窗口大致相同,然后编写每个子菜单项的名称“打开”和“新建”。
根据题意,系统不再要求设计下级菜单,因此在两个子菜单的“结果”下拉框中选择“过程”或“命令”。选择菜单命令“菜单”—“生成”,生成一个菜单文件my.mpr。
(2)可以直接在命令窗口输入:CREATE QUERY myq,打开查询设计器,新建一个查询。在查询设计器中,分别将“宿舍情况”和“学生信息”两个数据表文件添加到查询设计器中,系统自动查找两个数据表中匹配的字段进行内部联接,单击“确定”按钮,如图3-61所示。
[*]
在查询设计器中的“字段”选项卡中,将“可用字段”列表框中的“学生信息.学号”、“学生信息.姓名”和“宿舍情况.宿舍”和“宿舍情况.电话”四个字段添加到右边的“选定字段”列表框中,在“排序依据”选项卡中,选择“学生信息.学号”升序排序。执行菜单命令“查询”—“运行查询”,查看查询结果。

解析: 本大题1小题主要考查的是菜单设计器的“结果”下拉框中各项的使用功能,例如要建立下级菜单,在“结果”下拉框中就必须选择“子菜单”,而要执行某条菜单命令,就应该选择“命令”或“过程”。2小题考查了联接查询,设计过程中主要注意两个表之间进行关联的字段。

阅读理解

阅读理解。

      Listen carefully, working people, we would like to tell you something that could save your precious time

and money! Best of all, it is free!

      It's "no".

      What do you ask? We'll say it again:"No".

      Sweet and simple "no".

      Say "no" at your office and see how quickly that pile of work on your desk disappears.

      "Saying 'no' to others means you are saying 'yes' to yourself," said Leslie Charles, a professional speaker

from East Lansing, Michigan.

      "Time is precious. People are spending money buying time. And yet we are willing to give up our time

because we can't say 'no'."

      Susie Watson, a famous writer, said people who always say "yes" need to say "no" without guilt (内疚)

or fear of punishment. "I would rather have someone give me a loving 'no'than an obligated (强制的) 'yes',"

she said.

      Susie Watson says she feels "no" obligation to give an explanation when she says "no" either socially or

professionally. Does she feel guilty about it? "Not at all," said Watson, who is director of advertising and public

relations at Timex Corp in Middlebury, Connecticut. "Most people are afraid of saying 'no'… My advice is to

say 'yes' only if you don't mean 'no'."

      Watson said "no" is the most effective weapon against wasting time. "Every year there are more demands

on your time… Other people are happy to use up your time," Watson said. Time saving appears to be "no'"

greatest friend.

      "No" can be your new friend, a powerful tool to take back your life. "No" may even take you further in

the business world than"yes".

      "No" is power and strength. "No" now seems completely correct."Saying 'no' isn't easy. But finally it's

greatly liberating," Charles said. But, he added, a "no" project needs to be worked on every day because it is

hard to change long-term habit. 

      But, he also warns:"Don't go to extremes. Don't find yourself saying 'no'to everything. In return you

should learn to hear 'no'."

1. The sentence "you are saying 'yes' to yourself" means _____.

A. you can have more time to play with others

B. you needn't care about other's feeling if you are happy

C. you are selfish and treat others rudely

D. you can deal with your business as you have planned

2. When you say "no" to others, you should say it in a _____.

A. secret way   

B. polite way

C. proud way     

D. guilty way

3. In Watson's opinion, people can save much time on condition that _______.

A. they say "no" at a suitable time

B. they say "no" as much as possible

C. they are afraid of saying "no"

D. they make others angry at them

4. If a person says "no" to everything, the result he or she receives may be that he or she _____.

A. enjoys a wonderful life

B. makes a lot of money

C. faces difficulty in life  

D. forgets to say "yes" in the end

单项选择题