Access期中综合练习题（国外英文资料）.doc

Access期中综合练习题（国外英文资料） Question 1 0 In the relation statement below, the error is _____. A: A relationship is A two-dimensional table b. A two-dimensional table must be A relationship C. some two-dimensional tables are not relational d. the same column only comes from the same domain Answer: B Second question 0 In the e-r diagram, the graph used to indicate the relation between entities is _____. A. oval b. rectangle c. triangular d. diamond Answer: D The third question 0 In the connection between the following entities, the relation of many to many is _____. A. the factory and the factory C. workshop and workshop director d. readers and library books Answer: D Number 4 0 Assume a relational schema: department (department, department name), the worker (employee number, name, gender, job title, department), wages (worker number, basic salary, bonus), level (title, corresponding administrative level), to find work in the finance the workers name and bonuses, will involve relationship is _____. Employee, salary b. employee, department C. Department, level, pay D., salary, department Answer: D 5 0 In the Access table, you can define three main keywords, which are _____. A. Single field, double field, and multiple fields B. single field, double field, and automatic number C. Single field, multifield, and automatic number D. double fields, multiple fields, and automatic Numbers Answer: C Number 6 0 After opening an Access 2003 database, you can open the table by double-clicking a table name in the table object. A. The relationship view b. query view c. design view d. data table view Answer: D Question 7 0 For the Access database, it is not possible to set field size properties in the following data types. A. the b. the c. the d. the d. the Answer: C 8 the topic 0 In table design view, if a table is to be in a number of fields define the primary key, need to hold the _____ key, click the required fields, then click on the primary key button. A: its a good idea Answer: B Que