Dear Experts,
I have an excel survey form (attached) that I would like to import into Access and create forms for the users to review their information and at the same time enter the new data.
Challenging part: Top section is always complete where as in the PCR Instrument section; some time there will be one or two entries only but I want to show all of the 5 options in the form.
Similarly NA extraction section also has 7 lines for options but one or 2 lines are filled.
Should I create one big table or should I split the data into small tables? If 3 small tables what is the best key to link and the three sections. For on big table I used UnitId as unique key.
I have about 6 survey forms with different data elements, that I need to import into access DB and use access forms to edit and set up queries and reports in future. Any help is much appreciated.
Thank you