摘要
随着互联网技术的发展以及“互联网+”概念的不断深入,会计行业电算化的不断推进,为了缓解行政机关对于适合该行政机关的专业的会计软件的需求,本文设计一种基于SQL SERVER数据库技术的行政会计系统.该行政会计系统设计时依据《会计电算化工作规范》、各省市的会计规范、IS09000系列相关规定、国家规定的软件工程的相关技术规范等进行设计,根据行政机关对于会计业务的需求将整个会计系统分为四大模块,分别为总账管理系统、固定资产管理系统、报表管理系统、数据分析系统.根据各个模块需要达到的功能,分别对总账管理系统、固定资产管理系统、报表管理系统、数据分析系统进行功能设计,并且进行数据库设计,得到以SQL SERVER数据库为基础的行政会计系统.通过运行行政会计系统,整个流程操作流畅,且可以正常输出相应的报表,证明该会计操作系统具有一定的可行性.
With the development of Internet technology and the continuous deepening of the"Internet+"concept,the computerization of the accounting industry.In order to alleviate the need for professional accounting software suitable for the administrative organ,this paper designs an administrative accounting system based on the SQL SERVER database technology.The design of the administrative accounting system is based on"Accounting Computerization Work Specifications",accounting standards of various provinces and municipalities,relevant ISO9000 series regulations,and relevant technical specifications of software engineering stipulated by the state.The accounting system is divided into four modules,namely general ledger management system,fixed asset management system,report management system,and data analysis system.According to the functions required by each module,the functional design of the general ledger managcmcnt syatcm,fixcd 033Ct managcmcnt ayatcm,report managcment ayatcm,and data analyais 3yatcm ig pcrformcd,and the database design is performed to obtain the administrative accounting system based on the SQL SERVER database.By running the administrative accounting system,the entire process operates smoothly and the corresponding reports can be output normally,proving that the accounting operating system has a certain feasibility.
作者
李兆坤
Li Zhaokun(Yunnan construction investment holding group co.,LTD.Kunming,yunnan 650501)
出处
《现代科学仪器》
2020年第2期37-42,共6页
Modern Scientific Instruments
关键词
数据库
行政机关
会计
database
administrative agency
accounting
