Hi Folks
I have been asked to design a new DB for our training department but I believe it may beyond my ability, i just cant see a way to do it.
I designed the old but but it had alot of mistakes as I was only beginning to use Access then, ie personal details had to be entered for each course, and other stupid things like that.
This time my idea would be to:
Only enter personal details once
Students may attend for multiple years (Sept 1st - Aug 31st)
Students may take many course per year
Import data from Awarding Bodies online interchanges
Export data to meet new requirements online of some courses
Track course prerequisites and course credits
Implement login process and Audit trail.
Produce a series of reports based on all this etc.
Problem I am having after this is each course has it's own set of requirements in regards to what information we have to record for audit purposes, different units, different exam codes etc.
So I am thinking each course will need it's separate tables, and this is where I am stumped. I just ain't sure how to link all these together, are there any good student sample databases I could look at?
Any advice/help would be greatly appreciated.
Many Thanks all
Gary
I have been asked to design a new DB for our training department but I believe it may beyond my ability, i just cant see a way to do it.
I designed the old but but it had alot of mistakes as I was only beginning to use Access then, ie personal details had to be entered for each course, and other stupid things like that.
This time my idea would be to:
Only enter personal details once
Students may attend for multiple years (Sept 1st - Aug 31st)
Students may take many course per year
Import data from Awarding Bodies online interchanges
Export data to meet new requirements online of some courses
Track course prerequisites and course credits
Implement login process and Audit trail.
Produce a series of reports based on all this etc.
Problem I am having after this is each course has it's own set of requirements in regards to what information we have to record for audit purposes, different units, different exam codes etc.
So I am thinking each course will need it's separate tables, and this is where I am stumped. I just ain't sure how to link all these together, are there any good student sample databases I could look at?
Any advice/help would be greatly appreciated.
Many Thanks all
Gary