创建数据库以替换多个excel条目表单-CreationofDatabasetoreplacemultipleexcelentryforms

I have been given a project from work and although I have built multiple databases before, for some reason this one is stumping me. I need to create a database to capture data which was previously being captured on multiple spreadsheets to simplify the statistics program at my company. Each spreadsheet captured key pieces of information, I've attached an example of each. Each sheet needs to be set up so that an individual can enter their information for their location and that one person (me) can enter the full company information. For example the hours form, from this form I need to capture the employee count and manhours, whereas from the district sheet I need to capture contractor hours, vehicle data (second tab), and performance data on a monthly basis. The final entry needs to be able to enter all of the counts on the counts link form in order to create a table similar to the link form. Can anyone help me figure out where to start, I have been feeling like hitting my head against the wall for about an hour now and cannot figure out where to begin.

我从工作中得到了一个项目,虽然之前我已经建立了多个数据库,但出于某种原因,这个数据库让我很难过。我需要创建一个数据库来捕获以前在多个电子表格中捕获的数据,以简化我公司的统计程序。每个电子表格都捕获了关键信息,我附上了每个信息的例子。需要设置每张纸,以便个人可以输入他们的位置信息,并且一个人(我)可以输入完整的公司信息。例如,小时表格,从这个表格我需要捕获员工数量和工时,而从区域表格我需要每月捕捉承包商时间,车辆数据(第二个标签)和性能数据。最终条目需要能够在计数链接表单上输入所有计数,以便创建类似于链接表单的表。任何人都可以帮我弄清楚从哪里开始,我一直觉得自己的头撞在墙上大约一个小时了,无法弄清楚从哪里开始。

https://www.dropbox.com/s/nnjh0x14k5jei7w/Database%20Files.zip

1 个解决方案

DIVISION (northeast, Rocky Mountain, etc)
REGION (Southern Appalachia, none, etc)
OFFICE (Houston Office, SASG Shop, etc)
RIG
EMPLOYEE_COUNT
MAN_HOURS