Training Record DB

I have 51 Security Employees who take various courses throughout the year
and participate in various security drills as well. I want to keep track of
these individuals and the courses (training) they have taken and in the
drills they participated.

As this type of tracking system is so aptly applied to students, rather than
recreating the wheel, I am asking if anyone knows of a sample
"Student/Course" database that I can review and modify. The main reason I
am asking is that I realize that there are going to be some "one to many"
relationships in the employees to courses/drills, so I want to be sure I do
this correctly.

Thx...
Earl Anderson

Re: Training Record DB

On Sun, 13 Jan 2008 13:31:16 -0500, "Earl Anderson"
wrote:

Did you check the template databases available on microsoft.com? File
> New may get you there as well (depending on your version).

Great abstract thinking to consider a Student DB. Too many people are
thrown off by minor conceptual differences and feel the need to
reinvent the wheel.

-Tom.


>I have 51 Security Employees who take various courses throughout the year
>and participate in various security drills as well. I want to keep track of
>these individuals and the courses (training) they have taken and in the
>drills they participated.
>
>As this type of tracking system is so aptly applied to students, rather than
>recreating the wheel, I am asking if anyone knows of a sample
>"Student/Course" database that I can review and modify. The main reason I
>am asking is that I realize that there are going to be some "one to many"
>relationships in the employees to courses/drills, so I want to be sure I do
>this correctly.
>
>Thx...
>Earl Anderson
>

Re: Training Record DB

Thanks Tom,

For benefit of others, a template was in A97 at File-->New-->Databases.

Earl


"Tom van Stiphout" wrote in message
news:9iqko3dua0id6c1hdgfv2mropd6nr81h78@4ax.com...
> On Sun, 13 Jan 2008 13:31:16 -0500, "Earl Anderson"
> wrote:
>
> Did you check the template databases available on microsoft.com? File
>> New may get you there as well (depending on your version).
>
> Great abstract thinking to consider a Student DB. Too many people are
> thrown off by minor conceptual differences and feel the need to
> reinvent the wheel.
>
> -Tom.
>
>
>>I have 51 Security Employees who take various courses throughout the year
>>and participate in various security drills as well. I want to keep track
>>of
>>these individuals and the courses (training) they have taken and in the
>>drills they participated.
>>
>>As this type of tracking system is so aptly applied to students, rather
>>than
>>recreating the wheel, I am asking if anyone knows of a sample
>>"Student/Course" database that I can review and modify. The main reason I
>>am asking is that I realize that there are going to be some "one to many"
>>relationships in the employees to courses/drills, so I want to be sure I
>>do
>>this correctly.
>>
>>Thx...
>>Earl Anderson
>>