AutoCAD is one of popular draw software in the world.In the course of using it,most of users hope to manage design knowledge effectively,not only query kinds of knowledge quickly,but also save some design experience and case timely.So this article uses VBA and database to brings forward a method to manage design knowledge.