求助工资计算表

hncs456

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">各位兄弟姐妹</span><span lang="EN-US"><font face="Times New Roman">:</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 26.25pt; mso-char-indent-count: 2.5;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">我今年刚参加工作</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">主要负责公司工人工资的核算</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">由于每月的数据很大</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">很容易出错</span><span lang="EN-US"><font face="Times New Roman">.</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">公司又没有好的计算工资的软件系统</span><span lang="EN-US"><font face="Times New Roman">.</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">我很想建立一个</span><span lang="EN-US"><font face="Times New Roman">ACCESS</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">数据库</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">来规范好这部分的工资核算工作</span><span lang="EN-US"><font face="Times New Roman">.</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">我自己的对</span><span lang="EN-US"><font face="Times New Roman">ACCESS</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">不是很了解</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">只能使用一些日常的</span><span lang="EN-US"><font face="Times New Roman">EXCEL</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">函数</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">在电脑上面操作很多遍</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">也找了很多的参考资料</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">但都没有做成功</span><span lang="EN-US"><font face="Times New Roman">.</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">现恳请高手帮忙</span><span lang="EN-US"><font face="Times New Roman">!</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">主要要求如下</span><span lang="EN-US"><font face="Times New Roman">:</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 68.25pt; TEXT-INDENT: -42pt; mso-list: l0 level1 lfo1; tab-stops: list 68.25pt;"><span lang="EN-US" style="mso-fareast-font-family: ';"><span style="mso-list: ignore;"><font face="Times New Roman">1、<span style="FONT: 7pt ';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">设计一个窗体，每天输入由车间提供的前一天的工人的产量信息，主要项目包括、员工编码</span><span lang="EN-US"><font face="Times New Roman">(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">手工输入</span><span lang="EN-US"><font face="Times New Roman">)</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">、员工姓名（要在输入“员工编码”时自动显示，在输入界面不能修改）、工序代码（手工输入）、工序名称（要在输入“工序代码”时自动显示，在输入界面不能修改）、工序单价（要在输入“工序代码”时自动显示，在输入界面不能修改）、生产数量（手工输入）、工资额（由“生产数量”</span><span lang="EN-US"><font face="Times New Roman">*</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">“工序单价”自动计算得出）日期（默认为系统当前日期，可修改）</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 68.25pt; TEXT-INDENT: -42pt; mso-list: l0 level1 lfo1; tab-stops: list 68.25pt;"><span lang="EN-US" style="mso-fareast-font-family: ';"><span style="mso-list: ignore;"><font face="Times New Roman">2、<span style="FONT: 7pt ';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">能够根据“员工编码”，统计从每月</span><span lang="EN-US"><font face="Times New Roman">1</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">号开始到当前时间，统计每一个工人的工资额；能够根据“工序代码”，统计一个工序的总的人工成本。</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 68.25pt; TEXT-INDENT: -42pt; mso-list: l0 level1 lfo1; tab-stops: list 68.25pt;"><span lang="EN-US" style="mso-fareast-font-family: ';"><span style="mso-list: ignore;"><font face="Times New Roman">3、<span style="FONT: 7pt ';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">月底在所有数据输入完毕以后，能生产一个员工工资汇总表，主要项目包括员工编码、员工姓名、工资</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 68.25pt; TEXT-INDENT: -42pt; mso-list: l0 level1 lfo1; tab-stops: list 68.25pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';"></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 68.25pt; TEXT-INDENT: -42pt; mso-list: l0 level1 lfo1; tab-stops: list 68.25pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">可以教我方法也可以！</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 68.25pt; TEXT-INDENT: -42pt; mso-list: l0 level1 lfo1; tab-stops: list 68.25pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">谢谢</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 68.25pt; TEXT-INDENT: -42pt; mso-list: l0 level1 lfo1; tab-stops: list 68.25pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">联系qq:79983478</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 68.25pt; TEXT-INDENT: -42pt; mso-list: l0 level1 lfo1; tab-stops: list 68.25pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'mso-hansi-font-family:';">Email:hncs456@yahoo.com.cn</span></p>

LangQueS

<p>参考：</p><p><a href="http://club.excelhome.net/viewthread.php?tid=45816&amp;replyID=&amp;skin=0">http://club.excelhome.net/viewthread.php?tid=45816&amp;replyID=&amp;skin=0</a></p><p></p>