0. Introduction (6:16)
1. Creating Surveys (34:23)
Create Survey Using Google Forms
Import into Microsoft Access
2. Import Using Excel (19:51)
Connect to Sheets from Excel
Use Access VBA to Update
Link Directly to Excel File
3. Download CSV (19:49)
Download CSV Direct to Access
Goodies from the Code Vault!
4. Import Data 1 (27:03)
Make Survey Data Relational
Create SurveyT
Create SurveyHelperT
Create ListT
GetHelperDataID Function
Look Up Helper Data
Add to Table if Not Found
Clear All Data Button
5. Import Data 2 (33:05)
Parse Multiples Function
Break Down Comma Separated List
Add Each Item to Helper Data
Add Question to Survey
Modify Linked Table Import Specs
Import Specifications
6. Querying Data (24:54)
Check for Duplicate Survey Respondants
Respondants with Helper Data
Respondants who are Not Customers
Surveys with Multiple Selections
DLookupPlus Function for a List
Popular Multiple Selection List
Customers with No Survey Response
7. Survey Forms 1 (35:40)
Customer Survey Form
Show Survey Responses Button
Disable Button if No Survey Response
Multiple Selection Subform w Responses
Survey List Form
Open Survey or Customer from List Form
8. Survey Respondant List (36:25)
Form With Three Listboxes
Write SQL RowSource Based on Previous Box
Show all Questions
Show all Responses to Selected Question
Show all People with Selected Response
9. Survey Report (9:10)
Survey With Multiple Responses
Sorting & Grouping Levels