Where can I find a good example of a Survey database?

Hello Experts its me again. I have become very frustrated and dont know what I should do. First I like to tell you that I am not a expert on Access and most everything I have learned was because of you the experts. I want to thank you for that.

For those who dont know I have a database that was not made correctly now my boss is asking me to remake the database finally after over a year. The new database is basically a Inspection database that goes through over 200 hundred questions.


I have always done forms in a single format. Not a continous format. So alot of things that I was used to doing you have to do a different way. I have analyzed the survey example called "At Your Survey". This database is not helping me because it is setup to make a Questionaire database for you.
I have read articles for continuous forms but it really doesnt go in to detail about how to different things with a continuous form


If anybody knows of a better example please let me know.

The Issues I am running into are
1. How to make different information in a dropdown based on different questions on a form?
2. If you have over 200 question is it wise to make a second column to show up on the form to even it out?
3. Where do you put calculations to enter numbers and it calculates a Min and Max on the continuous form?
4. Should general information like Name and engine serial numbers be in a separate table?
ContinuousLookup.accdb
gigifarrowAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeCommented:
"At Your Survey"  is a full featured survey database written in Access.

http://www.rogersaccesslibrary.com/forum/topic3.html
0
Jeffrey CoachmanMIS LiasonCommented:
First, and before anything else, you need to make sure that the basic table design, keys and relationships are Optimized for what you are trying to do.

I see some things that concern me:
1. No Primary key in tblFS3ResponseList
2. No permanent relationships established between the tables
3. Field names like "QuestionID#", (that includes a special characters) will forever give you headaches (why not just leave it as: QuestionID)
4. Fields with data that contain "slashes" (Go / No-Go / N/A) are always a flag that this data is un-normalized.
5. Not sure why you need the numbering bullet (with the parenthesis)
    example: "3) TOW Missile Launcher & Component Removal:"
again, just throws up red flags that something may be "off" in the design.

So my suggestion might be to first post a question describing exactly what this system needs to track and what it needs to do.
...then ask for advice on the basic design...

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gigifarrowAuthor Commented:
Thank you jeff always good advice.  I have over 200 questions and I need a question format design. The two tables are  related with the QuesitonID. I will make those changes to the names.

tblquestions
QuestionId
Questions

tblResponseList
QuestionID
Answers
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I agree with Jeff. You first need to define exactly what your database is intended to accomplish. When writing up something like this, think of it as a sort of sales pitch to a client (i.e someone who has no knowledge of what a Form is, or a Primary Key). In plain language, tell us what your database is intended to accomplish. It shouldn't be more than a few short paragraphs, and there should be NO technical language involved, no discussion of logic flow, etc etc.

After you'd done that, we can help further with the beginnings of table design.
0
Jeffrey CoachmanMIS LiasonCommented:
Without know all the details and requirements, it is difficult to answer questions like this...
Remember that "design work" is what a lot of us get paid to do, ...so while there may be an expert willing to help,, ...you still will have to do most of the footwork and research on your own.

Designing a "basic" survey database is simple, I see something like this:

tblQuestions
qID (PK)
qText
...

tblRespondents
rID (pk)
rFN
rLN
...

tblRespAnswer
raID (pk)
raDate
ra_qID (fk)
ra_rID (fk)
raAnswer

But here again, this is VERY basic.
(For example it is not known if a respondents can select from predefined answers or not)


So follow what LSM posted then get back to us...
0
gigifarrowAuthor Commented:
Thank you for all your advice. I have a format now. I think I have a good Normalization of my tables with a good naming convention.


I have had to deal with bad databases structures for a long time. Now that I am able to redo the database I know it is very important to start out with good table structure.

 I have learned that the most important is your table setup. With out a good foundation it makes your job so hard when  trying to make changes based on the customers request.
0
Jeffrey CoachmanMIS LiasonCommented:
Again, do not take what I posted as Gospel...
It was just a very rough outline...

As LSM stated, you really have to dig deeply into the requirements of this system with whoever is in charge of it.

My guess is that your final design will bear very little resemblance to what I posted...


JeffCoachman
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.