DataPig Access Training

Learn basic access concepts; improve your Access Reports; advanced Query tips; user Form basics and tricks; getting started with VBA

Sponsored Links:

Related Topics

Training database for Download
I would like to make up an access database that has staff details, a table with the staff levels and one with training courses, which are linked to staff and staff level. I would like reports to show staff indiv training, staff group training schedules and training available by name and dates etc.

and my skills are not good enough to amend microsofts employee example as there are too many sub forms and things I would have to change that I don't have the knowledge to do.


Training database for Download
I would like to make up an access database that has staff details, a table with the staff levels and one with training courses, which are linked to staff and staff level. I would like reports to show staff indiv training, staff group training schedules and training available by name and dates etc. can anyone help as I cant find anything on the net, and my skills are not good enough to amend microsofts employee example as there are too many sub forms and things I would have to change that I dont have the knowledge to do. Youre help would be appreciated!


Employee Training Records
I want to create a database to track training for approximately 47 employees, but I just don't know how to set it up. I need to track training employee provided or training an employee received as well as special events and international training.

Right now, I just have a basic table and everytime someone either provides/receives training, another record is entered, but which creates a lot of records. Is there a more efficient way to set this up?


Employee Training Records
I want to create a database to track training for approximately 47 employees, but I just don't know how to set it up. I need to track all training employee provided or training an employee received as well as special events and international training. Any suggestions on the best way to set it up? Right now, I just have a basic table and everytime someone either provides/receives training, another record is entered, but which creates a lot of records. Is there a more efficient way to set this up?


Calculations in Reports
I am trying to develop a report for Access 2010. The report shows training attendance. There training types field which contains 4 types of attendance State, County, National, and other, each record also has a field for training hours. I would like to perform 2 calculation the first is simply a sum of all training hours which I did very easily the second is a sum of state training hours.

I am trying an if statement but it does not work it only sums all training hours.

How can I sum only state training hours? Here is what I have tried so far.

=IIf([Training_Provider]="State",Sum([Total_Hours]),0)


Add Multiple Employees to a Training
I am working on a database to track all sorts of employee information (certifications, training, etc) and would like to add multiple employees to a training instance at once. For instance, if the employees at a particular office attend a training, I would like to be able to generate a list of employees and then select those employees to associate them to a particular training.

Some background

3 tables: Employees, Emp_Training_Assoc, Training
Emp_training_assoc has 3 fields, EmpTrain_ID (PK), Employee_ID, Training_ID

Currently I have a form set up to generate a training record. Then a command button to move to another form where the association would take place.


Date Calculation
I have a DB which tracks training of employees. The grace periods allowed with the training is that new training can be completed within 90 days of the expiry date without changing the anniversary date (e.g. the training is due on 1 April 2010, the employee conducts the training on 2 January 2010 but gets to keep the 1 April anniversary date).

The table I am working with is mainly based on the date of training and the training type (which determines whether the training expires on the 1st of the 13th, 25th or 37th months or if it keeps the same date); what I would like is for the end user to input the data into a form, have it autocalculate the expiry date on the form so they can verify the information and then once the form is closed, have this information fed into the table so that we can print training reports for the managers.

I'm not versed in VB and am reaching my limit of understanding with queries,


Access database query/report question
I have an access database that contains training records for employees. I am trying to figure out how to create a query/report that will tell me who needs, for example, forklift training, when I click on the report. In this example, forklift training has to take place for an employee every 2 years. Each time the employee has forklift training, it is logged in the database under "6" (which signifies forklift training) and the date of the training is logged as well. I can create a query that shows me everyone who has been trained in the last 2 years. However, I want to be able to see all those employees that have had this training in the past, who may not be up to date. In other words, in my current query that shows everyone who has been trained in the last 2 years, I have to be able to see whose name is missing from the list (who had training previous to the 2 years). Thanks for any help I can get!


training video database
I am semi new to access and I have been tasked with creating a database to keep track of training video for a the california smokejumper base in Redding. We need to keep track of: Practice Jumps, Fire Jumps, Parachute landings, training exits, training landings.
The database should be searchable by Name, Date, Jumpspot,

Also, new jumpers(names) will have to be added every year.


Best way to table design ?
I have several different departments with lots of employees attending training, and I need to be able to keep track of their attendance, and I have to be able to save a history of the data for the entire training cycle (training event and the date of training).

What is the best way to do this in Access, keeping in mind that ease of data entry is a must, since I have a lot of departments and there employees to track? What I need is to be able to create a attendance roster for a department and update of the employees at once if possible.


Auto populate a Yes/No box in a query
I have a situation where I would like to have a check box turn on when training is complete. What I have is collective training events with several training requirement to be completed. I would like the competed check box to turn on after all training requirement have been meet for that collective training event. Again thanks for your help and support.


Query that results in a list of employees that DON'T have specific training.
I am using Access to keep track of employee records. One the records in called "Pre-Job Safety Orientation".

I can produce a query to show me the list of people who HAVE the training. Currently, this produces a list of 123 employees who have the training.

I would like to produce a list of people who DO NOT have this training. This list would therefore produce a result of 25 people as we currently have 148 on staff.

It is a painful process digging through to find out who we need to get into training.


Crosstab Query
I have crosstab query with Team names in the rows, and Training in the columns. Teams that have completed the training have a number 1 in the field.

I also have an entry form where I can pick the above teams from a dropdown, and then the training they have completed from another dropdown.

What I am looking for is if a team has completed the training, a message box (or a warning) would appear advising the team has already completed the training when I select these from the dropdowns.


Compare and return, should be simple.. but
Simple employee training dbase.
Trainings are organised in training sessions, since a session can contain more than one training (i.e. First Aid, CPR, and Fire extinguisher)
Employees belong to departments.
Certain trainings are required working in a department, that dictates requiered trainings for an employee.
Now I have two queries:
'Query emp trng req' returning employee id and their requiered training id
'Query emp trng done' returning employee id and their completed training id.
Obviously I like to know which of the 'req training id's' are missing in the 'done training id's' per employee id
There can be training id's in the done query, that are not requiered for that employee.
I have the dBase attached, had to strip a lot from it down to <500k


Break-Even Line Needed
Im making a training database for my team.
I have made a graph in access which shows number of hours of training conducted by each individual.

Now every individual needs to have 20 hours of training every month and I want it to be indicated on the graph as a red line.


How do I filter what shows on a report?
I have a table that stores records of what training people have received. I would like to be able to print a report showing the training just one specific person has received. How can I make this achieveable?

I have a query that shows all training received by all personell but I would like to be able to also choose just the training received by specific individuals


Expiration date computation
My database keeps track of employee training. A few procedures have a limit on how long the training is good for, ie 24 or 36 months. There is a field include in the database for the date the employee completed the training ie 2/14/2010.

I need to create a report showing who need to retake the training because it has expired for that person. I have a query that results with all of the employees that have taken the procedures with an expiration.


Creating a Database to track Employee Training
I am in the process of designing a database that tracks certain employees training history.

I created three tables; tblEmployees(PK -Employee ID), tblTraining(PK - TrainingID), Course (PK-CourseID)

My problem is that I created a form, and a subform. But I cannot get both forms to be in Synch. Meaning once I select an employee, listing the training history of the employee. I would also like to be able to additional training information for each employee. I feel that I am almost there, but I am not sure what I a missing.


Multiple Selection Form
I have a database that keeps track of training sessions here at work. This database has 2 tables (Associate and Training). The training table has multiple records for the associate.

Every once in a while we have meetings where it involves the entire staff. I want to be able to have a way where the user that is inputing this data can just select a mass amount of users in a listbox and type in the data field information. Then this information will be saved under the training table.


Access 2010 Query Expression field calculation
I have a table contains the following fields
personalID,Workplace,worktime(minutes)
every person could work in multi Workplaces.
I want to make a Query of this table, and to add a new field (Training) in minutes which hold an Expression,
(Training = 900 - worktime)
then
the next Training field should contain the (900- last training value) of the same PersonalID and Workplace