非常生锈的前初级/中级访问家伙需要一点帮助 [英] Very Rusty Former Beginner/Intermediate Access Guy Needs a Little Help
问题描述
我正在使用Access 2002为一家小型歌剧公司创建一个数据库，我的妻子参与其中，而且我有点生疏，因为我还没有自从1999年左右开始创建
a新的Access数据库。所以，当我通过这个时，我可能会有相当多的问题，希望这个小组会帮助我
out。
我将创建此数据库供其他人输入数据。我有一个带有姓名，地址，电子邮件等的顾客表格，我想要添加一个表格来支付给顾客的捐款捐赠表格。我需要的所有形式
是姓氏，名字，日期和金额。我知道我可以使用一个组合框这样
数据录入人员可以选择姓氏，但我需要以某种方式包含第一个
名称，因为有几个人相同的姓氏。
如何解决这个问题？
谢谢，
杰克
I''m using Access 2002 to create a database for a small opera company that my
wife is involved in, and I''m more than a bit rusty because I haven''t created
a new Access database since about 1999. So, I will probably have quite a
few questions as I go through this, and hopefully this group will help me
out.
I will be creating this database for someone else to enter the data. I have
a patron table with name, address, email, etc., and I want to add a form to
enter donations from patrons into a donation table. All I need in this form
is last name, first name, date, and amount. I know I can use a combo box so
the data entry person can select last name, but I need to include the first
name somehow also as there are several people with the same last names.
How do I go about this?
Thanks,
Jack
推荐答案
这只是一个数据库，旨在跟踪各位赞助人的捐款/捐款吗？b $ b？
4月6日上午11点06分，杰克B < jbr ... @ wi.rr.comwrote：
Is this merely a database designed to track donations/contributions
from your various patrons?
On Apr 6, 11:06 am, "Jack B" <jbr...@wi.rr.comwrote:
我正在使用Access 2002为我的一家小型歌剧公司创建一个数据库>
妻子参与其中，而且我有点生疏，因为自1999年以来我还没有创建新的Access数据库。所以，我可能会有一个相当的
我经历过这个问题，希望这个小组会帮助我
out。
我将创建这个数据库供其他人输入数据。我有一个带有姓名，地址，电子邮件等的顾客表格，我想要添加一个表格来支付给顾客的捐款捐赠表格。我需要的所有形式
是姓氏，名字，日期和金额。我知道我可以使用一个组合框这样
数据录入人员可以选择姓氏，但我需要以某种方式包含第一个
名称，因为有几个人相同的姓氏。
如何解决这个问题？
谢谢，
Jack
I''m using Access 2002 to create a database for a small opera company that my
wife is involved in, and I''m more than a bit rusty because I haven''t created
a new Access database since about 1999. So, I will probably have quite a
few questions as I go through this, and hopefully this group will help me
out.
I will be creating this database for someone else to enter the data. I have
a patron table with name, address, email, etc., and I want to add a form to
enter donations from patrons into a donation table. All I need in this form
is last name, first name, date, and amount. I know I can use a combo box so
the data entry person can select last name, but I need to include the first
name somehow also as there are several people with the same last names.
How do I go about this?
Thanks,
Jack
它还会跟踪顾客参加的活动，他们应该收到的邮件，
或许还有一些这样的事情，但那就是它。
DavidB < je *** @ yahoo.com在留言中写道
新闻：11 ********************* @ o5g2000hsb.googlegrou ps。 com ...
It will also track events the patrons attend, mailings they should get,
maybe a few more things like that, but that''s about it.
"DavidB" <je***@yahoo.comwrote in message
news:11*********************@o5g2000hsb.googlegrou ps.com...
这只是一个数据库，旨在跟踪各位顾客的捐款/捐款
？
4月6日上午11:06，杰克B < jbr ... @ wi.rr.comwrote：
Is this merely a database designed to track donations/contributions
from your various patrons?
On Apr 6, 11:06 am, "Jack B" <jbr...@wi.rr.comwrote:
>我正在使用Access 2002为一家小型歌剧公司创建数据库我的妻子参与其中，而且我有点生疏，因为自1999年以来我还没有创建一个新的Access数据库。所以，我可能会我经历过这个问题很少，希望这个小组会帮助我
我将创建这个数据库供其他人输入数据。我有一个带有姓名，地址，电子邮件等的顾客表，我想添加一个表格
来将顾客的捐款输入捐款表。我需要的所有
表格
是姓氏，名字，日期和金额。我知道我可以使用一个组合框
所以数据录入人员可以选择姓氏，但我需要以某种方式包含
名称，因为有几个人相同的姓氏。
我该怎么做？
谢谢，
Jack
>I''m using Access 2002 to create a database for a small opera company that
my
wife is involved in, and I''m more than a bit rusty because I haven''t
created
a new Access database since about 1999. So, I will probably have quite a
few questions as I go through this, and hopefully this group will help me
out.
I will be creating this database for someone else to enter the data. I
have
a patron table with name, address, email, etc., and I want to add a form
to
enter donations from patrons into a donation table. All I need in this
form
is last name, first name, date, and amount. I know I can use a combo box
so
the data entry person can select last name, but I need to include the
first
name somehow also as there are several people with the same last names.
How do I go about this?
Thanks,
Jack
建议你刷新规范化的基本规则，这样你就可以确定你在设置表/关系正确 - 那是'b
数据库的四分之三。有关详细信息，请参阅
http：// home.att.net/~california.db/tips.html#aTip1
hth
" Jack B" < jb **** @ wi.rr.com在留言中写道
news：46 ********************** @ roadrunner .com ...
recommend you refresh youself on the basic rules of normalization, so you
can be sure you''re setting up the tables/relationships correctly - that''s
three-fourths of the database right there. for more information, see
http://home.att.net/~california.db/tips.html#aTip1
hth
"Jack B" <jb****@wi.rr.comwrote in message
news:46**********************@roadrunner.com...
我正在使用Access 2002为一家小型歌剧公司创建一个数据库
I''m using Access 2002 to create a database for a small opera company that
我的
my
妻子参与其中，而且我有点生疏，因为我没有
wife is involved in, and I''m more than a bit rusty because I haven''t
创建
created
a自1999年以来新的Access数据库。所以，我可能会有相当多的
几个问题当我经历这个时，希望这个小组会帮助我
out。
我将创建这个数据库供其他人输入数据。我
a new Access database since about 1999. So, I will probably have quite a
few questions as I go through this, and hopefully this group will help me
out.
I will be creating this database for someone else to enter the data. I
有
have
a顾客表，包括姓名，地址，电子邮件等，我想要添加表格
a patron table with name, address, email, etc., and I want to add a form
到
to
将顾客的捐款输入捐款表。我需要的所有
enter donations from patrons into a donation table. All I need in this
形式
form
是姓氏，名字，日期和金额。我知道我可以使用组合框
is last name, first name, date, and amount. I know I can use a combo box
所以
so
数据录入人员可以选择姓氏，但我需要包含
the data entry person can select last name, but I need to include the
首先
first
名称也因为有几个人有同样的姓氏。
如何解决这个问题？
谢谢，
杰克
name somehow also as there are several people with the same last names.
How do I go about this?
Thanks,
Jack
这篇关于非常生锈的前初级/中级访问家伙需要一点帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
