基于excel的固定资产管理系统设计.doc

编 号： 审定成绩： 重庆邮电大学 毕业设计（论文） 设计（论文）题目： 学院： 学 生 姓 名 ： 专 业 ： 班 级 ： 学 号 ： 指 导 教 师 ： 答辩组 负责人 ： 填表时间：年月 重庆邮电大学教务处制摘 要 ABSTRACT Fixed assets management system based on Excel design, is the use or Excel software data entry functions plus formula of simple and quick data depreciation management and the design of a practical management system. System is the biggest characteristic is general and simple operation, suitable for Industry and some types of logistics management. This system mainly includes warehouse management, category management, user management, authority management and the various assets, warehouse and asset types increase, delete, change, search and other functions. With the increase of company assets, fixed assets management system based on Excel advantage is more and more obvious, simultaneously also is one kind of make the management work more organized, more convenient, more efficient management system software. This system in many fixed assets management system before, on the basis of macro added, making operation more concise, data entry work more convenient, only need a button, data and can realize accurate automatic generation, the great limit shorten the time of office; The system also humanized added that a watch, and the advantages and disadvantages of the show that the system is wide and, simply, clearly; The design of the cover with for the be clear at a glance the specific depreciation that data, in actual company in statistics, can be directly to print out the cover, earnest effort did save time, simple, convenient and precise. [ Key words ] Excel Fixed assets Management system 目 录 ………………………………………………………………………………1 第一章 …………………………………..……………2 第一节 ……………..………………………………….2 一 、 …………………………………………………………..….2 ……………… 二、 栏目之间关系的设计 ………………………………………….………..2 ……………… 第二节 明细表外观的设计……………………………………………………….3 一、数据录入区的设计………………………………………………………