Daily Log Database??

[brittle]

I am constructing a database for my manufacturing company. Basically, I have a physical paper that employees fill out for each machine that has all of the hours in a day and next to each hour, they log who they are (Employee Name), the goal for production for that hour (Goal), and the actual number of a product that was made for that hour (Actual). There are 4 different machines that made a number of different parts.

I'm not sure how to make a database that will basically function like Excel does and be able to have an employee see all the hours in a day and enter data.

Any ideas will be much appreciated.

Below is the information that I need for each entry:

Date/Machine/Part Being Made

Time: (This will be the same for every entry) 7-8, 8-9, 9-10, etc.
Goal:
Actual:
Employee:


Notes:

At the end of the day there needs to be a count of good parts (to sell) and bad parts (to toss).

Any ideas?!?!

[brittle]

I am trying to create a form that employees will fill out, but I want it to have the same time frame set up for each record and I cannot for the life of me figure out how to do that.

After the employee enters the date, the machine and the part, I would like it to come up with a spreadsheet-like form that looks like this:

Time	Goal	Actual	Employee	Notes
6-7
7-8
8-9
9-10
10-11
11-12
12-1
1-2

[June7]

If you want to use bound form that means creating records and displaying those established records on form for user to complete data entry into. Creating the records can be accomplished with VBA code that executes INSERT sql action. Fairly common topic, search forum. Start with:
https://www.accessforums.net/forms/e...orm-37306.html