Create a new table with fields from another table

[Hennie]

Hi,

I have a table with a field "Question". I want to use this table to create
anothertable "Survey" and the fields in the new table must be the questions
in the "Questions" table. Then I want to create a form from the "Survey"
table and give scores to the questions.

I don't know how to set it up that I can use the questions as fields in the
new table.

Can you please give advice?

Thanks

 

[Allen Browne]

You can duplicate a table by selecting it in the Database Window (Navigation
Pane in A2007.).

Then Copy (Ctrl+C) and Paste (Ctrl+V.)
Access will ask for the new table name, and whether you want to copy the
table structure only, or duplicate the data also in the new table.

Before you to that though, having a field for each question is not the right
way to design a survey. If you are interested in a normalized example, see
Duane Hookom's At Your Survey sample database here:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

 

[Hennie]

Hi,

Thanks for that. I didn't make my question very clear. I meant that the
answers in the first table should become the fields in the second table.
Should questions in the future change, I want to accomodate these into the
database without having to re-design the database.
I have looked at the link and realise that I need to look at it from a
different perspective.

Thanks Allen