Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Seminars > Survey Seminar >
Access Survey Seminar

Surveys in Google Forms. Collect, Analyze in Access.


 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now

Welcome

Welcome to the Microsoft Access Survey Seminar. This seminar is 4 hours, 6 minutes long.

You will learn how to build surveys & questionnaires in Google Forms for anyone to fill out. You will then see how to collect the responses using Microsoft Excel and directly into Microsoft Access. We will then build lots of queries, forms, and reports to analyze and summarize that data. 

Resources

Seminar Goals

  • Create Surveys in Google Forms
  • Connect w Excel
  • Direct Download CSV to Access
  • Import to Access
  • Parse Multiple Responses
  • Tons of Queries
  • Respondent Form
  • Response Form
  • Grouping Report
  • More!!!

Topics Covered

In Lesson 1 we will learn how to create surveys and questionnaires in Google Forms. We will learn how to import the response data into Access.

In Lesson 2 we will learn how to connect to Google Sheets from Excel. Then we will use a little VBA Automation to make Access tell Excel to update the data in the background, which we can then get into Access via a linked table.

In Lesson 3 we will skip Excel entirely and learn how to download a CSV text file from the web automatically with Access and a single click. Goodies from the Code Vault

In Lesson 4 we will create tables to import the data from the CSV file directly into Access instead of using a linked table. We'll create helper data tables to store all of the different types of survey responses. 

In Lesson 5 we will learn how to import the multiple-item responses into a related helper data table. This way a response such as "queries, forms, reports" will be split up into 3 properly relational records. 

In Lesson 6 we will make a whole bunch of different queries to analyze the response data: are there any duplicate respondents, are there non-customer responses, show the surveys with all the helper data, what are the popular responses, and lots more.

In Lesson 7 we will build a survey form to show all of the results along with the helper data info, and a subform to show the multiple response answers. We will be able to link the surveys to existing customers. On the survey list form we can open the survey response form or the customer form. We can open the survey data directly from the customer form. 

In Lesson 8 we will go in the opposite direction. Whereas in Lesson 7 we wanted to see the response data from a specific customer, in Lesson 8 we want to pick a specific survey response and then see all of the customers who responded with that answer. This would be handy to show, for example, "which customers said they wanted to refinance their mortgage within the next 5 years."

Finally, in Lesson 9 we will do some reporting. We'll see how to create a report with sorting and grouping levels to display each survey response with the multiple-answer questions and their responses grouped.

Pre-Requisites

This is a Developer-Level Seminar. There will be a lot of VBA and SQL. It is strongly recommended that you have completed my entire Access Beginner and Expert series. My Developer 1 class is highly recommended so you understand the basics of programming in VBA. If not, at least watch my free Intro to VBA video. Developer 16 is recommended if you want to learn about Recordsets. I strongly recommend these lessons before you watch this Seminar. I also recommend my Access SQL Seminars which will teach you how to work with the SQL language. 

Version

I am using Microsoft 365, roughly the equivalent of Access 2016 or 2019. Everything in this seminar should work with every version of Access back to 2007.

Notes

Please note that this seminar is NOT downloadable. You must watch it online.

Enroll Today

Enroll now so that you can watch these lessons, learn with us, post questions, and more.

Questions?

Please feel free to post your questions or comments below. If you are not sure as to whether or not this product will meet your needs, I'd rather help you before you buy it. Remember, all sales are final. Thank you.

Keywords

Surveys, Questionnaires, Polls, Quizes, Multiple Choice, Header Image, Duplicate, Required, Delete, Sections, Shuffle Option Order, Short Answer, Paragraph, Allow Other, Dropdown, Linear Scale, Add Picture, Add Video, Get Link, Shorten Link, Import to Access, Link to Excel File as Table, Publish to Web, Get & Transform Data, From Web, Enable Background Refresh, Excel.Application, File Download from Web, vba automation, google sheets

 

Comments for Access Survey Seminar
 
Age Subject From
3 yearsCompany ChecklistLhora Talon

 

Start a NEW Conversation
 
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
 
Subscribe
Subscribe to Access Survey Seminar
Get notifications when this page is updated
 
 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 9:35:51 AM. PLT: 0s
Keywords: access seminar Surveys, Questionnaires, Polls, Quizes, Multiple Choice, Header Image, Duplicate, Required, Delete, Sections, Shuffle Option Order, Short Answer, Paragraph, Allow Other, Dropdown, Linear Scale, Add Picture, Add Video, Get Link, Shorten Link  Page Tag: whatsnew  PermaLink  Microsoft Access Survey Seminar