By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,326 Members | 1,938 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,326 IT Pros & Developers. It's quick & easy.

newby help needed

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
Thanks Larry,

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

Dave
"Larry Linson" <bo*****@localhost.not> wrote in message
news:J_*****************@nwrddc02.gnilink.net...
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


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.