自考 管理系统中的计算机应用 实践(例题及答案)（The computer application in the management system of self (examples and answers)）.docVIP

自考 管理系统中的计算机应用 实践(例题及答案)（The computer application in the management system of self (examples and answers)） First, the basic operation items (4 items, first and 2 is 7, third and 4 is 8 points) The candidates pay attention to the following folder are C:\KSA database of STSK.dbc in the examinee folder, please complete the following: 1. add to the database table STUD1, table structure as follows: Student ID (C, 5), name (C, 8), age (N, 2,0), gender (C, 2), and (C, 2). Add a table STUD2, table structure as follows: Student ID (C, 5), subjects (C, 6), performance (N, 3). STUD1 table of contents are as follows: ID name age gender Department No. 10100 Li Luo 20 male 1 10104 red 21 female 1 week 20100 Li Zhen 20 male 2 10109 20 men and 1 red Liu 20109 21 men and 2 alcohol 10110 Lang spring 19 men 1 STUD2 table of contents are as follows: Number of subjects 10100 math 88 10100 Chinese 90 10104 political 95 20100 English 85 10109 math 87 10109 language 87 20109 math 85 10110 math 85 2. as the table STUD1 to establish the main index index name, student number, student number index. Table STUD2 3. for the establishment of general index index name, student number, student number index expression. 4. for the STUD1 and STUD2 tables to establish a permanent connection. ..................................................... Answer: The basic operation of answers: 1, double click the STSK.dbc database to open it. In 2, in the database designer right-click pop-up shortcut menu, click the new form menu, and then click new table command button, pop-up create a dialog box in the input table name after the text box, enter STUD1 as the name of the table, click the Save button pop-up table the designer dialog box, type the table structure according to the topic request within, and finally click OK button to eject the input data records now? Dialog box, select yes command button, according to the topic request input table records. Table STUD2 can be established in the same way. In T