基于sharepoint软件的电站管理数据库建立
关键字：VBA，sharepoint2013，数据库管理，模板生成
The oftware management database on the SharePoint
Abstract: With rising electricity consumption need, substation needs to be increased accordingly. However, because of Shanghai's urban construction has been relatively mature, it is difficult to the new substation. Only on the basis of the existing substation reconstruction. This project design is proposed by using SharePoint technology will be information organization together, form a preliminary risk management system, the reconstruction and expansion of existing management approach extends to reconstruction project management, implementation to apply for the automatic generation of risk disclosure and stop service. At the same time, the enterprise internal document flow for the next step, approval, etc to establish a good foundation. This will have on the transformer substation construction project risk management to establish a series of management. Need to study in this program features: prepare excel template; By the template automatically.
KeyWords:VBA、sharepoint 2013、the database management，generated template
1.绪论 3
1.1 项目背景 3
1.2 项目建设目标 4
1.3 研究目的 4
1.4 研究意义 4
1.5 国内外研究水平综述 5
1.6 项目目的分析 5
1.7 项目技术优势 5
1.8 项目应用前景 5
2 风险管理的现状分析 6
2.1 风险交底 6
2.2 停役申请 6
3 基于SharePoint的改扩建风险管理系统的方法与实现。 7
3.1 改扩建风险管理系统的方法的基础 7
3.2 需要解决的问题 7
3.3 改扩建风险管理系统的解决方案 8
3.4 SharePoint服务器 8
4 模板文件介绍及网站介绍 9
4.1 模板文件共有三个： 9
4.1.1 交底模板 9
4.1.2 停役申请模板 9
4.2 安全规范，工程文件，案例及分析 10
4.3服务器端相关问题和具体使用方法 10
4.4 模板功能实现的工具：VBA 10
4.4.1 VBA的介绍 10
4.4.3 VBA的强大功能 11
5 模板的建立和功能的实现 12
5.1 确定模板的内容 12
5.1.1 《改扩建风险管理系统》 12
5.1.2 《危险源及交底数据库》 14
5.1.3 《施工计划》 15
5.2 功能点的结构 15
5.3 功能的实现及操作流程 16
5.3.1 《改扩建风险管理系统.xlsm》 16
5.3.2《施工计划》 21
5.3.3 工程的危险源 22
6 网站的介绍 29