Selecting Access as the output type will result in the creation of 3 tables, as shown below. When saving the output in the OUTPUT section, you are prompted to enter the name of the Access database into which you want the output to be saved.
The default name is StudyName_QM.mdb
|
Trial |
TEXT(15) |
|
Site |
TEXT(8) |
|
Label |
TEXT(50) |
|
PersonId |
LONG INTEGER |
|
VisitCycle |
INTEGER |
|
FormCycle |
INTEGER |
|
RepeatNumber |
INTEGER |
|
One field per question in the form: ShortCode or VisitCode/FormCode/QuestionCode |
(Type dependent on type of question) TEXT (upto 255) - questions of type Text, Multimedia, Category and Partial Date DATE/TIME – questions of type Date LONG - questions of type Integer DOUBLE - questions of type Real and LabTest |
|
One field per question attribute in the form: ShortCode or VisitCode/FormCode/QuestionCode/Comments VisitCode/FormCode/QuestionCode/CTCGrade VisitCode/FormCode/QuestionCode/LabResult VisitCode/FormCode/QuestionCode/Status VisitCode/FormCode/QuestionCode/TimeStamp VisitCode/FormCode/QuestionCode/UserName VisitCode/FormCode/QuestionCode/ValueCode |
(Type dependent on attribute)
TEXT(255) TEXT(1) TEXT(1) TEXT(15) DATETIME TEXT(20) TEXT(15)
|
[Key=Trial,Site,PersonId,VisitCycle,FormCycle,RepeatNumber]
|
ShortCode (if ShortCodes are being used) |
TEXT(18) |
|
Visit/Form/Question |
TEXT(255) |
|
Description |
TEXT(255) |
|
Type |
TEXT(15) |
[Key=ShortCode or Visit/Form/Question]
|
ShortCode (if ShortCodes are being used) or Visit/Form/Question |
TEXT(18) or TEXT(255) |
|
CatCode |
TEXT(15) |
|
CatValue |
TEXT(255) |
[Key= ShortCode,CatCode or Visit/Form/Question,CatCode]