问题 问答题

将已有的“水费.xlsx”文件导入samp1.accdb数据库中,将导入的表命名为“水费记录”。“水费记录”表结构如表所示。

字段
名称
数据
类型
字段属性
常规
字段大小 索引
职工号 文本 5 有(有重复)
上月水 数字 整型
本月水 数字 整型
水费 货币

答案

参考答案:

[操作步骤]

步骤1:单击“外部数据”选项卡下“导入并链接”组中的“Excel”按钮,弹出“获取外部数据-Excel电子表格”对话框。单击对话框中的“浏览”按钮,在考生文件夹中选择“水费.xlsx”文件,选择“将源数据导入当前数据库的新表中”单选框,单击“确定”按钮,如图所示。

步骤2:在“导入数据表向导”对话框中连续单击4次“下一步”按钮,在“导入到表”中输入“水费记录”,单击“完成”按钮,在“保存导入步骤”中单击“关闭”按钮,如图所示。

解析:

[考点] 本题考点:添加字段;添加记录;字段属性中主键、默认值、有效性规则设置和导入表等。

第1、2、3、4、5在设计视图中添加字段和设置字段属性;第6小题选择“外部数据”选项卡下“导入并链接”组中的相关选项。

导入表时要选择正确的文件类型。

单项选择题
单项选择题

As a solo artist, Brightman has sold 26 million albums and two million DVDs in 34 countries. Her musical styles put opera, pop and jazz together. She is popular in the States but not here(Britain) - the image of her and her second husband, Andrew Lloyd Webber (he is much older, she is his muse) seems for ever frozen.

The 47-year-old singer talks about the new album Symphony that came out of a "very dark time", including her decision to give up trying to have children. "People have suggested I could adopt," Brightman says. "But work is central to my life now. And so I am going to put it to one side. After a while not having children becomes the norm and perhaps that might sound alarming, to parents especially, but I have never known anything different. I’m not hurt by not having children. My life and career are incredibly rich. "

Talking about growing up in a large family in Berkhamsted—her father is a property developer who later committed suicide, she says: "I was gifted as a child, and very musical. I seemed to be good at anything to do with the arts. At 5 I understood the music I was dancing to and had an eye for costume. " She first appeared in a West End musical at 11 and hated boarding school.

Brightman led the saucy dance troupe(辣妹三人舞) Hot Gossip and had her first hit with I Lost My Heart to a Starship Trooper in 1978. At 18 she married a music manager called Andrew Graham Stewart. "I was probably in love but I can’t remember. Girls change such a lot between 18 and 22. It didn’t really work out. " In 1981 she was spotted by Lloyd Webber. She became his leading lady in Song and Dance, Requiem and Phantom of the Opera. They married in 1984.

Brightman says she felt hostility "from the beginning. I haven’t tried to understand it. I’ve done very well everywhere else, especially the US, where I now live, I just accept it for what it is. The more you are away from Britain, the more you appreciate it. But I don’t miss it, although I miss my family. Our profession can be uncomfortable but I enjoy what I do. I get on with it. \

Brightman decided to give up having children because ().

A.she could adopt one

B.her life and career were unbelievably rich without children

C.she felt it normal not to have children

D.she was too busy