hours projection sheet/record of employee/employer performance

I would like to use access to make an hours projection sheet/record of employee/employer performance.

To do this I want the ability to type in the employee's number and the rest of their pertinent information will be filled in.

I would also like to keep a running total of employee hours that will reset to 0 upon reaching its threshold and award 'bonus' points

Is there any way to do a mass separation of first and last names?
Is it a good idea to arrange an employee database with first and last names in separate columns?

Thank you
5 more questions shortly

venusasaboy wrote:

I would like to use access to make an hours projection sheet/record of employee/employer performance.

To do this I want the ability to type in the employee's number and the rest of their pertinent information will be filled in.

I would also like to keep a running total of employee hours that will reset to 0 upon reaching its threshold and award 'bonus' points

Is there any way to do a mass separation of first and last names?
Is it a good idea to arrange an employee database with first and last names in separate columns?

Thank you
5 more questions shortly

To answer your last two questions, yes, it is a very good idea to have
first and last names in separate columns. This means, for example,
that you'll easily be able to use your Access table to generate a Word
MailMerge.

There are several ways of doing mass separations of a Name field into a
FirstName and a LastName. None of them are wholly satisfactory since
you almost always end up with people called J. Edgar Hoover, John Stuart
Mill or Sir Andrew Lloyd Webber, who don't fit the normal naming
conventions.

Forgive the assumption but I guess from the questions you're asking
you're not too familiar yet with writing code in Access, so you might be
interested in quite a nifty way of doing this by copying the data over
into Microsoft Word and splitting it up there. You can then import it
back into Access (the easiest way of doing this is to copy the Word
table over to Excel, save it, and then import it from Excel).

Details to be found at

http://word.mvps.org/FAQs/TblsFldsFm...meLastName.htm

(if you want I'll post some Access code to split your column up, but
this is a good quick and dirty method).

Steve