第3套数据库（Third sets of databases）.doc

第3套数据库（Third sets of databases） I. judgment questions Keep correct judgment papers 1, in Access, a report can edit and modify data in a data source. Error reference answer: wrong 2, creating complex queries in Access cannot use the query wizard. Error reference answer: wrong 3, SQL query mainly includes joint query, delivery query, data definition query and sub query 4 kinds. Error reference answer: Yes 4, in the Access data table structure, the data types include: automatic number, text, notes, figures, date / time, currency, yes / no, OLE objects, hyperlinks and Query Wizard, etc.. Error reference answer: Yes 5, in the Access table data structure, the value of required property is yes or no two. Error reference answer: Yes 6. In database systems, the physical structure of the data must be consistent with the logical structure. Error reference answer: wrong 7, in VBA, variables declared using the Private keyword belong to local variables. Error reference answer: wrong 8, in Access, the data access page is interactive, and the user can filter, sort, and view the data they need. Error reference answer: Yes 9, in Access, record source properties are common formatting attributes of forms. Error reference answer: wrong 10, in Access, all macro operations can be translated into the corresponding module code. Error reference answer: Yes Keep correct judgment papers Two, radio questions Saving radio examination papers 1, in the ACCESS query, suitable for failing students removed from students in the table is ______. Generating table queries Update query Delete query Additional query Error reference: C 2, in the ACCESS form, ______ control is used to display the expression result. Bound type Unbound type Calculation Container class Error reference: C 3, in VBA, can be object recognition action object ______. Method attribute Event process Error reference: C 4, in ACCESS, to establish the relationship between the tables, should be ______. Close all tables Open all tables Clo