Sounds like a survey type database. The first part is that you need more tables with relationships that link them together properly.
See if this thread, created today, answers your questions: Need aid on generating a report from a survey layout.
Feel free to post follow up question to better understand how to do this.
(Please read the thread I've linked this post to before reading further...)
As far as layout design goes, you could set up a portal of questions and answers by using the Reponses table for the portal. You can also set up a list view layout based on responses for collecting the Respondant's answers to your questions.
Thank you for such a quick response! It looks like my relationships were actually OK. Where i hit a snag was that I had no idea I would need a script to generate some sort of initial response to each question to get them to show up. I thought there might be a relationship or a join that would do this somehow. Looks like I need to learn the script language.