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

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" <none@none.net> wrote in message
news:kGPtc.914$Vj.223@newsfe3-win.server.ntli.net...[color=blue]
> I hope someone can help i have a little understanding of Access and need[/color]
to[color=blue]
> 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[/color]
input[color=blue]
> this data for each employee( a total of 10 employees) keeping track of[/color]
their[color=blue]
> 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.[/color]
I[color=blue]
> am looking for pointers or websites.
>
> Any help greatly appreciated, thanks in advance
>
>[/color]

Thanks Larry,

I will look out for the books. Thanks for the advice.

Dave
"Larry Linson" <bouncer@localhost.not> wrote in message
news:J_Qtc.3049$g15.2941@nwrddc02.gnilink.net...[color=blue]
> 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[/color]
be[color=blue]
> 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[/color]
Out"[color=blue]
> by John Viescas from Microsoft Press. There are "Inside Out" editions for
> earlier versions of Access, also, published by Microsoft Press, but I[/color]
don't[color=blue]
> know if Viescas was the author of those. I can vouch for the quality of[/color]
the[color=blue]
> 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[/color]
relied[color=blue]
> 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" <none@none.net> wrote in message
> news:kGPtc.914$Vj.223@newsfe3-win.server.ntli.net...[color=green]
> > I hope someone can help i have a little understanding of Access and need[/color]
> to[color=green]
> > create a database that will allow me to keep track of employees work[/color][/color]
hours[color=blue][color=green]
> > on various processes involved in building machines. Each employee may[/color][/color]
be[color=blue][color=green]
> > involved in more than one process on more than one machine. I need to[/color]
> input[color=green]
> > this data for each employee( a total of 10 employees) keeping track of[/color]
> their[color=green]
> > 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[/color][/color]
sense.[color=blue]
> I[color=green]
> > am looking for pointers or websites.
> >
> > Any help greatly appreciated, thanks in advance
> >
> >[/color]
>
>[/color]