[会计精品]用EXCEL+ACCESS做的凭证报表处理系统

zbs112 · 发表于 2006-9-12 19:24

用EXCEL+ACCESS做的凭证处理系统，可与正规软件比美！精心打造，是会计人的福音，喜欢的请跟贴！使用中如有问题，可以加我的QQ咨询（178297207快乐如雨）<span style="FONT-SIZE: 10.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.0pt; mso-bidi-font-family: Tahoma; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-font-kerning: 1.0pt;">登录的密码是你的电脑时间：年+月+日，如今天是：20070212

lIUawi6r.rar (163.07 KB, 下载次数: 7026)

[此贴子已经被作者于2007-2-12 15:28:43编辑过]

zbs112 · 发表于 2006-9-12 19:25

<img src="attachments/dvbbs/2006-9/200691219253698633.jpg" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" /> <span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">3<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">）点击<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">[<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">科目初始化<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">]<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">按钮，这样就会弹出一个双窗口的设置，下面窗口显示的为统一的会计科目编码表，其目的是为了统一我们建账的科目编码和会计制度中要求的编码相一致。具体的操作方法为：根据自己的企业需要，用鼠标双击下面窗口的会计科目，这样就自然把该会计科目的信息跳到上一个窗口里，此时不要关闭些窗口，连续用鼠标双击所需的会计科目，然后点<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">[<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">会计科目<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">>>>KMB]<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">按钮，这样就会把我们所设定的会计科目自然保存到<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">ACCESS<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">数据库里的<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">KMB<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">表。

[此贴子已经被作者于2006-10-24 14:42:22编辑过]

zbs112 · 发表于 2006-9-12 19:26

<img src="attachments/dvbbs/2006-9/200691219263580589.jpg" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" /><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">4）上面的会计科目设置完成后，请点击[科目修改]按钮，此时弹出一个可进行录入、修改、删除的操作界面，在科目类别里，可以点资产、负债、权益、成本、损益，这样在窗口里就会相应地列示出各该科目类别的所有已经设定好的会计科目，如点资产类，出现：现金、银行存款、等等，如银行存款有明细100201（银行存款——工商银行，期初金额也一并打入）、100202（银行存款——建设银行，期初金额也一并打入），然后点[修改]或[录入]按钮，说明：如有明细时，就不用保留原来的四位数总账科目，如1002银行存款。特别说明的是当出现有三级会计科目的设置方法：<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">如<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">217101<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">应交税金——应交增值税——进项税额（已交税金、转出未交增值税、进项税额转出、销项税额、等等），我们要简化为二级科目设置，如直接设置为<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">21710101<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">应交税金——应交增值税（进项税额），<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">21710102<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">应交税金——应交增值税（已交税金），<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">21710103<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">应交税金——应交增值税（转出未交增值税），<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">21710104<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">应交税金——应交增值税（进项税额转出），<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">21710105<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">应交税金——应交增值税（销项税额）等等，然后把<span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: "Arial Narrow"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">217101<span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: "Arial Narrow"; mso-hansi-font-family: "Arial Narrow"; mso-font-kerning: 1.0pt; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">应交税金——应交增值税的科目设置不要。

[此贴子已经被作者于2006-10-24 15:04:48编辑过]

zbs112 · 发表于 2006-9-12 19:27

<img src="attachments/dvbbs/2006-9/200691219243094922.jpg" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" />

[此贴子已经被作者于2006-10-24 15:11:27编辑过]

zbs112 · 发表于 2006-9-12 19:28

<img src="attachments/dvbbs/2006-9/200691219272596927.jpg" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" />

[此贴子已经被作者于2006-10-24 15:09:55编辑过]

zbs112 · 发表于 2006-9-12 19:29

<img src="attachments/dvbbs/2006-10/200610269555168331.jpg" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" />

[此贴子已经被作者于2006-10-26 9:55:59编辑过]

lczx · 发表于 2006-9-12 20:43

看上去很不错哦

zls5188 · 发表于 2006-9-12 21:12

支持

月黑风高 · 发表于 2006-9-12 21:24

东西呢老大?

qrg9516 · 发表于 2006-9-13 10:49

等待

		自动登录	找回密码
密码			免费注册

[原创] [会计精品]用EXCEL+ACCESS做的凭证报表处理系统