Can this be done in Access

[Guest]

I need to create a small database that will track training for contract staff.
What I have is 5 depatments that have contract staff and 12 classes that
they may or may not need to take depending on they department they belong to
also some of the classes only need taken ever 3 years while the rest need to
be done every year.
If anyone can give me any ideas I would be very thankful.

 

[Guest]

What experience do you have in the following areas:
Database Design
VBA Programming
Microsoft Access
SQL

Without some experience in these areas, it would be more like doing it for
you. If you have absolutely no experience in these areas, I suggest you hire
a professional and get it done correctly.
If this is something you want to do as a learning experience, I suggest you
find a reference book on Access that makes sense to you, and work your way
through it.
An alternative would be to engage a professional on a consulting basis to
work with you and give advice and councel on achieving your goal.

Good Luck.

 

[Guest]

I have about 5 years of experience with access programming vba and database
design and have dabbled in sql. I have not done anything like this however
and just wanted to make sure that it was even possible or if I should use
something like foxpro.

 

[Guest]

Okay, then you can do it. Foxpro would be overkill for this situation.
Tables needed:
Staff - Info required for staff members - Pk STAFF_ID
Department - Info about departments - Pk DPT_ID
(mostly a lookup table to assign value in other tables)
Class - Info about available classes - Pk CLASS_ID
StaffClass - Join Table to resolve many to many betweend Staff and Class
tables
Pk - STAFF_CLASS_ID
Should include things like scheduled date, completed date, Grade, Interval
required, etc, etc.

That should get you started.