Record Training session and attendance

[ukfastcar]

Hi Everyone,

I have been using excel for a little while to record training sessions that I run but I feel that access would be better suited.



Here is an idea of how I believe it would work.

1. List of people in my organisation (each person has a unique number for example 10001001, 1001002, 1001003 and so on)
2. List of courses (example course1, course2 and so on)
3. Add slots and dates to create a course (example course1 on 01/01/2026 15 spaces, course1 on 10/01/2026 15 spaces, course2 on 01/02/2026 15 spaces) each course will always have 15 spaces.
4. Place people on a course filling up the 15 spaces, for (example 10001001 is placed on 01/02/2026)
5. Each person will have a record of courses that they have been placed on and courses that they have completed.
6. Produce a list of the courses along with attendees names for notice board.
7. An attendance sheet that can be printed out for the day of the course that they sign and can me emailed also.

Looking for something like that which I think will work better in access than excel.

Many Thanks

[jojowhite]

cross-posted:
Create and training record database | Access World Forums

[madpiet]

This is a variant of the Students and Classes database.

People--(1,M)--Attend--(M,1)--CourseSession--(M,1)--Course

CourseSession(CourseSessionID, CourseSessionDate, CourseID, InstructorID)

Attend/Signup is (CourseSessionID, PersonID, Present)

Excel is not the best tool for this. You need to be able to apply rules like "Once a course session is full, nobody else can sign up", "A person can only sign up for/attend an existing CourseSession (course on a specific date).

There's a reason this is one of the standard databases you build in database 101 courses. =)

[davegri]

What's wrong with the DB I adapted for you and posted 11/11/2024 from your original request at that time? Surely it can be easily adjusted for the new requirements.

ukf-davegri-v01.zip

[Micron]

What's wrong with the DB I adapted for you and posted 11/11/2024 from your original request at that time?

Wow. Cross posting without declaring, and that too?