Yes that is correct. I want to maintain and continue to generate EXCEL spreadsheets for each trainee. I want to ACCESS to leverage the population of EXCEL spreadsheets to run different displays that answer questions about the performance by task of the entire population, or subsets of the population. For example I want to be able to simply leverage these training records by name. That's easy. But maybe I want to see how all the trainees in sub-unit have performed on a certain task, or group of tasks. There are 115 training tasks, spread over 4 soldier rank levels broken down into 31 different areas. I'd like to be able to query performance level across the whole unit, or sub-units, by task or a group of tasks, for example First Aid.
Thanks Matt. let me work with this for a day and I will get back to you