基于VB+ACCESS的学生学籍管理系统的设计与实现

The Design and Implementation of the Student Status Management System Based on VB+ACCESS

本文以学生学籍管理系统为研究对象,提出了一种基于VB+ACCESS模式的学生学籍管理系统。该系统解决了传统手工管理学生档案效率低、保密性差、数据冗余等问题。系统逻辑结构由前台应用程序开发和后台共享数据库设计两部分组成。应用程序开发的窗体模块和标准模块通过ADODB组件和标准SQL语句来实现连接和访问数据库。系统的详细设计以逻辑结构为框架,阐述了学生学籍信息的添加、查询和删除等功能的算法和程序的设计过程。

Taking the student status management system as the study object,the paper proposes the system based on the VB＋ACCESS model.The system solves the problems of low efficiency, poor security, and data redundancy.The logic structure of the system is composed of both the foreground application development and the background shared database design.The form module and the standard module of application development connect and access to the database through the ADODB components and standard SQL statements.Based on the logical structure,the system detailed design expounds the system design process and the algorithms of student status information adding,searching and deleting.