Help Please

[joe90]

Hi

I am going to be attempting to create a simple database that will be used as a shift production log. I would like it to log all the 5 different machines output for each shift. The count on the machines will be inputted at the end of each shift and then a handover report printed off ready for the next shift. I would like the total for each machine from the last shift to be displayed on a form the next shift uses to input their figures, if that makes sense.

I was hoping someone could give me some basic advice on the best way to start my db. Table structures, queries and forms.

Kind regards

Hope someone can help.

Joe

 

[neileg]

The forum doesn't work that way. You can ask for help in specific areas, or you can give the design a bash and ask for opinions. Maybe you can do a search and see if anyone has done something similar.

Asking members to do a clean sheet database design, especially based on such limited information, is not going to get you anywhere.

 

[Rabbie]

Joe

Firstly for a little advice on how to get answers see this thread.

Secondly as Neil says, ask specific questions and you will probably get a helpful answer.

 

[georgedwilkinson]

But generally speaking, write out an explanation of what you plan to do, similar to your post above. Go through and underline/write down all the nouns on a piece of paper. Also write down any events that may occur over time. These become candidates for tables. Do a quick google on "normalization" and read it.

Then post back with your results.