关系创建成本估算数据库的麻烦 [英] Relationship Trouble in creating a cost estimating database

问题描述

我可能更容易向你展示比我能解释的更好但这里有一个概述。如果需要查看它，请告诉我！

It may be easier for me to show you better than I can explain it but here is an overview. If a view of it is necessary let me know!

我正在创建一个成本估算工具，为项目经理提供每个特定项目的估算，包括所有的花里胡哨。这个估算工具正式保存在Excel中，但是需要大量（复杂）维护才能将其
移动到Access。我对Access非常陌生，但我对表格和表单有基本的了解，但我正在尝试在每个项目的表单末尾创建一个报告，以显示总成本和使用的小时数。有几个
表和很多信息要包括在估算中，我不确定如何关联所有表。我想我已经在外面工作了（在关系之前创建了表格和形式），现在我被困在中间，只要让
实际估算部分滚动。到目前为止，我已经创建了14个表（我不确定它们是否都需要，因为这些信息再次来自我没有创建的非常广泛的Excel工作簿，因此可能会不必要地重复）。表
如下：

I am in the process of creating a Cost Estimating tool to give project managers an estimate of each specific project with all the bells and whistles included. This estimating tool was formally kept in Excel but got to large (complicated) to maintain so its being moved to Access. I am pretty new to Access but I have the basics down as far as tables and forms but I am trying to create a report at the end of the form for each individual project to show the total cost and number of hours used. There are several tables and alot of information to include in the estimate and I am unsure of how to relate all of the tables. I think I have worked my way outside in (created the tables and form before the relationships) and now I'm stuck in the middle as far as getting the actual estimate part rolling. So far I have created 14 tables (which I am unsure if they are all needed because this information again is coming from a really extensive Excel workbook that I did not create so it may be repeated unnecessarily). The tables are as follows:

组织数据，员工数据，财年表，团队负责人，主管，人工成本

Organizational Data, Employee Data, Fiscal Year Table, Team Lead, Supervisor, Labor Costs

非人工成本，本地旅行，旅行，其他直接支持，培训，标准合同

Non Labor Costs, Local Travel,Travel,Other Direct support, Training, Standard Contracts

额外费用，其他直接费用

Extra Expense, Other Direct Costs

组织数据和员工数据都有类似的信息员工列出，每个员工的工资单，小时费率，部门等，并在组织数据中进一步细分了一些细节，即董事和其他职责。

The Organizational Data and Employee Data both have similar information employees listed, each employees' payband, hourly rate, Department etc and in the organizational data it further breaks down some of the specifics i.e. directors and other duties.

"肉"估计数主要涉及其余表格，指明何时何地何时何地。在劳动力，直接支持和其他直接表格中，存在与所使用的员工相关的字段，其总时数（处理员工表中员工的小时费率
）他们的主管和团队负责人 （谁得到一个固定的百分比）和小时和成本的总和。其余表格仅涉及实际活动的总小时数和费用（即，培训不是b $ b特别与员工有关，因为它被分为直接和其他直接/人工成本的小时和费用）。

The "meat" of the estimate primarily deals with the rest of the tables specifiying who what when and where. In the labor, direct support and other direct tables there are fields that pertain to the employees used, their total hours (which deal with the hourly rate of the employee in the employee table) their supervisors and team leads (who get a fixed percentage) and totals of both hours and cost. The rest of the tables only pertain to total hours and cost of the actual event (i.e. training doesnt specifically relate to an employee since it is rolled into the direct and other direct/labor costs for hours and cost).

我的问题是如何将这些表格（添加字段或密钥）联系起来以最终报告显示整个项目的总体成本和小时数？希望有人可以帮我解决这个问题。

My question is how do I relate these tables (add fields or Keys) to end up with a report to show the overall cost and number of hours for the entire project? Hopefully someone can assist me with this.

我可能很简单地说明你比我能解释的更好，如果你愿意的话帮助让我知道，我可以发送一个空的复制。

IT MAY BE ALOT SIMPLER TO SHOW YOU BETTER THAN I CAN EXPLAIN IT SO IF YOU ARE ABLE TO HELP LET ME KNOW AND I CAN SEND AN EMPTY COPY.

谢谢： - ）

Jess

推荐答案

简而言之，Access是一个关系数据库，因此需要关联的字段。您似乎需要创建一个包含id，name，...以及其他一些字段的项目表，例如开始日期，结束日期，说明等。每个其他表lilke劳动力，
旅行等都需要有项目ID。然后，您将能够使用总计编写查询/报告。您是否看过一些模板，看看它们与表格的关系？

In short Access is a relational DB and as such it need fields to relate on. It seems like you need to create a project table with an id, name, ... and some other fields like start date, end date, description and so on. Every other table lilke labor, travel and so on need to have the project id in it. Then you will be able to write a query / report with totals. Did you look at some of templates and see how they relate tables?

HTH

Martin

这篇关于关系创建成本估算数据库的麻烦的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！