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

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

關(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 應(yīng)用背景------------------------------------------------------------------------5
1.2 管理信息系統(tǒng)介紹------------------------------------------------------------5
1.3工資管理信息系統(tǒng)的最終目的----------------------------------------------5
1.4系統(tǒng)開發(fā)的基本觀點(diǎn)和基本概念-------------------------------------------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è)計(jì)-------------------------------------------15
    3.1 設(shè)計(jì)思想------------------------------------------------------------------------15
3.2 系統(tǒng)功能分析--------------------------------------------15
3.3 數(shù)據(jù)庫設(shè)計(jì)---------------------------------------------------------------------16
  3.3.1  數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計(jì)-----------------------------------------------------16
  3.3.2  數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計(jì)-----------------------------------------------------18
  3.3.3  數(shù)據(jù)庫連接實(shí)現(xiàn)----------------------------------------------------------20

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

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

致謝----------------------------------------------------------32
參考文獻(xiàn)-----------------------------------------------------33