A: To consolidate basic database instructions.

B: Master the basic instructions of program design.

C: Master the debugging method of program design.

D: Be able to design general application maintenance using VISUAL FOXPRO.

Second, the course set the title:

Student Achievement Inquiry System

3 System Development Requirements:

a) design the program according to the functional requirements of the system, b) and run on the machine through the software, c) have a better interface and ease of use, d) accuracy, e) confidentiality, f) security. The designed code should be more optimized.

g) Write a course practicum report of 2500 - 3000. Mainly describe the design description of the system, h) Functional description and usage instructions.

4 System Functional Modules

1 Create:

1: Create free table 2: Input class grades

2 Modify:

1: Modify the table structure 2: Modify the records 3: Modify all the records.

3 Find:

1: Browse table records 2: Browse class grades 3: Find records

4 Data analysis:

1: Average score, 2: Count the number of people in each subject's score band 3 Grade percentage

5 Print report:

1: Print the class grade table 2: Print the individual grade table

6. Exit

System design description:

This system is composed of six modules, each of which has its own function. The first module, for example, is responsible for data entry, with submenus for the creation of free tables according to the user's needs, as well as the input of class grades. The second module is modification, which includes modification of the table structure, modification of a record and modification of all records. For example, if the user chooses to modify a record, he or she can add or delete data. The third module is to find, the user can choose to create their own table to browse the query, you can select the class to browse the results of the entire class, but also by entering a person's student number to find his results in various subjects. The fourth module statistical analysis. It includes the average score, statistics on the number of students in each section, and the percentage of grades. The user can click on the appropriate tab to realize the corresponding function. For example, click on Grade Percentage. You can count the number and percentage of students who scored excellent, good, fair, and pass in each grade band. The fifth module is the print report, you can print the entire report card, you can also select the student's number to print a person's report card. The sixth module is to exit the system.