Table Structure for Simple Database

[lwflip]

Hello, I'm trying to create a simple database to track our Daily Production Summary. I've never setup a database before some I'm looking for some advice on how to structure the Database tables. I'm basically trying to translate the following table into a database:

Date	4/7/2016
Time	Name	Lot	Good lbs	Scrap lbs	Comment
12-1	Product A	Lot 1	10,000	20	Startup Line
1-2					Clean
2-3	Product B	Lot 2	15,000	50	Startup Line
.
.
23-24			50,000	200

I was thinking of having a Production Table with the key being the Date then having all of the fields in the table above listed in the Production Table. The issue with this is the Production Table would have an absurd number of fields. In the case above, there would have to be a Name, Lot, Good lbs, Scrap lbs and Comment field for each hour (24x5=120). It doesn't seem like good practice to have a single table hold all data like this.

Could someone give me advice on how to structure this or point me in the right direction/towards some literature?

Thanks,

[orange]

Since you have admittedly told us that you have

never setup a database before

, I recommend you watch and work through a few tutorials to get some feel for the concepts involved.

Here are 3 videos that will help with concepts/overview of database and data structure.

Intro to Database Daniel Soper

The Relational Model

Data Model and ERD

Work through this tutorial to get familiar with the design process. You have to work through it --30-45 minutes, but you will learn, and what you learn can be used with any database.

Also, for Access, it is better to not have spaces in field names. Use only alphanumeric characters. It will save you syntax errors and frustration. There are a number of reserved words in Access that require "special syntax" --better to avoid it in my view.

Good luck.