教会数据库字母分配 [英] Church Database alphabetical assignment

问题描述

大家好！


我有一个教会数据库，可以跟踪我们教会的所有成员：名字和姓氏，电子邮件地址，电话号码，家庭住址（街道，城市，邮政编码）。


我想知道......


每个星期天早上，其中一位成员站在讲坛前的会众面前，读了大约10节经文来自圣经。在我们读完整本圣经（大概需要2 1/2到3年）后，我们重新开始。每个星期天，都是不同的人阅读不同的一组经文。


我们一直在跟读谁读过Iast，他们读了什么，谁读了下一个，以及他们是什么将在纸上阅读。但是，我想让我们的教会能够使用我们的成员数据库来执行此操作...可能会打印出一份报告。你知道，要记录哪个成员上次阅读，哪些经文被阅读，但不想每个月自动输入...我希望它按字母顺序循环我们的成员并分配圣经经文。


有没有办法做到这一点，有没有人有想法？使用新表？

Hi everyone!

I have a church database that keeps track of all of our church''s members: first and last name, email address, phone number, home address (street, city, zipcode).

I was wondering....

Every Sunday morning one of the members stands before the congregation in the pulpit and reads about 10 verses from the Bible. After we read through the entire Bible (which takes about 2 1/2 to 3 years), we start over. Every Sunday, it''s someone DIFFERENT that reads a DIFFERENT set of verses.

We HAVE been keeping up with who read Iast, what they read, who reads next, and what they WILL read on paper. However, I want to give our church the ability to use our member database to do this...maybe print out a report. You know, to keep track of which member read last and which verses were read, but don''t want to have to enter it automatically each month...I want it to cycle through our members alphabetically and assign the Bible verses.

Is there a way to do this, does anyone have an ideas? Make use of a new table?

推荐答案

执行此操作的能力完全取决于您了解有关数据库尤其是VBA的更多信息。对于胆小的人来说，这不是一项任务！

您要问的是将数据库的结构从主要是存储信息的车辆更改为基于活动的调度程序。


这是可能的，但首先，让我建议您阅读几本关于Access的好书，确保它们至少有2英寸厚（不是玩笑）。另外，我可以建议阅读Mike Hernandez的第二版数据库设计。您可以在亚马逊上找到它几美元，它可以为您规划和设计您想要的数据库带来奇迹。


亲切的问候，

斯科特

The ability to do this depends entirely on your motivation to learn more about databases and especially VBA. This is not a task for the faint of heart!

What you are asking is to change the structure of your database from primarily being a vehicle to store information to being an activity based scheduler.

It is possible, but first of all, let me suggest that you read a couple of the good books on Access, make sure they''re at least 2 inches thick (not a joke). Also, may I suggest reading through Database Design for Mere Mortals 2nd Edition by Mike Hernandez. You can find it on Amazon for a few dollars, and it will do wonders for you in planning and designing the database you want.

Kind regards,
Scott

实际上我从看过去的帖子看到你对VBA有所了解，这让我对你正在尝试的事情更加积极地思考:-)


您是否介意发布当前数据库的表结构，以及如何考虑实施调度更改？


问候，

Scott

Actually I see from looking at your past threads that you do know something about VBA, which makes me think a little more positively about what you are attempting :-)

Would you mind posting the table structure of your current database, and how you are thinking about implementing the scheduling changes?

Regards,
Scott

实际上我从查看过去的帖子看到你对VBA有所了解，这让我想到了更多关于你正在尝试的事情:-)

您是否介意发布当前数据库的表结构，以及如何考虑实施调度更改？


问候，

Scott

Actually I see from looking at your past threads that you do know something about VBA, which makes me think a little more positively about what you are attempting :-)

Would you mind posting the table structure of your current database, and how you are thinking about implementing the scheduling changes?

Regards,
Scott

嘿Scott，


感谢您对我的问题表现出兴趣！我有几个表，但我关注的三个表是tblMember，tblMenDuties和tblMenWorshipOpportunity。在tblMenWorshipOpportunity中，我有15个不同的参与机会。在崇拜中，其中一个是阅读。表tblMenDuties使用一对多关系，我在其中设计了一个用户输入表单，用于将机会（从tblMenWorshipOpportunity）分配给来自tblMember的选定成员。


我真的处于思考状态关于现在该怎么做。就像你说的那样，我知道一点VBA，还有一点ACCESS，但是，我有点卡住，哈哈。就像你说的那样，它不再仅仅是一个存储数据库。我在tblMember有大约300条记录。现在，我想对这些成员做点什么。


我有一个查询从tblMenDuties获取所有希望读取的成员。它按成员姓氏的字母顺序排序。我想创建另一个表（也许是tblRead）来输入本周3/2/2008的读者，并自动从查询中提取下一个字母名称，以便在下周日的日期创建一个新记录。


实际上，这将是一年中的一个连续过程...在查询中的最后一条记录（想要阅读的成员列表）之后，列表将重新开始，查询中的第一个成员按字母顺序我们可以继续轮流读圣经了。


你说得对......这会很难（叹气......哈哈）

>
谢谢，

Joseph

Hey Scott,

Man thanks for showing interest in my problem! I have several tables, but the three of which I am concerned with are tblMember, tblMenDuties, and tblMenWorshipOpportunity. In tblMenWorshipOpportunity I have 15 different opportunities for "participating" in worship, one of which is "Read." The table tblMenDuties utilizes a one-to-many relationship in which I have designed a user-input form to assign opportunities (from tblMenWorshipOpportunity) to a selected member from tblMember.

I am really in a state of "thinking" about what to do now. It''s like you said, I know a bit of VBA, and a bit of ACCESS, however, I''m a bit stuck, lol. And like you said, it no longer can just be a storage database. I have about 300 records in tblMember. Now, I want to do something with those members.

I have a query that pulls from tblMenDuties all of the members that wish to "Read". It''s sorted in alphabetical order by member last name. I want to make another table (maybe tblRead) to input who read this week 3/2/2008 and automatically pull the next alphabetical name from the query to make a new record with next Sunday''s date.

Really, it''d be a continuous process throughout the year...after the last record in the query has been reached (the list of members who want to read), the list will start over, with the first member in the query "alphabetically" and we can continue taking turns reading the Bible.

You''re right....this is gonna be tough (sigh...haha)

Thanks,
Joseph

这篇关于教会数据库字母分配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！