Convert Access 20313 DB to SQL to work on Wordpress site - repost

Closed

- Access 2013

- Wordpress

- PHP

- HTML, CSS

- SQL

-Multi-page form design linking to SQL inputs

Job Description:

I have an Access 2013 database quiz / test which now needs to be converted to work on our website, which is self-hosted on the wordpress platform. The purpose of the quiz is for someone to get asked 5 questions in a row, and to provide as many examples of different responses as they can.

The database is set up as follows:

1. A table ("People") and form containing input of a person's details (name, email, age, gender, country etc), and a selection of which quiz (out of 5 different quizes) they would like to take

2. Another table ("Tests") lists out the 5 quizzes, which consist of 5 questions each, and each question will be on a separate webpage. The only thing which is different between the quizzes is the word or image location that the person needs to look at and provide answers for

3. There are then 5 other tables ("Ideas Question 1", "Ideas Question 2" etc), where the answer inputs are stored for each question for that person. They need to be able to input as many answers as they want, and each answer needs to be a separate entry in the database

4. Each time the person clicks the "Next page" button, the database should also store the current date and time, so I can calculate how long they spent doing each question.

5. I then need to be able to download the database entries to analyse them, and see the details of the person who did the test, and all of the separate answers they gave to their questions. I need to be able to count the total number of answers they gave, and then also see whether there were any duplicates etc. I will be doing this analysis in Access 2013 or Excel.

The forms then need to be embeddable into new wordpress pages I create.

Skills: Microsoft Access, MySQL, PHP

See more: where to work, sql get duplicates, sql get date, people doing work, microsoft wordpress design, microsoft access job, how to work at, how to create webpage, how to create forms in php, how to create a webpage, how to create a new website on wordpress, how to convert a website to wordpress, how to calculate css, create php website for quizzes, convert image to html email, convert excel to website, convert excel to html form, access db forms, work on, work ideas, sql microsoft access, microsoft excel test, microsoft at work, microsoft access test, microsoft access sql

Project ID: #4632641

10 freelancers are bidding on average £9/hour for this job

ValueCoders

Hi, Experts team of Wordpress/PHP/cakephp/joomla/Drupal/SEO/AJAX/Codeigniter developers and designers. Thanks Gaurav

£10 GBP / hour
(102 Reviews)
6.7
jsinfoway

Hi, Have Gone through your details. We have left a PMB for you plz have a look over there. Thnx Jay Jswebtech Team

£5 GBP / hour
(67 Reviews)
6.5
webzin

Thank you for taking time to review our bid. We are certain that we will provide the full suite of integrated solutions required by your company.We have reviewed the project requirements, the requirements match our ski More

£15 GBP / hour
(51 Reviews)
6.1
bhavinhjoshi

Hello, I have provided the details in private message. Please check PM. Regards.

£10 GBP / hour
(36 Reviews)
5.8
extreamcode

HI, Expert here.

£10 GBP / hour
(6 Reviews)
4.9
hopebd

Greetings, Clear Project, Ready to start.

£5 GBP / hour
(16 Reviews)
4.4
evidcomm

Please read PMS for more detail..many thanks..

£8 GBP / hour
(15 Reviews)
4.3
vickkey7

I am ready to start this project...

£8 GBP / hour
(4 Reviews)
3.2
krutikjayswal

i can do this

£10 GBP / hour
(0 Reviews)
0.0
nabihabatool

yes like to..

£8 GBP / hour
(0 Reviews)
0.0
lotfilist

I'm ready to start work..

£8 GBP / hour
(0 Reviews)
0.0