问题 问答题

考生文件夹下存在一个数据库文件“samp2.mdb”,里面已经设计好三个关联表对象“tStud”、“tCourse”、“tScore”和一个临时表对象“tTemp”。   试按以下要求完成设计:

(2)创建一个查询,查找选课学生的‘‘姓名’’和‘‘课程名,,两个字段内容,所建查询命名为“qT2”。

答案

参考答案:步骤1:双击“在设计视图中创建查询”。添加“tStud”、“tCourse”、“tScorc”表,关闭“显示表”对话框,需要注意的是,虽然要查询的字段只在“tStud”、“tCourse”表中,但是必须把tScore加入才能建立联系,才能实现多表查询。   步骤2:分别在“tStud”表中双击“姓名”字段,在tCourse表中双击“课程名称”字段。   步骤3:单击“运行”按钮。单击“保存”按钮,保存输入文件名“qT2”。单击“确定”按钮,关闭“qT2”查询窗口。

解析:【审题分析】本题考查多表查询,考生必须要对多表查询的务件了解,从而才能实现在多个表中实现数据的获取.

单项选择题
阅读理解

阅读理解。

     Residents of Golestan Province in northern Iran have one of the highest rates of esophageal cancer (食道

癌) in the world. They don't drink alcohol or smoke-the two primary risk factors for the disease in the west-

but they do consume tea, nearly 1.2 liters per day, on average. So local researchers set out looking for a

connection.

     They employed 300 esophageal cancer patients who were diagnosed in the eastern part of Golestan and

matched them up with 571 healthy controls who shared their age, gender and place of residence. All but one

of them drank tea, and they gave interviewers information about their tea consumption and brewing habits.

     Teaming up with investigators from the U.S., England, France and Sweden, the researchers calculated

that people who said they drank "hot" tea (149 to 156 degrees Fahrenheit) were more than twice as likely to

develop esophageal cancer as people who said they drank the beverage "warm" or "lukewarm" (less than 140

degrees). Those who said they took their tea"very hot" (at least 158 degrees) were more than eight times as

likely to get esophageal cancer, according to the study, published online Thursday in the British Medical

Journal.

     The scientists have now connected it with esophageal cancer. The problem doesn't appear to be the tea

itself, but the temperature at which it is consumed, their study found.

     The researchers also asked people how long they waited to drink their tea after pouring it. Those who

said they waited two to three minutes were nearly 2.5 times more likely to develop the cancer compared

with people who said they waited at least four minutes. Impatient tea drinkers who waited less than two

minutes were 5.4 times as likely to be diagnosed with esophageal cancer, the study found.

     The study didn't assess the mechanism linking hot tea to esophageal cancer, but the researchers said

the temperature of the liquid was almost certainly to blame rather than the compounds in the tea itself.

1. According to the passage, _____ were thought to be two main causes of esophageal cancer.

A. drinking hot tea and smoking

B. drinking alcohol and smoking

C. working in the kitchen and smoking

D. taking sunbaths and drinking alcohol

2. The underlined word "it" in Paragraph 4 probably refers to _____.

A. the tea they drink

B. the way people drink tea

C. the temperature of the tea

D. the properties of the tea

3. We can infer from the second paragraph that _____.

A. drinking tea causes the cancer

B. few people drink tea in that area

C. 300 out of 571 people got the cancer

D. tea has no direct connection with the cancer

4. Which would be the best title for this passage?

A. Drinking Tea with Patience

B. An Esophageal Cancer Stricken Area

C. Temperature and Esophageal Cancer

D. Various Causes of Cancer