北京化工大学北方学院期末模拟ACCESS

北京化工大学北方学院2009——2010学年第一学期《数据库原理及应用》期末模拟考试试卷2
1．新建“教师授课.mdb”数据库。

（3分）
2．按要求创建“教师表”，并输入如下记录(也可通过导入EXCEL表中的数据的方式得到
数据纪录,然后修改表结构)。

（8分）
4．创建“课程表”与“授课表”之间的一对多关系，并实施参照完整性。

（3分）
5．设置授课表的字体为宋体、粗体，表格样式设置单元格效果为“凸起”；设置“教师表”的“性别”字段的有效性规则：”男”or”女”,输入的有效性规则不允许时，提示信息为“请输入性别“。

（8分）
6．创建“数学课信息查询”查询，显示教授数学课的教师编号、教师姓名、课程名称、课程学分。

（6分）
7．创建名为“没有授课”的查询，找出没有授课的教师编号、教师姓名和部门。

（8分）When you are old and grey and full of sleep,
And nodding by the fire, take down this book,
And slowly read, and dream of the soft look
Your eyes had once, and of their shadows deep;
How many loved your moments of glad grace,
And loved your beauty with love false or true,
But one man loved the pilgrim soul in you,
And loved the sorrows of your changing face;
And bending down beside the glowing bars,
Murmur, a little sadly, how love fled
And paced upon the mountains overhead
And hid his face amid a crowd of stars.
The furthest distance in the world
Is not between life and death
But when I stand in front of you
Yet you don't know that
I love you.
The furthest distance in the world
Is not when I stand in front of you
Yet you can't see my love
But when undoubtedly knowing the love from both Yet cannot be together.
The furthest distance in the world
Is not being apart while being in love
But when I plainly cannot resist the yearning
Yet pretending you have never been in my heart. The furthest distance in the world
Is not struggling against the tides
But using one's indifferent heart
To dig an uncrossable river
For the one who loves you.。