Book management system is a typical information management system. It mainly includes the establishment, maintenance and programming of front-end applications. The former requires data consistency, integrity and security. For the latter, the application program is required to be fully functional and easy to use. So I took my book from the library, MS SQL database management system, Server2000 SQL language principle, Visual Basic 6.0 language, Access database technology and other aspects of in-depth study and application, and analyzed the main requirements of the library management system, divided the functional modules, and analyzed the database model, so as to design the database structure and application. The running results of the system show that the designed book management system can meet the needs of borrowers and librarians.

In the design, the powerful Access database technology of VB6.0 is fully utilized to improve the reliability and efficiency of programming.

Keywords: database, SQL, Access, book management, form VB6.0 usage.

or

Library management system is a typical information management system. It mainly includes the creation and maintenance of database and the development of front-end application programs. The former requires strong data consistency, good data integrity and good security. For the latter, R application is powerful and easy to use. Therefore, combined with the materials I went to the library to read, I studied and applied the MS SQL Server2000 database management system, SQL language theory, Visual Basic 6.0 language and Access database technology in depth, mainly completed the demand analysis, functional module division and database modeling of the library management system, and designed the database structure and application program. The running results show that the book management system designed in this paper can meet the needs of borrowers and librarians.