program | Online I named the database Onlinetest.mdb. The number of tables in the database depends on the subject or number of accounts. Now we have a total of 5 forms:
Loginuser
Paper
Details
Tblhtml
Tbldhtml
LOGINUSER table Structure
Field Name Data type description
Id Auto Number PRIMARY key
Username Text member name
UserEmail Text member's e-mail address
Password for Password Text member
Details table Structure
Field Name Data type description
Id Auto Number PRIMARY key
REF_ID The reference ID number of the Text member
Subject Text member Selection theme
Score Text member score result
Paper table structure
Field Name Data type description
Id Auto Number PRIMARY key
Topic Text online Quiz to cover part/Topic list
Tbl_name Text contains the relevant table names for the specified topic
tblhtml table Structure
Field Name Data type description
Id Auto Number PRIMARY key
Question Text to display the topic
Choice1 Text for the choice of answers
Choice2 Text for the choice of answers
Choice3 Text for the choice of answers
Choice4 Text for the choice of answers
Answer Text Correct answer
Similarly, tbldhtml is defined in the same way as tblhtml.
I created a separate table for each account, in this case one is HTML and the other is DHTML. It is also easy to add new tables or extend existing ones.