| This thesis design a management system of alumni information. The background database software of the management information system uses MicroSoft Office Access2013. The foreground development tool deploys MicroSoft Visual Basic6.0.The thesis analyses the information of alumni. It designs six tables in the database, which are fundamental information table, information table of studying in school, information of working in school, information of working in unit, users table and alumni exchange table. Every table is set up its Primary key. The system creates Foreign References Relation between previous four tables, in which can reduce redundancy of data and easy to maintain the database. Users table is used to control the authority of different users. Alumni exchange table is used to save the message of alumni.The system adds some kinds of References and ActiveX in VB at the beginning of the system development. They can realize some new functions. The system programs general module code, which can achieve the manipulation of the database, such as join, query and update. Meanwhile, it can reduce the redundancy of such code.The foreground of the system provides different authorities for different user. Take the super user as an example, he has the whole authority of the system. He can enter the information of alumni, query it, update it, or delete it. When he has entered the information, the system carries out two checks, one is to check whether the entering information is null, the other is to check whether the information has existed in database through comparing the entering information with the information of database, so as to guarantee the accuracy of the entering data. At the same time, the system realizes the function of adding photos. When he queries information, the system indexes the alumni’s numbers in database, and judges whether the alumni exists or not through the results of index, then determine whether to displays it or to warn user reenter. The manipulation of updating and deleting is arranged on the same form with querying. After he queries an existing alumnus, he can continue to alter or to delete the alumni’s information. Once user alters the current information, the system judges this operation to determine whether the information is altered. If the user doesn’t alter the information, then give some tips to user. If he does, then update database. The system can also alter photos. The manipulation of deleting can warn user whether guarantee to delete or not, avoiding wrong deleting.Besides these fundamental manipulation, foreground provides users more functions. Such as querying all information of alumni, printing the dada report, backup of database, recovery of database, leaving messages, counting data. Meanwhile, user can conveniently login Fetion of Mobile, QQ of Tecent, Internet explorer through shortcut images. |
