By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,080 Members | 1,855 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,080 IT Pros & Developers. It's quick & easy.

New to Access and looking for resources.

P: 1
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.
Feb 21 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
Here are some tutorial links I've put together :
  1. Microsoft Access Tutorials (Strive4Peace).
  2. Microsoft Access Tutorials
  3. Microsoft Office Tutorials.
  4. VBA Tutorial (Excel).

They may not all suit you but I expect you'll find some of them very helpful.
Feb 21 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.