The invention relates to the technical field of unit management
informatization, and particularly discloses a basic-level unit personnel and
transaction management system and method based on a VBA platform, and adopts a layered design of a data layer, a function layer and a display layer. The data layer constructs a'human-event-object 'associated data network by using relational databases such as Access and the like; the functional layer realizes
data acquisition, associated query,
information sharing,
statistical analysis and intelligent
processing through VBA; and the display layer is provided with a comprehensive information publicity interface and a panoramic view by taking Excel as a carrier. According to the invention, personnel management is taken as a core, static / dynamic / associated data are associated to describe personnel portraits, 'person-event-object 'information is fused, data islands are avoided, information can be automatically pushed, a statistical chart can be generated, and cross-
system sharing is supported. According to the method, multi-dimensional management of personnel is deepened, complicated
information processing is simplified, communication cost is reduced,
closed loop of work is assisted, management convenience, efficiency and
fineness of basic units are improved, and the method is suitable for efficient management of personnel and affairs of the basic units.