I have just started a new position--anyone have a template for tracking basic training? I just need to see what columns you have set up and how it works. We are going over the 50 person mark and will implement some kind of HR S/W in 6 mos or so, but I need something to tide me over...

Thanks in advance!

Trust me -- this is not a mere spreadsheet. It is a relational database (use Access - it's easy). Even at the bare minimum - if you're only tracking the day, the class, attendees and who taught it. There's no way to track that correctly in a spreadsheet.

If you tell me more about what data you need and the kinds of reports you need, I will post a basic database map for you of which tables you'll need, the primary keys and the relationships between them.

I just got Acess installed. I have real basic requirements:
Course title
Name of attendee
date
Instructor
Possibly evals & results
potentially track against a curriculum map or training tracks when we get fancy. I mostly want to be sure that whoever falls through the cracks on a presentation deliver gets to attend a make up class. We will be getting some sort of HR program in here in the next 6 mos or so and I will lobby for functionality in that. being able to export this info will be handy at that point in time.

Thanks from Boston

Here is a possible database solution for you. Fairly well normalized, at least through NF3. The payoff is that I now have another good scenario for when I teach database design. Thanks!

tblCourseTitles
courseTitleID (primary key – use your unique IDs or use autonumber)
courseTitle

tblInstructor
instructorID (primary key – use the instructor’s employee ID number)
insFirstName
insLastName

tblSchedule
scheduleID (primary key – use a code that uniquely identifies the class on the calendar like a course code and section number, or use autonumber)
classstartdate
classenddate
courseTitleID (foreign key for relationship; datatype will be a lookup table to tblCourseTitles)
instructorID (foreign key for relationship; datatype will be a lookup table to tblInstructor)

tblEmployees
employeeID (primary key – use employee ID number)
employeeFirst
employeeLast

tblRosters (this is your junction table)
scheduleID (primary key, also foreign for relationship)
employeeID (primary key, also foreign for relationship)

Hi again - just curious if you were able to implement your database and how it's working out for you.