Forum home » Delegate support and help forum » Microsoft Access Training and help » Training Administration Database
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Training Administration Database
Resolved · Medium Priority · Version 2003
Reply Tue 15 Jun 2010, 15:29Delegate Anthony said...
Anthony has attended:
Access Introduction course
Training Administration Database
Hi,
Newton Burgher delivered a very useful course for us yesterday and in it he mentioned a training admin tool he'd developed using Access 2003. Is there any chance I could see this?
For upcoming training course dates see: Pricing & availability
RE: Training Administration Database
Hi there Anthony
I need to catch up with Newson to see which database he is relating to. He is out training at the moment so it may not be till Monday that I can get back to you.
It is worth mentioning that we do have extensive experience in database creation and troubleshooting consultancy. Having a better understanding of what you are trying to achieve can give us the opportunity to recommend some options to you. If you are interested to have a conversation on this please contact me.
Kind regards
Jacob
Reply Mon 21 Jun 2010, 09:30Delegate Anthony said...
RE: Training Administration Database
Hello Jacob,
Thanks for getting back to me.
A colleague and myself are trying to produce a training administration database. At the moment we have only been able to get so far with Access.
What we need is something that can list:
*Employees and their individual details (i.e. department, d.o.b, gender etc)
*Training Courses and their details (i.e. Course name, number of days, course date, development area)
...and then we need to be able to produce attendance records for each course and also a "learning log" for each individual member of staff so that they can acess a list of what training they have attended/qualificaations they have received.
My guess is that we will need a table for Staff, a table for Courses and possibly a table for Attendance. Is that correct? The difficulty has come for us when we've tried to extract the required information from these tables. We found it difficult to establish how to Relate the fields and also how to produce tables with the necessary results.
I hope this is clear! If not, please let me know and I'll try again.
Any advice will be greatly appreciated.
Kind regards,
Anthony.
|