The basic table for your application will identify the employee, the
machine, the start time and the end time (or, if recorded after the fact,
could be already converted manually to hours worked). In additon, you may
want separate tables with other information about the employees and the
machines -- but you will know if you need other information. This may not be
where, for example, you want to keep the employee's address and phone.
You will do your totalling, summarization, and grouping by machine or by
employee, most likely, in a report. It'll be a simple task.
For someone just starting, I often recommend "Microsoft Access
<versionnumber> Step by Step" from Microsoft Press. It is great for new
users and has an end user emphasis. Two books that also start at the
beginning but go deeper (and are a bit more expensive, too) are "Special
Edition - Using Microsoft Access <versionnumber>" by Roger Jennings
(published, I seem to recall, by Que) and "Microsoft Access 2003 Inside Out"
by John Viescas from Microsoft Press. There are "Inside Out" editions for
earlier versions of Access, also, published by Microsoft Press, but I don't
know if Viescas was the author of those. I can vouch for the quality of the
2003 edition, as I have a copy and have read/reviewed it. I have not
read/reviewed the latest edition of "Special Edition - Using..." but relied
on the Access 95 and 2000 editions as my intro to Access 95 and 2000 while
waiting on new computers that could run those respective versions.
Larry Linson
Microsoft Access MVP
Larry Linson
Microsoft Access MVP
"Dave" <no**@none.net> wrote in message
news:kG**************@newsfe3-win.server.ntli.net...
I hope someone can help i have a little understanding of Access and need
to create a database that will allow me to keep track of employees work hours
on various processes involved in building machines. Each employee may be
involved in more than one process on more than one machine. I need to
input this data for each employee( a total of 10 employees) keeping track of
their total hours on each process of the machine.
Also i need to add all these values to the total hours worked on each
machine from the accumulation of all employees. I hope this makes sense.
I am looking for pointers or websites.
Any help greatly appreciated, thanks in advance