数据库设计 - 包含特定事件的年份 [英] Database design - incorporate year of a certain event
问题描述
我有一个问题我正试图弄清楚如何在Access中解决。我/ b $ b有一个志愿者数据库,每年都有一个项目。目前
我必须每年进入并消除数据以开始新的数据。我想
以某种方式能够将年份信息合并到数据库中。
例如,保留2005年的信息,并添加2006' 的。所以明年我可以把b
拉起来说哦,是的,某某参与那一年。任何
想法?
Kevin
12月19日星期一2005 06:27:13 GMT,Kevin< wi ****** @ hotmail.com>写道:
我有一个问题我正试图弄清楚如何在Access中解决。我每年都有一个项目志愿者数据库。目前
我必须每年进入并消除数据以开始新的数据。我想以某种方式将年份的信息纳入数据库。
例如,保留2005年的信息,并添加2006年的信息。所以明年我可以拉起2005年并说哦,是的,某某参与那一年。任何
想法?
凯文,这是一件非常重要的事情,我不能理解
你的问题。你有一张桌子。该表中包含信息。
您添加一个名为ProjectYear的字段。您在该字段中输入一年(2004年,2005年,
等)。
您的数据库现在可以根据年份进行区分。
我缺少什么?
mike
我想也许我''我错过了什么,你为什么不在
相关表格中添加一个字段并将年份存入其中?
-
Terry Kreft
" Kevin" <无线****** @ hotmail.com>在消息中写道
news:pa **************************** @ hotmail.com ... < blockquote class =post_quotes>
我有一个问题我正试图弄清楚如何在Access中解决。我每年都有一个项目志愿者数据库。目前
我必须每年进入并消除数据以开始新的数据。我想以某种方式将年份的信息纳入数据库。
例如,保留2005年的信息,并添加2006年的信息。所以明年我可以拉起2005年并说哦,是的,某某参与那一年。任何
想法?
凯文
2005年12月19日星期一09:31:06 +0000,迈克Preston写道:
2005年12月19日星期一06:27:13 GMT,Kevin< wi ****** @ hotmail.com>写道:
我有一个问题我正试图弄清楚如何在Access中解决。我有一个志愿者数据库,用于每年发生的一个项目。
目前我必须每年进入并消除数据以开始新的数据。
我想以某种方式能够合并今年的信息进入
数据库。
例如,保留2005年的信息,并添加2006年的信息。所以明年我可以拉起2005年并说噢,某某参与那一年。
任何想法?
凯文,这是一件非常重要的事情,我不能理解你的问题。你有一张桌子。该表中包含信息。您添加一个名为ProjectYear的
字段。您将一年(2004年,2005年等)输入该
字段。
您的数据库现在可以根据年份进行区分。
什么我错过了吗?
mike
也许我只是想太多了。字段ProjectYear将是b $ b罚款,但如果数据库年复一年地使用,而且一个志愿者的b $ b b数据是去年的,那么就已经说了 ; 2005"对于
的例子。明年会发生什么?如果我将其更改为2006,我没有更长的时间有他们参加2005年的记录。所以,我想这是一个志愿者的
问题表(姓名,地址,志愿者网站等)
我如何联系参与的年份?
Kevin
I have a problem I''m trying to figure out how to resolve in Access. I
have a volunteer database for a project which occurs each year. Currently
I have to go in and wipe out the data each year to start new. I want to
somehow be able to incorporate the year''s info into the database.
For instance, keep 2005''s information, and add 2006''s. So next year I can
pull up 2005 and say "oh yeah, so-and-so participated that year". Any
ideas?
Kevin
On Mon, 19 Dec 2005 06:27:13 GMT, Kevin <wi******@hotmail.com> wrote:
I have a problem I''m trying to figure out how to resolve in Access. I
have a volunteer database for a project which occurs each year. Currently
I have to go in and wipe out the data each year to start new. I want to
somehow be able to incorporate the year''s info into the database.
For instance, keep 2005''s information, and add 2006''s. So next year I can
pull up 2005 and say "oh yeah, so-and-so participated that year". Any
ideas?
Kevin, this is such a trivial matter that I must not be understanding
your question. You have a table. That table has information in it.
You add a field called "ProjectYear". You enter a year (2004, 2005,
etc.) into that field.
Your database now has the ability to distinguish based on the year.
What am I missing?
mike
I think maybe I''m missing something, why don''t you add a field to the
relevant tables and store the year in it ?
--
Terry Kreft
"Kevin" <wi******@hotmail.com> wrote in message
news:pa****************************@hotmail.com...
I have a problem I''m trying to figure out how to resolve in Access. I
have a volunteer database for a project which occurs each year. Currently
I have to go in and wipe out the data each year to start new. I want to
somehow be able to incorporate the year''s info into the database.
For instance, keep 2005''s information, and add 2006''s. So next year I can
pull up 2005 and say "oh yeah, so-and-so participated that year". Any
ideas?
Kevin
On Mon, 19 Dec 2005 09:31:06 +0000, Mike Preston wrote:
On Mon, 19 Dec 2005 06:27:13 GMT, Kevin <wi******@hotmail.com> wrote:I have a problem I''m trying to figure out how to resolve in Access. I
have a volunteer database for a project which occurs each year.
Currently I have to go in and wipe out the data each year to start new.
I want to somehow be able to incorporate the year''s info into the
database.
For instance, keep 2005''s information, and add 2006''s. So next year I
can pull up 2005 and say "oh yeah, so-and-so participated that year".
Any ideas?
Kevin, this is such a trivial matter that I must not be understanding your
question. You have a table. That table has information in it. You add a
field called "ProjectYear". You enter a year (2004, 2005, etc.) into that
field.
Your database now has the ability to distinguish based on the year.
What am I missing?
mike
Maybe I''m just thinking about it too much. A field "ProjectYear" would be
fine, but if the database is used year after year, and one volunteer''s
data is in there from the previous year, it would already say "2005" for
example. What happens the next year? If I change it to "2006", I no
longer have a record of them taking part in 2005. So, I guess the
question is, given a volunteer table (name, address, volunteer site, etc.)
how do I relate the years participated?
Kevin
这篇关于数据库设计 - 包含特定事件的年份的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!