基于Access数据库的进口煤炭质量信息系统开发与应用

Development and application of imported coal quality information system based on Access database

根据我国进口煤炭检验监管的需求,结合进口煤炭检验检疫监管工作的实际情况,利用Access数据库设计开发了进口煤炭质量信息系统。结合Access数据库的简介及数据库开发内容,简要介绍了进口煤炭质量信息系统的开发框架,并从系统界面、数据维护模块、风险预警模块、综合查询模块、质量分析模块、系统管理模块等方面详述了进口煤炭质量信息系统设计。该信息系统具有检验检疫监管信息录入、模板导入、查询、统计和预警功能,有利于提高进口煤炭数据管理效率,可为检验检疫部门严格落实进口煤炭法定检验检疫监管工作职责、实时掌控各口岸进口煤炭质量状况、开展质量分析和预警提供便捷全面的数据支撑,进而为实施进口煤炭质量管理及调整煤炭进口政策提供支持。

According to the demand of imported coal inspection and supervision and combined with the actual situation of coal import inspection and quarantine supervision,the imported coal quality safety and environmental protection information system based on Access database was designed and developed.Combining with the introduction of Access data base and development content of data base,the development frame of imported coal information system was introduced,and from aspects such as system interface,data maintenance module,risk warning module,integrated query module,quality analysis module,system management module and so on,the imported coal quality information system design was demonstrated.This system has the functions like inspection and quarantine supervision information input,template import,data inquiry and risk pre-warning.The system can greatly improve the efficiency of data management of imported coal.It also can provide data support for strictly implement of responsibility for statutory inspection and quarantine supervision of imported coal,the real time control of quality of imported coal at various ports,and the quality analysis and early warning,therefore,it can supply decision support for imported coal quality management and policy adjustment of imported coal.