第3套数据库（Suite 3 database）.doc

第3套数据库（Suite 3 database） 1. Save the judging questions 1. In Access, reports can edit and modify data in the data source. Wrong reference: wrong 2. In Access, creating a complex query cannot use the query wizard. Wrong reference: wrong 3. SQL queries mainly include joint query, pass query, data definition query, and subquery 4. Wrong answer: yes 4, in the Access data table structure, data types mainly include: automatic number, text, notes, number, date/time, money, yes/no, OLE objects, hyperlinks, and query wizard, etc. False reference: yes 5. In the structure of Access data table, the value of mandatory field attribute is yes or no. False reference: yes In the database system, the physical structure of the data must be consistent with the logical structure. Wrong reference: wrong 7. In VBA, variables declared with Private keywords are local variables. Wrong reference: wrong In Access, data Access pages are interactive, and users can filter, sort, and view the data they need. False reference: yes 9. In Access, the record source property is a common format attribute of the form. Wrong reference: wrong 10. In Access, all macro operations can be translated into module code. False reference: yes Save the judging problem 2. Single topic selection Save the list of selected questions 1. In the ACCESS query, the operation that is suitable for failing students from the student table is ______. Generate table query Update the query Delete query Additional query Wrong answer: C 2. In the ACCESS form, the ______ control is used to display the result of the expression. The binding type Not binding type To calculate Container classes Wrong answer: C 3. In VBA, it can be used by objects identified by objects. methods attribute The event process Wrong answer: C 4. In ACCESS, when establishing the relationship between tables, it is necessary to ______. Close all tables Open all tables Close the tables to build relationships Open a table of relationships Wrong answer: C 5. In ACCESS