How to make quiz app more efficient

TiMark2000 · 03-21-2022 09:16 AM

Hi all,

I've created a quiz app. Currently I have 3 columns for each question. One to store the question, one for the user to enter an answer from a list and one which stores whether the answer is correct.

The first is just a type:show column which stores the question to display to the user and it the main issue as every record stores the same question and takes up a lot of unnecessary space. Is there another way I can show the question to the user but in a more storage efficient way? One solution I've found is to put the question as the column name for the answer field. However this leads to very long complicated formulas. The other option I can think of is to have a separate table to store the questions but I'm unsure how I can then display this to the user.

Thanks in advance, please let me know if you need me to explain further.

Joseph_Seddik

A Users table.
A Questions table.
An Answers table, with references to both Users and Questions table.
A menu view with a row called "Start Quiz", when clicked it would take you the Answers form, with the corresponding UserID and the ID of the first question.
Saving the form should take you the form of the next question.