Importing questions from Access (old schema QF 2.x)
In order to import questions written directly into Microsoft Access with the old
QuizFaber 2.x database schema, select the item "Import quiz" from File Menu
and
then select the item "from Microsoft Access (MDB) - QF 2.x", as shown in the
figure below:
A dialog window will ask you the name of MDB Access file to open. After then, a new
window dialog will appear, as shown in the figure below:
You have to choose if import from database all the questions into your opened quiz
or import only the selected questions.
Create an Access database with QuizFaber 2.x database schema
· Open "Microsoft Access".
· Create a new empty database.
· Choose a file name for the database, for example "quiz.mdb".
· Create a new table and switch into Design View.
· Add the following columns, in the following order, with the correct data
type and keep the difference between uppercase and lowercase:
Name Data Type
Size Required
------------+---------------------+----------------+----------
id_domanda Number (long integer)
primary key
tipo Number (integer)
peso Number (integer)
domanda Text
255 Yes
selezione Yes/No
· Define the column "id_domanda" as primary key.
· Assign to the new table the name "Domande" (with the first letter
uppercase).
Here the Design View of "Domande" table:
· Create a second new table, and switch into Design View.
· Add the following columns, in the following order, with the correct data
type and keep the difference between uppercase and lowercase:
Name Data Type
Size Required
------------+----------------------+----------------+----------
id_domanda Number (long integer)
Primary key
risposta Text
255 Yes
corretta Yes/No
id_risposta Number (integer)
Primary key
· Assign to the new table the name "Risposte" (with the first letter
uppercase).
· Define the columns "id_domanda" and "id_risposta" as primary key.
In order to create a primary key made by two columns, select both the fields, right
click and, from the pop up menu, select the item "Primary Key".
Here the Design View of "Risposte" table:
And finally the relationships diagram of the two tables:
Insert questions into Access database
Open the "Domanda" table or "Risposte" table into normal view in order to add
questions and answers.
The "id_domanda" - the question identifier - is a number that starts from 1.
The answers to a question has the same question identifier ("id_domanda"), but
each one has a different "id_risposta" - the answer identifier - that is a number that
starts from 1.
Some columns admit only a specific set of values:
"Domande" table, "tipo" column, use one of following values:
1 : multiple answer
2 : true or false question
3 : question with open answer
4 : fill gap exercise
5 : matching
"Domande" table, "selezione" column, use one of following values:
YES : the question will be imported into QuizFaber
NO : the question will not be imported into QuizFaber
"Risposte" table, "corretta" column, use one of following values:
YES : correct answer
NO : wrong answer