If you are asking several questions and recording answers, then I would
expect each question to be a separate record.  Your form would then be a
continuous form that includes all the records.  This would have a scroll bar
to allow them to scroll from one to the next.

There are already many database templates out there for this purpose.  The
one I hear about the most was created by one of the MVPs and is called "at
your survey".

Sounds like you are adding a field for every question and answer.  In my
opinion, that will be an absolute nightmare.  What if a question changes?
What if you need to add one?  What if you need to remove one?  You don't
want to have to change the DESIGN to update the data.  Your users should be
able to go to a form and modify/add/delete the questions without having to
know how to build a database.  I would step back and totally rethink the
design.

This is my opinion, you may get some other responses.