Dear experts,
Would like to ask your advice. My QA department asked me to make a small Access database where staff can watch video tutorials.
As the video's are company owned, they aren't allowed to access and download them directly so idea is that they access a dbse and then can select a course/chapter/tutorial and then watch the movie by clicking on the provided link (vthe ideo's will be on the network on a NAS), additionally, HR can monitor which staff member is following which course and the progress done.
I've set up tables and relations as per attached screenshot but I'm still puzzled.
Let's say staff member Rick wants to watch the Safety course, chapter 1: lifeboats, video tutorial 1: safe operation.
How can I setup in access that the user can select the courses/chapter/video tutorial himself and add it to his progress list? In my present setup I am linking the courses to the users manually. So if user logs in under his user, he sees all the courses.
Thanks for your help.
Best regards,
Siegfried
Would like to ask your advice. My QA department asked me to make a small Access database where staff can watch video tutorials.
As the video's are company owned, they aren't allowed to access and download them directly so idea is that they access a dbse and then can select a course/chapter/tutorial and then watch the movie by clicking on the provided link (vthe ideo's will be on the network on a NAS), additionally, HR can monitor which staff member is following which course and the progress done.
I've set up tables and relations as per attached screenshot but I'm still puzzled.
Let's say staff member Rick wants to watch the Safety course, chapter 1: lifeboats, video tutorial 1: safe operation.
How can I setup in access that the user can select the courses/chapter/video tutorial himself and add it to his progress list? In my present setup I am linking the courses to the users manually. So if user logs in under his user, he sees all the courses.
Thanks for your help.
Best regards,
Siegfried