How to Setup a Survey Database with Option Boxes

(Applicable to all versions Access)

Here are some screen shots that I captured whilst working out how to setup a database for collection of a survey. The technical solution here is how to setup an option box data entry system to match the original survey.

Original Survey

Questions table

How to use the lookup wizard for the question table

Options Box Time

Copy the data in the Questions lookup table before adding the Option box

Now use the Options box

Here is the UI

Copying Option Boxes for Other Questions

Thats it :)

Garry Robinson

Published 2008-07

Our Tools and Resources

RSS & Newsletter Here
Join our newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
The Workbench
Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, creation versions, shutdown database
Read about the Toolbox
Sample downloads, library resource kit and searchable help file comprising most of the information at vb123.com.au plus hidden downloads etc.
Convert Access to SQL Server
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query translation and web form conversion.
Datamining & Graphs in Access
Find out more.
Expression/SharePoint Web Conversions
Its a good way to improve your website

Purchase the Popular FMS Products
If you purchase the Popular FMS products from us, you will receive complimentary copies of our software

vb123 Professionals

Get Good Help Here

If you need help with a database or Office programming, our Professionals could be the answer because we have worked on many similar solutions

Frontpage Conversions
We have converted vb123.com to Expression Web, contact us if we can help you move to the latest Microsoft web tool.

About The Editor ~ Contact Us
Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia

Upsize Access to SQL Server

The Access tool that we use to upsize Access databases to SQL Server is called MUST. It not only sorts out most of the problems that stop the Access upsizer but it makes building more effective Access to SQL solutions easier.

Read More here