access重点总结（Access key summary）.docVIP

access重点总结（Access key summary） Access important knowledge point arrangement Chapter 1. Basic knowledge of Access database (4%-10%) I. Basic knowledge of database Test site 1: development of database management techniques 1., the development of database technology has gone through several stages: manual management phase, file system phase, database system phase, distributed database system and object-oriented database system. Classic examination questions: 1., the database technology development process has gone through three stages of manual management, file system and database system, in which the highest stage of data independence is the database system phase. (05/9) Test site two: basic concepts of the database 1. data: a symbolic record of things in the real world, an information that can be recorded in physical notation. 2. data processing: the process of converting data into information. 3. database (DB): refers to the long-term storage in the computer, organized, shareable data set. 4. database management system (DBMS): software configured for the establishment, use and maintenance of a database. Functions: data definition (data definition language DDL), data manipulation (data manipulation language DML), database operation control, database establishment and maintenance. 5. database systems (DBS): hardware systems, databases (DB), database management systems (DBMS), database administrators (DBA), users. 6. database system core: database management system. Classic examination questions: The relationship between the 1. database (DB), the database system (DBS), and the database management system DBMS is () (06/4) A. DB contains both DBS and DBMS B. DBMS contains both DB and DBS C. DBS contains both DB and DBMS D. has nothing to do with it Answer: C The core of the 2. database system is () (05/9) A. data model B. database management system C. database D. Database Administrator Answer: B Test site three: the composition of the database system 1. database system c