问题 问答题

在考生文件夹下完成如下简单应用:
利用查询设计器创建一个名为query1.qpr的查询文件,查询考生文件央下的xusheng表和chengji表中数学、英语和信息技术3门课中至少有一门课在90分以上(含)的学生记录。查询结果包含学号、姓名、数学、英语和信息技术5个字段,各记录按学号降序排列,查询去向为表table1,并运行该查询。

答案

参考答案:①选择[文件]→[新建]命令,选择“查询”,单击“新建文件”按钮打开查询设计器,弹出“添加表或视图”对话框,将表“claengji”、“xueslaeng”分别添加到查询设计器中,关闭“添加表或视图”对话框。
②在查询设计器的“字段”选项卡中,将“可用字段”列表框中的字段“xuesheng.学号”、“xuesheng.姓名”、“chengji.数学”、“chengji.英语”、“chengji_信息技术”添加到右边的“选定字段”列表框中。
③在“筛选”选项卡中,“字段名称”下拉列表框中分别选择“chengji.数学”、“chengji.英语”、“chengji.信息技术”,“条件”下拉列表框中都选择“>=”,实例中都填入90。
④在“排序依据”选项卡中将“选定字段”列表框的“xuesheng.学号”添加到右边的“排序条件”中,在“排序选项”中选择“降序”。
⑤选择[查询]→[查询去向]→[表]命令,表名填入“table1”,点击“保存”按钮,在弹出的“另存为”对话框中输入“query1”,关闭查询设计器。

解析:[考点指引] 本题考查按要求建立查询,新建数据库并按要求建立视图。

选择题
阅读理解

We can offer you a place at one of the best universities in Britain. We’ll provide you with a choice of 150 first class courses developed especially to enable you to study in your own time, backed by the Open University’s own special study method-OU supported open learning.

We’ll give you the support of a personal teacher, and the chance to meet your fellow students. You can take one-off courses, diplomas (毕业证), a degree or a postgraduate degree(文凭). Subjects available include: computing, business management, technology, modern languages, social sciences, English law, arts, science, mathematics, education and health﹠social welfare.

Did you know?

The OU is in the top 15% of all UK universities for teaching quality

25% of all British MBAs come from the OU

Over 30,000 employers have offered chances to their staff on OU courses

40,000 OU students are on line from home

There are 9 month courses and new diplomas as well as degrees

AMBA Accredited(合格的)

Whether you want to study to improve your jobs or for your own personal interest, there’s almost certainly a course for you. If you haven’t studied for a while, we’ll help you get started. No previous training or degrees are required, you just need a lively power of learning and a willingness to learn. It’s real value for money and you can pay by monthly payments.

Open University course materials are of the highest quality and come in a variety of forms, including video and audio tapes as well as texts. The OU leads the world in its use of new technology for learning. A number of courses provide source material on CD Rom. What else can the Open University offer you? The best way to find out is to use the coupon(折价券) below or phone us today.

57. This is an advertisement of _________.

A. inquiring (调查) English learning          B. setting Open University

C. selling books                D. attracting students

58. As a student of the Open University, you don’t need to ________.

A. buy any course materials   B. have lessons all the time at the university

C. choose which course to learn      D. pay any money for your study

59. The Open University can supply you with _________.

A. a course for training you English          B. a classroom and a library for study

C. different kinds of free instructions      D. different jobs to choose from

60. We can learn from the text that ________.

A. OU courses are popular in Britain

B. money for learning must be paid off at one time

C. we can’t telephone the university during the night

D. people can’t be employed without finishing OU courses