Manual - GaryHostt/Training_repository GitHub Wiki

Manual on the use of the training records database Logging in

Select your name from the drop down menu Input your employee # as the password Contact your database administrator (Jeremy or Brittany) for changing your username or password

Viewing individual trainning

To view the training of an individual employee, click the green employee number. You can also sort the order the employees are displayed by clicking the arrows next to “First Name”, “Last Name”, and “Employee_ID”

Next this screen will come up, click either of the three types of training and then input the employee # in the popup window (the number is displayed above the three types of training boxes)

Then the employee’s training in that department will display. If you want to view more detail about which qualification the employee got, you can press the drop down menu (the arrow next to “Stacker” in the above picture). Don’t worry, you can’t edit the data on this screen. To leave this screen, either click the employee information tab, or right click “qryFiltCustomTraininGroup for frmEmployees” and press close

Training summary:

Clicking the Training summary tab on the left will bring you to this screen, clicking any of the three boxes on the right will display the qualifications for each area. Clicking any of the 3 boxes on the left will display the training spreadsheet shown below, only training conducted in the last 70 days (for filtration & manifold) or in the last 365 days (for plant) will appear. Contact your database administrator if these number of days are not desirable.

Seen here

This is how the spreadsheet will appear, if you name is not on the left, you have not received any training in the last 70 or 365 days. The columns to the right of last name display the area : qualification. Red means the employee has not received training in that, yellow means level 1 (the lowest qualification level), orange is level 2, and green is level 3 (fully qualified).

Training statistics

Clicking new and previous training on the left side of the screen will bring you to this screen. Clicking any of the three boxes on the right will display all training records that are older than 70 days for filtration & manifold and older than 1 year for the plant. Clicking any of the 3 buttons on the bottom left (view previous x training) will display a similar to here.

Every training done will display here, on the bottom left the sum of training hours is display (560). Clicking any of the arrows next to the column headings can filter this information as desired.

Inputting Trianing

Clicking one of the buttons under new entries will display this screen, this is how you input training. For hours to train: if you're entering 1 employee with multiple training, enter the average hours for one qualification. If you're entering multiple employees with 1 training, enter the average hours for one employee. If you're entering multiple employees with multiple training, enter the hours for 1 employee receiving 1 of the qualifications.