10.使用一对多表单向导选择ksb表和kscjb表生成一个名为two的表单（10. using the one to many Form Wizard, select the KSB table and the kscjb table, and generate a form called two）.doc

10.使用一对多表单向导选择ksb表和kscjb表生成一个名为two的表单（10. using the one to many Form Wizard, select the KSB table and the kscjb table, and generate a form called two） Tenth sets I. Basic operation Under the examinee folder, open the enrollment database SDB, complete the following operations: 1. add a field called note in the KSB table, the field data type is character, and the width is 30; 2. in the examinee performance table KSCJB, set the validity rules and default values for the result field, =0 and, =150, and the default value is 0; 3. the number of candidates through the field to establish KSB table and the KSCJB table of the permanent contact, and the contact set referential integrity constraints: update rules for cascade ; delete rules for restriction ; insert a rule to ignore. 4. use the report wizard to create a simple report. All field selection candidates in table KSB; record grouping; report style casual; 1 rows, columns, field layout for the direction of vertical; candidates sorting field (ascending); report entitled test-takersperformance list; report file named ONE.FRX. Answer： First class 1., left click the file, left click, open, file type, left click the database, left click SDB, and left click ok. 2. in database designer -SDB, right-click on the KSB table, and click left to modify. 3. in Table Designer -ksb.dbf, enter the field name at the end of the structure, note width 30, left click OK, and left click yes. Second a. 1. in database designer -SDB, right-click on the kscjb table, and click left to modify. 2. in Table Designer -kscjb.dbf , click results field, in the field of validity of the rules at the =0 and =150 score input results default 0 left click OK input, click. Third a. 1., left click on the KSB table in the main index examinee number, and press and hold, and then move the mouse drag to the kscjb table of the general index examinee number, release the mouse can. 2. click database menu, click clean up database, click OK in the left click database menu,