Sorry if this has been posted before, but I'm in a bit of a dilemma of sorts. Also, if this sounds rather unclear, let me know, and I'll explain things further with a few photos.
Before I begin, I came across this thread, mentioned at http://www.daniweb.com/forums/thread105907.html
...this had something to do with building up a database to store exam questions and their results.
As a novice that's a bit rusty, my needs are a little more trickier.
The short of it is that I need to build a database that can be used to create examination result transcripts.
The longer part? What I've got to work with.
As of right now, the sample examination result data that I have obtained is in Excel, and only applies to multiple-choice objective questions (not essay ones, as of yet). The first important rows indicate the number of questions, while the first important columns indicate the number of trainees that took the exam. The core of the data contains the trainees' responses to the questions in that exam, and, several rows later, the final outcome of the trainees' efforts (Pass / Fail).
Unfortunately, the columns in the file simply contain numbers, not trainee IDs, so it's difficult to identify which trainee obtained what result (pass/fail), but that's not really the main issue.
The main issue's the fact that I need to transfer the final result to the Access database I'm making. There's 248 trainees in this training facility, broken down by intake, and by the category that they're from. Currently, there are 3 categories, each containing 12-13 modules. These are known as Cat A, Cat B1, and Cat B2. Additionally, there are currently 10 intakes; 6 of these fall under Cat A, while the remaining ones fall in Cat B1 and Cat B2 evenly.
Most of the modules in each of these categories are the same, with the exception of a few category-specific ones. But to manually enter the result data into the Access database may not only cost time, but may also introduce the possibility of getting the results wrong. Think about it: 248 trainees X 12-13 modules = about 3,000 entries to key in.
Plus, there's the question on how I can make a table that relates to the exam results per module, and per category.
The good news is that this database is staying offline for now, but I don't know how far the management wants to take this.
If this is still unclear, I'll be glad to include a photo of how things look like at this stage. I'm just thinking if there's a much cleaner and faster path than manual data entry. And if programming in VBA's the only option, then tell me what I need to do to get things set up right. Also, on a related note, move this post to the right location if I've posted it in the wrong place.