Hello Anyone!
I am new to Access and am creating a database to store survey data. I have created many tables, each based on a specific portion of the survey, ie one for demographics, one for substance use, etc. Each table is connected via a unique participant ID#.
I am attempting to create a giant form that will mimic the order of the survey for ease of data entry after it is distributed. Many different people will be entering data and I want to ensure there are as few errors as possible.
My issue is that I can't seem to get the form to look right and I'm only trying with two tables at a time for now. The wizard crowds all of the questions onto one page. If I manually do it, I need to move one question over at a time and there is more room for error on my part.
Anyone have any suggestions?
I'm using Access 2010.
Thank you kindly!!
I am new to Access and am creating a database to store survey data. I have created many tables, each based on a specific portion of the survey, ie one for demographics, one for substance use, etc. Each table is connected via a unique participant ID#.
I am attempting to create a giant form that will mimic the order of the survey for ease of data entry after it is distributed. Many different people will be entering data and I want to ensure there are as few errors as possible.
My issue is that I can't seem to get the form to look right and I'm only trying with two tables at a time for now. The wizard crowds all of the questions onto one page. If I manually do it, I need to move one question over at a time and there is more room for error on my part.
Anyone have any suggestions?
I'm using Access 2010.
Thank you kindly!!