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:

graphic

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:

graphic

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:

graphic

·     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:

graphic

And finally the relationships diagram of the two tables:

graphic

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