房屋建筑学作为建筑类专业的专业基础课，由于知识点繁多，考试的出卷、阅卷工作较为繁重，借助于OFFICE自动化技术VBA语言和ACCESS数据库，设计与实现了一套自动试卷生成软件，实现了试卷试题库的建立、添加、删除、编辑更新、按章节重点分布随机抽题、自动生成试卷和答案。

Building architectonics is a fundamental course of architecture major. Because of its various knowledge points, the writing and checking of test paper is very difficult. We designed a test paper automatic generating system software by using the office automatic technology, VBA program and ACCESS database. The software achieves the establishing, adding, deleting, and editing of test bank, choosing questions according to the chapter and emphases, and generating answers.