access复习题（access复习题）.doc

access复习题（access复习题） 1) the.Access database belongs to the (C) database. A) hierarchical model B) mesh model C) relational model D) object oriented model 2) when you open the Access database, open the file named B. A), MDA B), MDB C), mde D), DBF 3). There are two tables of data of a known database, between the primary key and the primary key of them is a relationship between a plurality of the two tables to establish the association, permanent link should be established is (B). A) one to one B) one to many C) many to many D) one to many 4) the following (B) is not the object type of the Access database A) tables B), the wizard C) forms D) statements 5) the table in a relational database does not have to have the nature of (D). A) data items are not allowed to be subdivided B) the same column of data items must have the same data type C) the order of records can be arranged arbitrarily D) the order of fields cannot be arbitrarily arranged 6) the following is not true of the Access2000 (high version) and Access97 (lower version) statement (C). A) by means of data conversion technology, high and low version sharing can be achieved B) a high version file can be opened in a low version database, but some functions are not working properly C) a low version database file cannot run in a higher version database D) a high version file that can be used in a lower version database and needs to be converted to a lower version 7) the method that cannot exit Access 2000 is (C). A), click the file menu / exit B) click the close button in the upper right corner of the window C), ESC D), ALT+F4 8).Access can open (A) a database at the same time. A) 1 B) 2 C) 3 D) 4 9) when indexing a field in a table, if its value is repeated, select the (D) index. (A), Lord (B), yes (without repetition) C) none (D), yes (repeated) 10) when you create a table, you can do it in (C). A) report designer B) Table Browser C), table designer D) query designer 11) the type of field that cannot be indexed