Create and training record database

[Ian V]

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

 

[theDBguy]

Hi. Welcome to AWF!

I’m not sure if there is one, but I would suggest looking at the available templates to help you get started.

 

[arnelgp]

cross-posted:

Record Training session and attendance

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...

www.accessforums.net

 

[Uncle Gizmo]

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

I can't find a ready-made template that matches your requirements. But "Training Management" or "Event Management" come close.. Available in MS Access as a starting point.

Both include tables for people, events/courses, and attendance tracking, which you can customized:-

Store unique employee IDs and details.
List courses.
Add course slots with dates.
Assign employees to courses.
Track course attendance and completion.
Generate reports for notice boards and attendance sheets.

Available in MS Access! Go to "New," and search for "Training" or "Event" templates.

Download and modify tables, forms, and reports to fit your needs

You may need to build a custom database or hire a developer to adapt a template.

 

[Gasman]

Apparently also asked back in 2024.

Create a new database with relationships

Hi All, I would like to create a database with the following. List of individuals (Firstname and surname + three other fields) Job Roles (C1, C, C+E) Date training was given for the following ( Oil Change, Wipers Change, Bulb Change)

www.accessforums.net

 

[GaP42]

One you will need to adapt and develop: https://access-diva.com/dm7.html

 

[arnelgp]

on Public Onedrive i scavenged this:

 

[MadPiet]

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

The short answer to your question is that this is a variation of the "Students and Classes" database. I did one like you're describing like 25 years ago. You will save yourself a LOT of hassle if you find a template or whatever that does most of what you want. (Unless you really understand normalization and proper database design, this is really challenging. If you're an Excel person and not an Access person, this could be a tall order. They assigned us this database project because it forces you get your head around proper design.)

Here's most of the design:
Person/Student(StudentID*)--(1,M)--enrollment(StudentID*,CourseInstanceID*,FinalGrade)--(M,1)--CourseInstance(CourseInstanceID*, CourseID, MeetingDate, Instructor)--(M,1)--Course(CourseID*, CourseName)

 

[Pat Hartman]

Welcome to AWF. Maybe you should pick a sample and review it in detail. Modify the tables to add the functionality you need for scheduling. Once you have a start, people will be happy to jump in and help you. No one is going to create a custom app to your spec.