S
Shell E
USING: Word 2003 & Access 2003
GOAL: I will be sending a Word Form to over 100 external employees for them
to enter Resume Data ( for e.g. Personal Data, Professional Experience,
Education, Certifications, and Skills (basically Resume Data). Please note
the different objects/tables.
GIVENS: I want to limit manual labor. Employees don't all have MS Access.
Employees don't have access to web because they typically lose secure id
card/fob.
I found an artilce
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnimo01/html/imo1200.asp)
on how to do this this via Access VBA when all the data is loaded into one
table. But, I have designed the database to have 1 to many relationships
between the objects (Skills, Professional Experience, Education,
Certifications).
QUESTION: Should I load all the Word Form data into one flat table and
somehow transform the flat record into the relational tables?
Or should I use Access VBA to load Word Form data directly into relational
tables?
Is there a better approach to acheiving my goal?
Thanks
GOAL: I will be sending a Word Form to over 100 external employees for them
to enter Resume Data ( for e.g. Personal Data, Professional Experience,
Education, Certifications, and Skills (basically Resume Data). Please note
the different objects/tables.
GIVENS: I want to limit manual labor. Employees don't all have MS Access.
Employees don't have access to web because they typically lose secure id
card/fob.
I found an artilce
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnimo01/html/imo1200.asp)
on how to do this this via Access VBA when all the data is loaded into one
table. But, I have designed the database to have 1 to many relationships
between the objects (Skills, Professional Experience, Education,
Certifications).
QUESTION: Should I load all the Word Form data into one flat table and
somehow transform the flat record into the relational tables?
Or should I use Access VBA to load Word Form data directly into relational
tables?
Is there a better approach to acheiving my goal?
Thanks