工資管理信息系統(tǒng)

摘要
    工資核算的正確與否關(guān)系到每個勞動者的切身經(jīng)濟利益。對于企業(yè)來說：工資是成本的重要的組成部分，合理的組織工資核算。能有效控制產(chǎn)品成本中的工資費用，達到降低產(chǎn)品成本，提高經(jīng)濟效益的目的。傳統(tǒng)的工資計算，繁瑣而且效率不高，為了解決這一矛盾，利用計算機來進行工資的管理，是十分必要的。
論文主要介紹了傳統(tǒng)企業(yè)的工資管理方法以及傳統(tǒng)工資管理所存在的缺陷與弊端，進而得出使用基于計算機上的工資管理信息系統(tǒng)的必要性。目前國內(nèi)的大部分軟件公司都著力與財務軟件的開發(fā)，其中工資管理是會計電算化的重要組成部分，例如用友財務軟件、金碟財務軟件等。大部分的工資軟件基本上包括基礎(chǔ)數(shù)據(jù)的錄入、工資的計算與匯總統(tǒng)計表。所采用的編程語言主要是DHIPHI與VB，數(shù)據(jù)庫主要是SQL SERVER 與 ACCESS。通過對這些財務管理軟件的參考以及比較參考，我重點編寫了工資的匯總與分配。
論文重點論述了工資管理信息系統(tǒng)的組成與每個模塊的功能。設(shè)計工資管理信息系統(tǒng)主要從模塊組成、數(shù)據(jù)連接、功能實現(xiàn)、應用意義等方面著手。模塊組成主要包括該工資系統(tǒng)的主要組成模塊以及每個模塊所要達到的功能。工資管理的每個模塊基本上脫離不了數(shù)據(jù)，所以在數(shù)據(jù)庫設(shè)計的時候，要充分考慮數(shù)據(jù)的高效，減少數(shù)據(jù)冗余。保證系統(tǒng)的運行速度。數(shù)據(jù)庫我采用ACCESS，在于它與VB的兼容性不錯。
論文最后論述了用VB與ACCESS編寫工資管理信息系統(tǒng)的設(shè)計過程。設(shè)計過程主要以上面的分析的重點作為依據(jù)。首先進行基礎(chǔ)數(shù)據(jù)的采集，然后進行工資的核算等。
當然作為一個工資管理信息系統(tǒng)，其重要的一個方面是實現(xiàn)工資項目的自定義添加，該系統(tǒng)通過多個工資項目共存于一個數(shù)據(jù)表中來實現(xiàn)工資項目的自定義添加。在朝這個思想靠近的過程中，在許多小的細節(jié)上還存在著很多缺陷。
論文結(jié)尾預測了工資管理信息系統(tǒng)在企業(yè)中的應用前景與使用價值。

關(guān)鍵字：工資管理  信息系統(tǒng)  匯總分配

Abstract

Salary correct to concern each personal economic benefits of labourer or not. To enterprise: The salary is the important component of the cost, the rational organization salary is checked and calculated. Can control the salary expenses in the cost of goods effectively , reach and reduce the cost of goods, purpose to increase economic efficiency. The traditional salary is calculated, tedious and efficiency is not high, in order to solve this contradiction, it is very essential to make use of computer to carry on the management of the salary.
Thesis introduce traditional salary office procedure and traditional salary of enterprise manage the defect and drawback existed mainly, and then draw and use the necessity based on the management information system of salary on the computer. Development that domestic most software companies put forth effort with the financial software at present, among them it is the important component of the accounting by EDP that the salary is managed, such as UF financial software , gold financial software of disc ,etc.. Most salary software include the calculation of inputting , salary of the basic data and gather the statistical form basically. The programming language adopted is mainly DHIPHI and VB, the database is mainly SQL SERVER and ACCESS. Through the reference and relatively consulting to these financial  management software, I have written gathering and distribution of the salary especially.
Thesis describe salary composition and each function of module of the management information system especially. Design salary the management information system make up from module mainly , data connect , function realize , use respects , such as meaning ,etc. not to set about. The module makes up the main main composition module including this salary system and function reached of each module . Each module of management of the salary can not break away from the data basically, so when the database is designed, is it consider data high-efficient , reduce datum redundant fully to want. Speed of operation of the security system. I adopt ACCESS in database, lie in it and VB's compatibility is good.
Thesis is it write salary design process of the management information system with VB with ACCESS to expound the fact finally. Design process as basis with above focal point of analysis mainly. Carry on the collection of the basic data at first, then carry on the checking and calculating etc. of salary. Certainly as the management information system of a piece of salary, an important respect of it is to realize the adding self-definingly of project of the salary, system this realize salary project self-defining to add through coexisting in a data list in a lot of salary projects. While close towards this thought , still there are a lot of defects on a lot of little details.
Thesis ending predict salary the management information system application prospect and use value among enterprise.

Key word: The salary managing  Information system  Gather and assign

目錄
第一章  引言-----------------------------------------------5
1.1 應用背景------------------------------------------------------------------------5
1.2 管理信息系統(tǒng)介紹------------------------------------------------------------5
1.3工資管理信息系統(tǒng)的最終目的----------------------------------------------5
1.4系統(tǒng)開發(fā)的基本觀點和基本概念-------------------------------------------6
1.5 系統(tǒng)開發(fā)原則------------------------------------------------------------------6
1.6 系統(tǒng)開發(fā)方法------------------------------------------------------------------7
1.7 開發(fā)環(huán)境及工具介紹---------------------------------------------------------7
1.7.1  ACCESS2000數(shù)據(jù)庫介紹-------------------------------------------------7
1.7.2  VISUAL BASIC編程語言介紹--------------------------------------------8
第二章   系統(tǒng)分析-----------------------------------------9
2.1  需求與可行性分析----------------------------------------------------------9
2.2  數(shù)據(jù)流分析-------------------------------------------------------------------9
2.2.1 手工工資處理流程--------------------------------------------------------9
  2.2.2 電算化工資核算的內(nèi)容和數(shù)據(jù)流程--------------------------------------10
2.2.3 數(shù)據(jù)流程圖----------------------------------------------------------------11
2.2.4 數(shù)據(jù)字典-------------------------------------------------------------------12
第三章   系統(tǒng)設(shè)計-------------------------------------------15
    3.1 設(shè)計思想------------------------------------------------------------------------15
3.2 系統(tǒng)功能分析--------------------------------------------15
3.3 數(shù)據(jù)庫設(shè)計---------------------------------------------------------------------16
  3.3.1  數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計-----------------------------------------------------16
  3.3.2  數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計-----------------------------------------------------18
  3.3.3  數(shù)據(jù)庫連接實現(xiàn)----------------------------------------------------------20

第四章 系統(tǒng)實現(xiàn)---------------------------------------------21
4.1 系統(tǒng)界面介紹---------------------------------------------21

第五章  系統(tǒng)小結(jié)--------------------------------------------30
5.1  系統(tǒng)設(shè)計中的問題-----------------------------------------30
5.2  系統(tǒng)展望-------------------------------------------------30
5.3  系統(tǒng)應用效果---------------------------------------------30
5.4  開發(fā)體會-------------------------------------------------31

致謝----------------------------------------------------------32
參考文獻-----------------------------------------------------33