I need to handle information collected on an Acrobat questionnaire with results that downloaded to an Excel spreadsheet. The spreadsheet proved to be unwieldy; collating the information so that I can merge it to Word will be a much bigger job than I had anticipated. I have started to learn Access because it might be an easier way to handle the data. I want to know whether in fact Access is a better way to go. If it is, how I should approach it?
I am dealing with a niche market that is served by about 300 companies. I am creating a directory that will have, for each company, standard ID information plus information in about 8 categories. In a few categories, companies can choose only one of a handful of choices. In the other categories, each company can choose any or all of the possible choices. The smallest category has about 6 possible choices and the largest has 40.
At first I thought that each category would be a separate table, but the more I read (and watch learning videos) the more confused I get. I can see making a list of choices in a table, but I don’t understand how that would be related to the companies.