新数据库帮助 [英] New Database Help
问题描述
你好，
我是Jo，这是我第一次在这里发布。我正在制作
a数据库，并且有点松散......我有点新手
并且想知道是否有人有帮助。我在图书馆工作，并向双重或其他国籍的婴儿发送双b / b
语言书籍。
该数据库将用于记录一系列书名和数字订购
和发给个人的书籍。我正试图找出一种方法来保持每个标题中有多少我有库存，这样我就可以看到何时订购
更多。到目前为止我有意义吗？
一张桌子有以下字段：
书名（例如丛林动物（阿尔巴尼亚人）或丛林动物（古吉拉特语））
订购日期
编号订购
另一张表（和相关表格）详细列出了发送给
个人：
姓名
地址
等
书名
发出日期
我很难找到一种方法 - 如果有的话 - 将信息链接到
跟踪库存号码。我尝试了各种查询并将
数据导出到Excel但却陷入了困境。这可能是一个非常简单的方式，但我没有经验，我可以解决它！
我会很感激任何建议。
谢谢，
Jo
Hi there,
I''m Jo and it''s the first time I''ve posted here. I''m in process of creating
a database at work and have come a little unstuck.....I''m a bit of a novice
and wondered if anyone could help. I work in a library and send out dual
language books to babies of dual or other nationality.
The db is to be used for logging a range of book titles and numbers ordered
and books sent out to individuals. I am trying to work out a way of keeping
track of how many of each title I have in stock so I can see when to order
more. Am I making sense so far?
One table has the following fields:
Book Title (e.g. Jungle Animals (Albanian) or Jungle Animals (Gujarati))
Date Ordered
No. Ordered
Another table (and related form) has details of books sent out to
individuals:
Name
Address
etc
Book Title
Date Sent Out
I am struggling to find a way - if there is one - of linking the info so to
keep track of stock numbers. I have tried various queries and exporting
data to Excel but got in a real muddle. There''s probably a really simple
way, but I''m not that experienced that I can work it out!
I would appreciate any advice.
Thanks,
Jo
推荐答案
" Jo" < jo@NOSPAM.stallan.plus.com写在留言中
news：46 ********************** @ ptn-nntp -reader02.plus.net ...
你好Jo，
你能适应或得到一些指示吗？
http： //office.microsoft.com/en-gb/te...1033&av=ZAC000
问候，
基思。
www.keithwilby.com
"Jo" <jo@NOSPAM.stallan.plus.comwrote in message
news:46**********************@ptn-nntp-reader02.plus.net...
Hi Jo,
Could you adapt or get some pointers from this?
http://office.microsoft.com/en-gb/te...1033&av=ZAC000
Regards,
Keith.
www.keithwilby.com
你好Jo，还有。希望你能在这里得到很好的帮助。
如果这是你的第一个数据库，第一步是建立一个数据结构
（表格）
他们之间有所有正确的联系（一对多的关系）。
你可能有多个特定标题的副本。大概你想要
能够单独追踪每一个，例如这个特殊的副本
丛林动物是由Jo Smith在2月28日借来的，所以她应该在3/28之前把它给我们。如果是这样，对于每本书名，你可以有很多实例
这本书：标题和书籍之间的一对多关系。并且你借出一本书（不仅仅是一个标题）。这意味着这些表：
标题表（每个标题/书出版的一个记录）
TitleID自动编号主键
标题书的文字名称
ISBN文字
年出版编号
...
书桌（您购买的每份副本一条记录）
BookID自动编号主键
TitleID编号与Title.TitleID
DateAcquired你有这本书的日期/时间
...
现在，一个人可以从你多次。因此，您与借款人和贷款之间存在一对多的关系。这些表：
借款人表（每个人一个记录）
BorrowerID自动编号主键
姓氏文本
FirstName文字
地址文字
城市文字
邮编文本
...
贷款表（每次有人借书时记录一次）：
LoanID自动编号主键
BorrowerID编号与Borrower.BorrowerID
LoanDate取出时的日期/时间。
当有人借书时，他们经常会多次借书。任何
贷款都有多个项目：贷款
和贷款详情之间的一对多关系。因此借入贷款的书籍会进入相关表格：
LoanDetail表格（贷款项目）：
LoanDetailID AutoNumber主键
贷款ID贷款这是一个行项目）
BookID号码借来的书
到期日期/本书到期的时间（空白，直到
返回。）
这是基本的开始。创建正确的表和关系对于获得有用的数据库绝对至关重要。
-
Allen Browne - Microsoft MVP 。西澳大利亚珀斯
访问用户提示 - http：// allenbrowne .com / tips.html
回复群组，而不是mvps dot org的allenbrowne。
" Jo" < jo@NOSPAM.stallan.plus.com写在留言中
news：46 ********************** @ ptn-nntp -reader02.plus.net ...
Hi Jo, and welome. Hope you are able to derive good help here.
If this is your first database, the first step is to set up a data structure
(tables) that has all the right connections (one to many relations) between
them.
You might have more than one copy of a particular title. Presumably you want
to be able to track each one individually, e.g. this particular copy of
"Jungle Animals" was borrowed by Jo Smith on 2/28, and so she should have it
back to us by 3/28. If so, for each book title, you can have many instances
of the book: a one-to-many relation between Titles and Books. And you lend
out a book (not merely a title.) That means these tables:
Title table (one record for each title/book published)
TitleID AutoNumber primary key
Title Text name of the book
ISBN Text
YearPublished Number
...
Book table (one record for each copy you buy)
BookID AutoNumber primary key
TitleID Number relates to Title.TitleID
DateAcquired Date/Time when you got this book
...
Now, one person can borrow from you multiple times. Therefore you have a
one-to-many relation between borrower and loans. These tables:
Borrower table (one record for each person)
BorrowerID AutoNumber primary key
Surname Text
FirstName Text
Address Text
City Text
Zip Text
...
Loan table (one record each time someone borrows books):
LoanID AutoNumber primary key
BorrowerID Number relates to Borrower.BorrowerID
LoanDate Date/Time when taken out.
When someone borrows books, they often borrow more than one at at time. Any
loan therfore has multiple line-items: a one-to-many relation between Loan
and loan details. So the books borrowed in a loan go into a related table:
LoanDetail table (line items for a loan):
LoanDetailID AutoNumber primary key
LoanID Number which loan this is a line item of)
BookID Number the book that was borrowed
DueDate Date/Time when this book is due back (blank until
returned.)
That''s the basic start. Creating the right tables and relationships is
absolutely crucial to getting a useful database.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jo" <jo@NOSPAM.stallan.plus.comwrote in message
news:46**********************@ptn-nntp-reader02.plus.net...
你好，
我是Jo，它是'我第一次在这里发布。我正在处理
在工作中创建一个数据库并且有点松散......我有点
的新手并且想知道是否谁都可以帮忙。我在图书馆工作，
向双重或其他国籍的婴儿发送双语书籍。
数据库将用于记录一系列书名和数字
订购，书籍发给个人。我正试图找出一种方法
跟踪每个标题中有多少我有库存，所以我可以看到
何时订购更多。到目前为止我有意义吗？
一张桌子有以下字段：
书名（例如丛林动物（阿尔巴尼亚人）或丛林动物
（古吉拉特语））
订购日期
订购号
另一张表（和相关表格）有详细信息发送给
个人的书籍：
名称
地址
等
书名
发出日期
我很难找到一种方法 - 如果有的话 - 链接信息如此
跟踪库存数量。我尝试了各种查询和
将数据导出到Excel但却陷入了困境。可能有一个非常简单的方式，但我不是那么经验，我可以解决它！
我会很感激任何建议。
谢谢，
Jo
Hi there,
I''m Jo and it''s the first time I''ve posted here. I''m in process of
creating a database at work and have come a little unstuck.....I''m a bit
of a novice and wondered if anyone could help. I work in a library and
send out dual language books to babies of dual or other nationality.
The db is to be used for logging a range of book titles and numbers
ordered and books sent out to individuals. I am trying to work out a way
of keeping track of how many of each title I have in stock so I can see
when to order more. Am I making sense so far?
One table has the following fields:
Book Title (e.g. Jungle Animals (Albanian) or Jungle Animals
(Gujarati))
Date Ordered
No. Ordered
Another table (and related form) has details of books sent out to
individuals:
Name
Address
etc
Book Title
Date Sent Out
I am struggling to find a way - if there is one - of linking the info so
to keep track of stock numbers. I have tried various queries and
exporting data to Excel but got in a real muddle. There''s probably a
really simple way, but I''m not that experienced that I can work it out!
I would appreciate any advice.
Thanks,
Jo
Jo，
认可这里。艾伦是接入MVP的'库存类型的MVP'
应用程序 - 他是我们转向这个
主题的样本和建议的人。 br />
Larry Linson
Microsoft Access MVP
Jo,
Just an "endorsement" here. Allen is the Access MVPs'' MVP on inventory-type
applications -- he''s the one to whom we turn for samples and advice on this
subject.
Larry Linson
Microsoft Access MVP
这篇关于新数据库帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
