The Optimization Scheme of data Query Based on VBA

Due to the need of academic affairs management in the Educational administration system,the form of data should be various.This requires the original data to better treatment.This paper mainly discusses in Excel environment using VBA macro function data record inquires the timetable,and optimizes the design in object-oriented aspects,make it more humane.