问题 问答题

在考生文件夹下有一个Excel文件“Test.xlsx”和一个数据库文件“samp1.accdb”。在“samp1.accdb”数据库文件中已建立3个表对象(名为“线路”、“游客”和“团体”)和一个窗体对象(名为“brow”)。请按以下要求,完成表和窗体的各种操作。

将“游客”表中的“年龄”字段删除;添加两个字段,字段名分别为“证件编号”和“证件类别”;“证件编号”的数据类型为“文本”,字段大小为20;使用查阅向导建立“证件类别”字段的数据类型,向该字段键入的值为“身份证”、“军官证”或“护照”等固定常数。

答案

参考答案:

[操作步骤]

步骤1:右键单击“游客”表,从弹出的快捷菜单中选择“设计视图”命令。

步骤2:选中“年龄”字段行,右键单击“年龄”行,从弹出的快捷菜单中选择“删除行”,如图所示。

步骤3:在“团队ID”字段行的下一行“字段名称”列输入“证件编号”,单击“数据类型”列,在“字段大小”行输入“20”。

步骤4:在“证件编号”字段行的下一行“字段名称”列输入“证件类型”,单击“数据类型”列,在下拉列表中选择“查阅向导”,然后在弹出的对话框中选择“自行键入所需的值”单选框,单击“下一步”按钮。在弹出的对话框中依次输入“身份证”、“军官证”和“护照”,单击“下一步”按钮,再单击“完成”按钮,如图所示。

步骤5:按Ctrl+S保存修改,关闭设计视图。

填空题
阅读理解

阅读理解。

     Afghan, NATO forces capture several insurgents

     2011-11-18 07:10:34

     Afghan and the NATO-led International Security Assistance Force (ISAF) captured several anti-government militants in Helmand province 555 km south of Afghan capital Kabul on Thursday.

     Wen in Bali for East Asian leaders' meetings

     2011-11-17 19:39:07

     Chinese Premier Wen Jiabao arrived in Bali on Thursday to attend a series of meetings for East Asian leaders scheduled from Nov 17 to 21.

     Bali to hold ASEAN Plus Three, AEAN Plus One Summits

     2011-11-17 16:19:59

     The 14th ASEAN Plus Three Summit and a series of ASEAN Plus One Summits will be convened here on

Friday, according to a statement issued by the Indonesian Ministry of Foreign Affairs Thursday.

     Death toll in floods in Thailand reaches

     567 2011-11-17 15:43:01

     A total of 567 people were confirmed dead and two others were missing in the floods that have inundated

the upper part of the country for about four months. Previous Page 1 2 3 4 5 6 7 8 9 10 Next Page >>|

1. Which of the following statements is TRUE according to the passage?

A. Afghan alone captured several anti-government militants in Helmand province.

B. The total number of victims in floods in Thailand reached 567.

C. Wen Jiabao arrived in Bali to attend a series of meetings for Asian leaders.

D. A series of meetings will be held in Bali lasting 5 days.

2. The four pieces of news are issued _______.

A. in the order of time

B. in the order of place

C. in the order of logic

D. in the order of significance

3. What does the underlined word "convened" mean in the third piece of news?

A. held

B. continued

C. celebrated

D. attended

4. This passage is most probably from _______.

A. a newspaper

B. a website

C. a research paper

D. a novel