create a MS access database based on a excel data file. There 187 columns and the ultimate goal is to have thousands of records.
1. To develop a proposal for a table structure and approach
2. Build the agreed set-up
3. Upload test data, review and improve where needed.
THIS JOB IS FOR MILESTONE 1 ONLY
Test Data and presentation with sample graphs and sample queries will be provided.
If you decide to apply please provide an example of database structure you have designed and implemented.
You have to understand how to relate data to each-other in a meaning full sense. Understanding basic statistics is needed and lots of values like means and standard deviations need to be calculated.
The data is from a customer service survey. With Free text, scaling (0 to 5) and yes/no answers in.