Using MS Access/CSAT survey application

Advertisement


Question
Hi Scott,
I have inherited a Customer Satisfaction Survey application that uses Access 2007 for the db and plain vanilla ASP for a web form. The table design is horrid (Name, Dept, Q1..Q12, Remarks as all text fields). The ASP page is where the questions and possible answers (radio buttons for Very Dissatisfied...Very Satisfied) are defined. I think it is pointless to modify this.

I'd like to build a new application. I'm a bit confused about the table design (its been years that I worked on FoxPro/Access and table normalization).

Could I bother you to get me started off with a table design? IMHO, there should be one Questions master, one Answers master, one table to capture the user's feedback (User, date-time, and Question ID and Answer ID).

Also, can I create a form in Access that I can host on an IIS webserver instead of creating an ASP.Net project or a quick-n-dirty ASP page?

Answer
You have the general structure correct. Though, I use 4 tables.

tblQuestion
QuestionID (PK Autonumber)
Question

tblRespondent
RespondentID (PK Auonumber)
FirstName
Lastname
etc.

tblResponse
ResponseID (PK Autonumber)
RespondentID (FK)
ResponseDate

tblAnswer
AnswerID (PK Autonumber)
ResponseID (FK)
QuestionID (FK)
Answer

You can combine tblResponse and tblRespondent if you only get one survey response from a person.

With Access 2013, its becomes a lot easier to create an host WEB based databases. With earlier version, it much harder, though, if you have access to a Sharepoint server, its not too bad with 2010.


Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA  

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience

I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Organizations
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Education/Credentials
Brooklyn College BA

©2016 About.com. All rights reserved.