访问新手 [英] New to Access

问题描述

我在一家新的汽车经销商的零件部门工作。我们经常向客户询问
车辆的流体容量和类型。不幸的是，这些信息不在我们的零件目录中

所以我们必须从服务手册中获取信息

部门。我有一个聪明的主意，就是收集这些信息并在数据库中输入它，所以我购买了Access。我已经研究了关于关系数据库的som

信息，我对关系有一个理解，但是我只是不知道怎么回事
$ b $它来练习。例如，2005 Explorer有超过

发动机选择，变速箱选择，前后轴选择等。

这些不同的发动机，变速箱等也可能适合差异

年和模特。这会构成多对多关系

我会用什么关键字段来收集所有相关信息

？我喜欢创建一个可以收集年份的表单，用户可以显示所有流体容量和类型

。我将非常感谢任何让我开始使用

方向的帮助

I work in the parts department of a new car dealership. We ar
frequently asked by customers for fluid capacities and types of thei
vehicles. Unfortunately this information is not in our parts catalog
so we must obtain the information from service manuals in the servic
department. I had the bright idea to gather this information and pu
it in a database, so I purchased Access. I have studied som
information regarding relational databases and I have a
understanding on relationships, however I just don''t know how to pu
it to practice. For example, a 2005 Explorer has more than on
engine choice, transmission choice, front and rear axle choice etc.
Also these different engine, transmissions, etc. may fit differen
years and models. Would this constitute a many to many relationship
What key field would I use to gather all the related informatio
together? I like to create a form that would gather the year, mak
and model from a user and display all the fluid capacity and type
for that vehicle. Any help on getting me started in the righ
direction would be greatly appreciated

推荐答案

brink写道：

我在一家新的汽车经销商的零件部门工作。我们经常向客户询问其车辆的流体容量和类型。不幸的是，这些信息不在我们的零件
目录中，因此我们必须从服务部门的服务手册中获取信息。我有一个聪明的主意是收集这些信息并把它放在一个数据库中，所以我购买了Access。我已经研究了关于关系数据库的一些信息，我对关系有一个了解，但是我不知道如何将它用于实践。例如，2005 Explorer有多个发动机选择，变速箱选择，前后轴选择等。
这些不同的发动机，变速箱等可能适合不同的年份和车型。这会构成多对多关系吗？
我会用什么关键字段来收集所有相关信息？我喜欢创建一个表单来收集年份，从用户那里制作
和模型，并显示该车辆的所有流体容量和类型。任何帮助我开始朝正确的方向发展都会非常感激。

I work in the parts department of a new car dealership. We are
frequently asked by customers for fluid capacities and types of their
vehicles. Unfortunately this information is not in our parts catalog, so we must obtain the information from service manuals in the service
department. I had the bright idea to gather this information and put
it in a database, so I purchased Access. I have studied some
information regarding relational databases and I have an
understanding on relationships, however I just don''t know how to put
it to practice. For example, a 2005 Explorer has more than one
engine choice, transmission choice, front and rear axle choice etc.
Also these different engine, transmissions, etc. may fit different
years and models. Would this constitute a many to many relationship?
What key field would I use to gather all the related information
together? I like to create a form that would gather the year, make
and model from a user and display all the fluid capacity and types
for that vehicle. Any help on getting me started in the right
direction would be greatly appreciated.

Strasser回复：

这将是一个良好的线程对于关系数据库的新人

设计谁想使用Access从SCRATCH创建数据库。

我是老师所以讨论将与正常的短期不同/>
答案格式。

Brink，你已经说过你想成为数据库的目标

能够输入汽车：

1）年份

2）制作

3）车型

并显示所有

4）不同类型流体的流体容量


问题：

流体类型你的意思是：

油

刹车

自动变速箱（或手动变速箱）

冷却液容量
这些类型的类型？

请回答这个问题。


设计新数据库的第一步

重要的是要知道你想要什么OUT数据库。

上述准确吗？

您想要哪种格式的信息？

（听起来像一个显示流体容量的表格的屏幕显示

不同的液体类型，所以你可以在他们的时候回答客户

询问类型和他们的汽车的流体容量）


请回答我关于类型的问题。

如果有人想要遵循这种通用的数据库设计

讨论，请回复所以我们知道其他人正在跟随

讨论。


Brink，我会寻找你的答案。 Strasser

Strasser replies:
This will be a good "thread" for anyone NEW to relational database
design who wants to use Access to create the database FROM SCRATCH.
I am a teacher so the discussion will differ from the normal short
answer format.
Brink, you have stated as the database objective that you want to be
able to input automobile:
1) year
2) make
3) model of the car
and display all the
4) fluid capacities for different types of fluids

QUESTION:
By fluid "types" do you mean:
oil
brake
automatic transmission (or manual transmission)
coolant capacity
These kinds of "types"?
Please answer this question.

First step in design of a new database
It is important to know what you want OUT of the database.
Is the above accurate?
What format do you want the information in?
(sounds like a screen display of a form showing fluid capacities
of the different fluid types, so you can answer the customer when they
ask for types and fluid capacities for their cars)

Please answer my question about "types".
If anyone else is going to follow this general database design
discussion, please "reply" so we know others are following along the
discussion.

Brink, I''ll look for your answer. Strasser

Brink，

零件由零件组成，几乎是你需要记住的东西？什么

零件组成哪个其他部分？如果客户用4.6升模块化V-8购买了2004款福特资源管理器

，那么它将获得7夸脱的20W-50，因为这款带有拖车包的
发动机带有一个例如，较大的油冷却器？

基本设计几乎就是物料清单。你只需要一个简单的

物料清单，所以可能它是一辆完成的车辆有一些部件，即b
用于制造它 - 或者一对多关系。在这个例子中，流体将被视为
作为零件。所以，你只需要一个列出所有

相关部分的表格。在该表的一列中将是PART_NO

唯一标识该部分。在第二列中将是BELONGS_TO，其中
包含该部件所属部件的部件号。剩下的就是

你所需要的零件属性。计量单位

和所需单位可能是另外两列。

所以，例如：

PART_MASTER_TBL

PART_NO文本（15）主键

名称文字（50）

DESC文本（255）

UOM文本（15）外键UOM_LKP开UOM_LKP.UOM_CODE文字（15）

UNITS_NEEDED单个

COMPONENT_OF文字（15）外键PART_MASTER_TBL开启

PART_MASTER_TBL.PART_NO


上面的描述可以给你一个想法。它不完全合法

ANSI SQL所以如果没有一些工作它就不会成为一张桌子。但这些想法是

那里。

Brink,
Parts made up of parts, is that pretty much what you need to remember? What
parts made up which other part? If a customer bought a 2004 Ford Explorer
with the 4.6 Litre modular V-8 it gets 7 quarts of 20W-50 because that
engine with the trailer package came with a larger oil cooler, for example?
Pretty much the basic design is a bill of materials. You only need a simple
bill of materials so probably it''s one finished vehicle has some parts that
went into making it--or a one-to-many relationship. Fluids would be treated
as parts in this example. So, you only need one table listing all the
relevent parts. In one of the columns of that table will be a PART_NO that
uniquely identifies that part. In a second column will be BELONGS_TO which
contains the part number of the part that this part belongs to. The rest is
whatever attributes of a part you need for your purpose. Unit of measure
and units needed are probably two additional columns.
So, for example:
PART_MASTER_TBL
PART_NO Text(15) Primary Key
NAME Text(50)
DESC Text(255)
UOM Text(15) Foreign Key UOM_LKP On UOM_LKP.UOM_CODE Text(15)
UNITS_NEEDED Single
COMPONENT_OF Text(15) Foreign Key PART_MASTER_TBL On
PART_MASTER_TBL.PART_NO

The description above should give you an idea. It''s not completely legal
ANSI SQL so it won''t make a table without some work. But the ideas are
there.

那说...读这个...

<一个rel =nofollowhref =http://www.mvps.org/access/modules/mdl0027.htmtarget =_ blank> http://www.mvps.org/access/modules/mdl0027.htm

That said... read this...

http://www.mvps.org/access/modules/mdl0027.htm

这篇关于访问新手的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！