vf真题6(国外英语资料).docVIP

vf真题6(国外英语资料) First, the basic operation items (4 items, first and 2 is 7, third and 4 is 8 points) In the examinee folder, complete the following operations: 1. open the examinee folder under the one form (as shown), add a statement in the open command button in the Click event, the results form, click the command button operation is to close button becomes available. 2. open the form two under the examinee folder (as shown in Figure 1), add a radio button in the options group (as shown in Figure 2). Note: the original name and attribute value cannot be changed. Figure 1 Figure 2 3. use the SQL statement to add a field teacher number (integer type) to the school table under the candidate folder, and set the validity rule for the field: the number of teachers is =0. Please store the SQL statement in the three.prg file, otherwise it will not be scored. 4. use the SQL statement to change the salary of the teacher named Jack in the free form teacher in the examinee folder to 8000 yuan. Please store the SQL statement in the four.prg file, otherwise it will not be scored. The main points of assessment: form operations and the use of SQL statements. Problem-solving thinking: 1, open form one and add the following statement in the Click event of the open command button: Tmand2.enabled=.T. 2, open form two, set the form and related control attributes, values are as follows: Object property attribute value Optiongroup1 ButtonCount 3 Option3 Caption programming 3, use the SQL statement for the college table to increase the field command as follows: ALTER TABLE college table ADD teacher number I CHECK teacher number =0 Store the SQL statement in the three.prg file. 4, use the SQL statement for the free table teacher to increase the field command as follows: UPDATE TEACHER.DBF SET salary =8000 WHERE name = Jack Store the SQL statement in the four.prg file. Two, a simple application (2 items, each of 20 points, 40 points) Complete the following simple application in the examine