I am trying to use access to do a number of things.
1.) Keep a running table of current employees and their information.
2.) Keep track of employee training seminar attendance with the ability to show attendance for a large number of people quickly.
3.) Be able to search an employee and get a printable page of information including employee name, which training seminars attended and a total of training hours attended.
Right now at the seminar each person signs a paper to show they attended. Then I get that paper to log it for each employee in a notebook. Each employee has a page with a spot for me to right the name of the seminar then how long it was and in which month it took place. So I get a page with sometimes over one hundred names on it and I have to go to each employee's page and write Fire Drill and 30 mins under February. HR then has to make sure each employee has a certain number hours of training at the end of the year.
I understand this may be a bit much for a first time user but this would just come in very handy due to my job of logging all training hours each employee has. Right now I have a table containing around 120 employees. My goal is to make a few forms that can do a number of things such as add an employee to the employee information table. That form wasn't that hard to make but now I am at the point I can't just wing it and see what happens.
What I ultimately want is to have a form so when we have a training seminar on say Fire Drills I can easily put in that John and Jane Doe attended that seminar and that the seminar was 30 minutes long. Then at the end of the year I can easily see how many hours John and Jane Doe spent in training and if needed print a list of which training seminars Jane Doe attended. Some of our training seminars will be attended by 100 or more of the employees so I need an easy way to quickly show attendance for a large number of people.
I don't have any real knowledge of programming or of access. I am just learning it to try and do this project and maybe more like it for my workplace. I don’t want want step by step instructions just some good links to resources to help me learn. So any help would be greatly appreciated.