文档介绍:access复****题(access复****题)
First, fill in the blanks
1. (database) is in anized way the relevant data together stored in puter memory on the form, can be shared for multiple users at the same time, the collection and application of a group of related data independent of one another.
The 2. is the core database system (database management system).
3. in a Access database table, each row in the table is called a __ (record) _____, each column in the table is called a (field).
4. database management mon data model has hierarchical model, mesh model and (relational model) 3 kinds.
5. in the relational model, the data is regarded as a two-dimensional table, and each two-dimensional table is called a relation.
The extension of the database is (MDB).
7. the general steps of database design are divided into 4 stages: user requirements analysis, conceptual structure design, logical structure design and physical structure design.
Table 8. the design and maintenance of the structure, is in the table (in the design view).
9. in Access, data types include: automatic numbering, text, memo, number, date / time, (currency), yes / no, OLE object, hyperlink and Query Wizard, etc..
mand button in the 10. Database window has three as follows: open, design and (New).
11. referential integrity is a rule system, and Access uses this system to ensure the validity of records in relational tables, and does not delete or change related data by accident.
12. a table up to establish _ (a) a primary key (main index).
13. if the establishment of "basic wage" in the field to create a table in the data type should be ___ (currency) __.
14. is the primary key table (only) to identify each record field.
15. defines the field in the table __ (key) ____, its role is to ensure that every value in the field must be unique (. not repeated) for the index, and the field will be sorted according to the default.
16. in Access, the relations among tables are "one to one", "one to many" a