In places that use the ideas of agile software development, the usual way is to just let the newcomers pair with the more experienced members in all tasks. In your case it would consist of a lot of pair programming. But you would need to do it correctly. It isn't one person programming and the other person watching. Both participate, but in different ways. ...
Based on the comments, the minimum for theory and technical is how the nomenclature of MS Access relates to Excel.
If they've been doing everything in Excel anyway, they've developed habits for, or against, normalization that you're not going to break in a couple days, intensive or not.
If they haven't discovered the pitfalls of redundant data in Excel, ...
First, there is a scientific journal that may include publications of such material that are what you are looking for: The Journal of Open Source Education, "An educator friendly journal for publishing computational learning modules and educational software."
Second, but I am not sure this is completely relevant to your question, there are the open source ...
As well as pair programming, look at other agile/lean techniques.
Test Driven Development.
What does done look like? / definition of done (scrum).
Short release cycles (scrum).
Minimise work in progress (scrum/kanban).
Shared ownership (scrum/XP/lean).
Local product owner (XP/scrum).
To teach Test Driven Development, you can start by writing the tests ...