Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I am in a quandry as to the best way of keeping history files for employees.
Any help would be appreciated. |
#2
![]() |
|||
|
|||
![]()
Hi Jan-
"History file" can mean a lot of different things. Although you could do this in a Word table, experience tells me you would be better off using Excel. It will provide you with much richer data management tools than Word. Depending on complexity of the data it might even be preferable to use a relational database like Access or FileMaker Pro if you are familiar with them. If you get started right, however, you can set up the initial file as a Word table then import it to Excel or a database file. But even if you don't work with Excel right now, it would be no just as easy (maybe easier) to set up the original data range in a worksheet. Just make sure that you put each usable data item in a separate table cell (or 'field'). For example, First Name & Last Name as 2 fields, not combined in one. The first row of the table should be the field names. Put each record on a separate row with no empty rows in between & no additional 'copies' of your field names. Regards |:) "Jan at air-flo mfg" wrote: I am in a quandry as to the best way of keeping history files for employees. Any help would be appreciated. |
#3
![]() |
|||
|
|||
![]()
Thanks for reply.
I am familiar with Access and would prefer to use it. The history I want to capture is absenteeism, job movement (dept to dept, etc), rate increases, etc. If you have any suggestions I'd most grateful. Thnx, Jan "CyberTaz" wrote: Hi Jan- "History file" can mean a lot of different things. Although you could do this in a Word table, experience tells me you would be better off using Excel. It will provide you with much richer data management tools than Word. Depending on complexity of the data it might even be preferable to use a relational database like Access or FileMaker Pro if you are familiar with them. If you get started right, however, you can set up the initial file as a Word table then import it to Excel or a database file. But even if you don't work with Excel right now, it would be no just as easy (maybe easier) to set up the original data range in a worksheet. Just make sure that you put each usable data item in a separate table cell (or 'field'). For example, First Name & Last Name as 2 fields, not combined in one. The first row of the table should be the field names. Put each record on a separate row with no empty rows in between & no additional 'copies' of your field names. Regards |:) "Jan at air-flo mfg" wrote: I am in a quandry as to the best way of keeping history files for employees. Any help would be appreciated. |
#4
![]() |
|||
|
|||
![]()
Glad what I could offer was appreciated, but I believe you'll get a more
qualified body of responses if you post in the Access NG. Good Luck |:) "Jan at air-flo mfg" wrote: Thanks for reply. I am familiar with Access and would prefer to use it. The history I want to capture is absenteeism, job movement (dept to dept, etc), rate increases, etc. If you have any suggestions I'd most grateful. Thnx, Jan "CyberTaz" wrote: Hi Jan- "History file" can mean a lot of different things. Although you could do this in a Word table, experience tells me you would be better off using Excel. It will provide you with much richer data management tools than Word. Depending on complexity of the data it might even be preferable to use a relational database like Access or FileMaker Pro if you are familiar with them. If you get started right, however, you can set up the initial file as a Word table then import it to Excel or a database file. But even if you don't work with Excel right now, it would be no just as easy (maybe easier) to set up the original data range in a worksheet. Just make sure that you put each usable data item in a separate table cell (or 'field'). For example, First Name & Last Name as 2 fields, not combined in one. The first row of the table should be the field names. Put each record on a separate row with no empty rows in between & no additional 'copies' of your field names. Regards |:) "Jan at air-flo mfg" wrote: I am in a quandry as to the best way of keeping history files for employees. Any help would be appreciated. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a macro that is a table in word | Tables | |||
Table headers/footers and layout | Page Layout | |||
How do I create a Table of Figures with both Figure captions and . | Microsoft Word Help | |||
How do you create a formula in a table where the result appears a. | Tables | |||
Table AutoFormats vs. Table Styles confusion | Tables |