问题 单项选择题

查询设计器中包括的选项卡有______。

A.字段、筛选、排序依据

B.字段、条件、分组依据

C.条件、排序依据、分组依据

D.条件、筛选、杂项

答案

参考答案:A

解析:[知识点] 设计器的使用 [评析] 选项卡选项 字段:指定字段,SUM或COUNT之类的合计函数或其他表达式。 连接:指定连接表达式,用它来匹配多个表或视图中的记录。 筛选:指定选择记录的条件,比如在字段内指定值或在表之间定义临时关系的连接条件。 排序依据:指定字段或SUM、COUNT之类的合计函数,对表中的记录进行升序或降序排列。 分组依据:指定字段或SUM、COUNT之类的合计函数,或用于把有相同字段值的记录合并为一组的其他表达式。 更新条件:指定更新视图的条件(仅适用于“视图设计器”)。 杂项:指定是否要对重复记录进行检索,同时是否对记录(返回记录的量大数目或量大百分比)做限制。

阅读理解

Cities alarmed by deaths and injuries of pedestrians are taking efforts to make crosswalks safer for people on foot, especially seniors and children who need more time to cross streets.

A pedestrian is killed in a traffic accident in the USA every 110 minutes;one is injured every nine minutes, according to official date. Crosswalk can be especially dangerous for the elderly. Among people 70 and older, 36% of pedestrian deaths in 2006 occurred in crosswalks, compared with 21% of those younger than 70, according to the Insurance Institute for Highway Safety.

The Federal Highway Administration(FHWA)advises that next year states increase by nearly 15% the amount of time traffic lights provide for pedestrians to cross the street after the flashing orange hand appears .

FHWA spokesman Doug Hecox says reasons for the change include an aging population that needs more time to cross, health-conscious Americans walking more, children encouraged to walk to prevent getting overweight and high gas prices pushing people to walk instead of drive.

Pedestrian deaths went down by 12% from 5,449 in 1996 to 4,784 in 2006. But among those in 2006, 471 were killed in crosswalks, down slightly from 488 ten years earlier, the National Highway Traffic Safety Administration (NHTSA) says.

小题1:Which of the following is true according to the text?

A.Among 100 pedestrian deaths there were 21 people younger than 70.

B.Old people are more likely to meet with accidents in crosswalks.

C.Traffic accidents killed more old people than young people.

D.About seven traffic accidents happened per hour.小题2:What is FHWA’s suggestion to states?

A.Fixing more traffic lights.

B.Providing more crosswalks.

C.Giving pedestrians more time to cross streets.

D.Increasing the time before the orange lights appear.小题3:What’s the cause of the crosswalk safety problem according to the test?

A.There’re many cars and buses on the road.

B.Pedestrians are careless.

C.Crosswalks are crowded.

D.Drivers don’t give way.小题4:The report from NHTSA suggests that             

A.fewer people were injured in crosswalks

B.crosswalk safety has been greatly improved

C.much has been done to reduce traffic accidents

D.pedestrian deaths in crosswalk remain a serious problem

单项选择题