I have 3 HR personnel questionaires that potential employees fill out and would like to automate the process using a SQL database and Access forms. CPA questionaire has 131 questions, RT has 65, and ARP has 43 questions. I created four tables: employees, CPA, RT, ARP. The employees table has a primary key and the three other tables have foreign key linked to the employees table.
What I'm trying to do is design the three forms for each questionaire but I'm running into problems with how many questions will fit on each form. I am getting around 45 questions per form due to limited form length.
Is there a way around this problem? Any design suggestions would be very much appreciated.
What I'm trying to do is design the three forms for each questionaire but I'm running into problems with how many questions will fit on each form. I am getting around 45 questions per form due to limited form length.
Is there a way around this problem? Any design suggestions would be very much appreciated.
