The clinical laboratory is confronted with the complex drug resistance mechanism every day, and every bacterial drug sensitivity test report usually needs systematic audit, but the manual operation is very complicated and difficult. The standardized management of the drug sensitivity test was realized through the establishment of a set of standardized names of bacteria, drug sensitivity, and the interpretation of the special drug sensitivity database. On the basis of the existing microbial information system, Excel was used to make the database for audit and the working interface was developed. Through the microbial information system has been recorded in the data analysis. The VBA program and application programming interface (API) was used to analyze the bacterial drug sensitivity test. This can improve work efficiency, avoid the error, so as to ensure the accuracy and completeness of the test results.