How to Build a Data-Driven Questionnaire & Survey Database in Microsoft Access

In this episode, we discuss how to create a data-driven survey or questionnaire system in Microsoft Access, where all survey questions and answers are stored in tables rather than being hard-coded into forms or reports. I explain the database structure, including tables for surveys, questions, sessions, and answers, and show step-by-step how to set up these tables and link them. We walk through building the necessary queries and forms to collect responses, and I demonstrate how to use a small amount of VBA code and SQL to streamline adding survey questions to answer tables. Data validation and advanced options are mentioned as topics for the extended members-only section.