The various forms that are used for gathering information ranging from Market Research to Clinical trials are designed as Microsoft Word Templates using VBA Forms and macros, with all necessary validations and calculations. The information gathered from the respondent is entered directly into these templates and saved as a document file, one each for every respondent.
A separate VB Macro is provided to populate all the information from the various word documents and store them in a database. This not only saves a lot of time and money but also enables to process the findings quickly. |