Research on Library Management System Based on VBA

For the provincial and universities' libraries, the management of books and materials are generally based on complex and huge database, such as: SQL Server, Access, and Oracle. The cost of maintenance and management is very high, even though its safety and reliability can be effectively protected. Meanwhile, it's not convenient for manual input. As for smaller enterprises, they have a tiny sample size of books and staffs, according to this situation, we designed a library management system with VBA and a barcode scanner (CCD). The results show that it has obviously decreased the chattiness of the whole process which includes borrowing and returning books, make sure the management of library materials is unified and effective.