Using MS Access/CSAT survey application
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?
You have the general structure correct. Though, I use 4 tables.
QuestionID (PK Autonumber)
RespondentID (PK Auonumber)
ResponseID (PK Autonumber)
AnswerID (PK Autonumber)
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,
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA