Project Description:
I have created an access data base about people from a certain industry. The database contains many tables, one of them deals with the work-experience of those people. The data that needs to go into that table comes mainly from the professional network XING (you need a premium account to see the data - costs for premium account will be covered by me if not available). The data needs to be copied into the access table containing the following information:
- name of person (comes from a related table which is the reference which names to search for)
- beginning of job
- end of job
- position in this job (position comes from another support table)
- company of the job (also from a support table)
- type of job (fulltime / part-time / intern - predefined values)
There are appr. 900 datasets with persons (reference point: existing table), each name has an average of 4 jobs.
The project has a high priority - I would need it done by Monday 11 July.
