如何在MS-Access中设计一个简单的慈善捐赠数据库？
我被要求为我的教会建立一个简单的数据库。那些使用数据库的人只需要使用表单视图，所以我试图使其非常用户友好。教会有3个银行账户（支票、储蓄、分配）。分配的帐户是我的问题。这个账户里有 4 个独立的使命、筹款、青年、什一税、食物和音乐的资金。
我需要储户能够进入表格，从下拉列表中选择一个帐户，如果他们选择“已分配”，我需要另一个下拉列表来显示资金的去向。我可以列出清单，但它不会更新我的表格。无论我选择哪个帐户，它都会将所有内容发送到支票帐户。
自从我第一次学习 Access 以来已经很多年了，现在即使有几本如何使用的书籍，我似乎也迷失了......欢迎任何帮助。
I have been asked to build a simple database for my church. Those using the database will need to use the form view only, so I am trying to make it very user friendly. The church has 3 bank account (checking, savings, and allocated). The allocated account is my problem. This account holds money for 4 separate missions, fundraisers, youth, tithes, food, and music.
I need the depositor to be able to go to a form choose an account from a drop down list and if they choose Allocated I need another drop list to be available to show where the funds are going. I can make the list but it will not update my table. No matter which account I choose it sends everything to the Checking account.
It has been years since I first learned Access and now even with a couple of how to books I seem lost...any help is welcome.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您的问题不可能有一个简单的答案，因为您没有提出 “可回答”问题。 （例如：如何创建表格等）看来您对此很陌生，所以不要因曲线而气馁。访问可能非常不直观，但实际上只需一点指导就很容易。
我建议您隔离出需要做的一件事来找到解决方案并提出问题。为每个问题发布一个新主题。在您的第一个项目中提出很多问题并不奇怪。但这就是你学习的方式。
另一件需要考虑的事情是，作为一个非营利组织，您也许能够找到愿意贡献时间的人，只是在寻求财务数据库帮助时要小心。不要意外泄露真实数据，这一点非常重要。如果有人要求您提供填充示例，请确保您只提供“测试”数据。我相信您的贡献者和成员会欣赏您的判断力。
如果您确实需要更深入的帮助，可以通过我的个人资料中的信息与我联系，我会尽力帮助非营利组织。
祝你好运！
编辑：另一件需要考虑的事情是，微软慷慨地提供了许多“模板”数据库，您可能会给您一个想法。以下是“慈善捐款”的链接一。
There can't be a simple answer to your question, because you didn't ask a "Answerable" question. (Example: How do I create a table, etc.) It seems you are very new to this, so don't be discouraged by the curve. Access can be very non-intuitive, but it's actually quite easy with a little guidance.
I would suggest to you that you isolate one thing you need to do to get to the solution and ask the question. Post a new thread for each question. It is not unexpected to ask many many question on your first project. But that is how you learn.
Something else to ponder is that as a non-profit you might be able to find someone willing to donate their time, just be careful when soliciting help on a financial database. It's very important that you don't accidentally reveal real data. If someone asks you for a populated example, make sure you only provide "test" data. I'm sure your contributors and members will appreciate your discretion.
If you do want more in depth help you can reach me via the information in my profile, I try to help non-profits out when and where I can.
Best of Luck!
Edit: Another thing to consider is that Microsoft has generously made a lot of "template" databases available that you might would give you an idea or too. Here is a link to the "Charitable Contributions" one.
简单总是情人眼里出西施。在文字处理器中编写一些文本很简单，但请尝试编写单词以允许这样做。
将资金分配到多个银行账户的想法和概念是一个经典的关系数据库问题，几乎每个开发人员都必须处理。至于 ms-access，这是我在 ms-access 中编写的教堂系统的屏幕截图，其功能完全按照您的要求进行：
请注意，上面还有一个自定义菜单栏，这样用户就不会'从未见过 ms-access 界面。因此，您可以按照您想要的任何方式构建和制作自定义界面。请注意，一旦上述捐赠完成并发布，用户就无法更改发布的数据。请注意，对于每笔捐款，我们在右侧都有一个表格，允许人们将资金分配到每个不同的帐户。
在上面，我将应用程序部署为多用户，因此教堂不必为每个工作站购买 ms-access。
上面使用的表结构允许每周批处理作业以及将资金分配到多个帐户的能力，如下所示：
（来源：kallal.ca）
请记住还有更多相关的表来处理教会系统的所有业务需求。然而，上面的表格结构将让您了解如何将资金分配到不同的账户。而且，这允许您生成每月会计报告，然后将其中的数据输入到他们的会计系统中。
Simple is always in the eye of the beholder. It simple to write some text in a word processor, but try writing word to allow this.
The idea and concept of splitting out funds to several banks accounts is a classic relational database problem that darn near every developer has to deal with. As for ms-access, here is a screen shot of church system I wrote in ms-access that does exactly as you ask:
Note how in the above there also a custom menu bar so users don’t EVER see the ms-access interface. So, you can build and make your custom interface just about anyway you want. Note that once the above donations are completed and posted, then users can’t change the posted data. Note how for EACH donation we have a form on the right side that allows one to SPLIT out the funds to each different account.
In the above I deployed the application as multi-user so the church did not have to purchase ms-access for each workstation.
The table structure used in the above to allow weekly batch jobs and the ability to distribute funds to multiple accounts is as follows:
(source: kallal.ca)
Keep in mind there is MANY more related tables to handle all of the business needs of a church system. However, the above table structure will give you the idea as to how you can allow funds to be split out into different accounts. And, this allows you to produce monthly accounting reports in which the data is then entered into their accounting system.
第二个下拉菜单/资金流向是否有控制来源？这应该是表中您要存储第二个值的字段。
Is the second drop-down/where the funds are going have a control source? This should be the field in the table where you want to store this second value.