Linking Job Titles To Training Courses
Hi,
I'm new to this forum so forgive me if this thread is in the wrong section.
I'm currently creating an OHS&W (Occupational Health Safety & Welfare) database. My boss has just requested if I can possibly have it so that when a Employee has a job title selected for them it automatically lists the courses that are required for that job.
Can anyone help me please?
Cheers
View Complete Forum Thread with Replies
Related Forum Messages:
SQL Training Courses
Morning all I am currently working with IT and am looking for a course/courses to further advance within the IT sector. My employer is willing to fund and/or allow me time from work to obtain the qualification. I am writing to see if anyone could advise on the best courses i should be looking at or are available. I am looking into doing something with SQL and have been looking at the MCITP course with Computreach. Can anyone recommend this course or has anyone any other recommendations?. Regards Nathan
View Replies !
Report Titles
How can I get a report to have the title of a field in my form? I have a command button which when pressed brings up a report revelent only to the record the form is currently viewing. At the monent the title reads "Current Method" but I would much prefer it to read tha title that Method has on the form. Any Ideas?
View Replies !
Report Titles
How can I get a report to have the title of a field in my form? I have a command button which when pressed brings up a report revelent only to the record the form is currently viewing. At the monent the title reads "Current Method" but I would much prefer it to read tha title that Method has on the form. Any Ideas?
View Replies !
Help In Report !! Hide Titles
Hello everyone, i am trying to make a small database for my uncle, but i am stuck in the report. can someone help me out and tell me how to hide the title, the value and a label only when the field is empty... i have attached the file here plz look at it and help me out... see the report i have made.. i want the whole line to be hidden when the value (1,2,....,10) is null. plzzzzzz help me...!!!
View Replies !
Combo Boxes - Values And Titles
I have a form that includes a field for the operating system of the client. I want this to be populated from a look-up table. I want the combo box to display the text name of the OS but enter the numerical ID number to the client table. How do I do this?
View Replies !
Changing Listbox Column Head Titles?
Hi there I have a listbox and all is well - the only problem is that the column heads are a little 'ugly' - my column names are usually something like 'catagoryName', 'productType' and 'price' instead of looking pretty, like 'Catagory Name' and 'Product Type' and 'Price' respectively. Is there any way to edit/format the title/column heads without having to change all the tables and queries etc, so they look a littler prettier? Many thanks Edd
View Replies !
Training
I've been reading books to learn VBA for Access 2007, but I would like to take some training classes. Can anyone suggest any good online or onsite courses that I could take?
View Replies !
Training Videos
I was looking at purchasing the following set of training cds and noticed there is a 5 user license included. Would anyone else be interested in going in together and buying this? Link (http://www.youlearn.com/products/lk-products/A/access2003dev/access2003dev.html) I thought I might even rent them out after I go through them.. Anyone have any interest or other ideas? If so, pm me. :) I'm guessing that I already know about 60-70% of what is teaches but the other stuff looks interesting plus I'm really needing to train my replacement at some point in the near future...
View Replies !
Training Tracking
Does anyone have a sample training tracking system / database they'd be willing to share? Or, barring that, can someone point me in the direction of where I might find one? Thanks in advance! Looking forward to it!
View Replies !
Tracking Training
Does anyone have a sample training tracking system / database they'd be willing to share? Or, barring that, can someone point me in the direction of where I might find one? Bee replied once, suggesting I look in the Samples Databases section of this forum, but I could not find anything even remotely related there. All replies are gretly appreciated!!
View Replies !
Need Training Database
I am trying to create a Microsoft Access training database for us at work and I’m not having much success. Can someone look at what I’ve done so far and see if they can make it work or if you know of one out there already that I could download and use that would probably even be better. If there is more to it than just training then that it’s probably better too because I want to expand this as I get time. Thanks, Mike
View Replies !
Tracking Training
I have a DB I'm using to track training for assigned people. Right now the training gets put in the DB at the end of the day by going through each persons record and adding the training that they did for the day. As you can see when training 30+ people a day, putting this in the system can take awhile. I'm trying to find a way to do a mass input to cut down time and could use some help with this. My tbls are as such, 1st Table:EMPLOYEEtbl EmployeeID EmployeeName (Other information) 2nd Table:CLASStbl className classID 3rd Table:CompleteClasstbl EmployeeID classID DateTaken What I like to do at the end of the is select the ClassID/DateTaken items once and then type in a just the 30+ list of employeeID's click a button and append it to the my 3rd table. Of course writing it out like this makes me think it should be easy but for some reason I'm lost. Does anybody have any suggestions?
View Replies !
Best Training Course London
Hi, Myself and a few of my colleagues want to petition our boss to be given Microsoft access training. Most of us are fairly experienced excel users but do not write our own macros or anything of that sort. None of us have any prior experience with Access. Ideally we want a course based in London that will take us from ground up to expert users. There seem to be loads of courses out there but we want to know which ones you feel are good and in particular which lecturers within a given company are best. Cheers Baz
View Replies !
Online Training
Have any of you ever used some really good online training? I really need to get good with ASP.NET, VB.NET, ADO.NET and SQL 2007 Server ect. I want to do some self pased online training, anyone used a really good service for this? Thanks you!
View Replies !
Need Training Database
I am trying to create a Microsoft Access training database for us at work and I’m not having much success. Can someone look at what I’ve done so far and see if they can make it work or if you know of one out there already that I could download and use that would probably even be better. If there is more to it than just training then that it’s probably better too because I want to expand this as I get time. Thanks, Mike
View Replies !
Fitness Training Form
I'm trying to set up a training program for my gym database but I'm having alot of problems, I will be in debt to anyone who can help me out! My current "training" tables" ExAttributes ExID - PKEY ExType - (Sets, Reps etc) ExerciseTypes ExerciseID - PKEY TrainingType - (Lookup from TrainingTypes, cardio etc) ExerciseName - (jogging, swimming etc) Training TrainingID - PKEY MembershipNo - FKEY TrainingType - (Lookup from TrainingTypes, cardio etc) ExerciseName - (Lookup from exercisetypes) TrainingTypes TypeID - PKEY TrainingType - (Cardio, Strength etc) --- Hope that makes things abit clearer Just to clarify I have most of the other things done, the membership, payment, measurements and health forms are working great, I can also search for members and run queries as to when membership runs out & who hasnt attended in a set period of days. What I am looking for from this training form is just a form where I can bring up a membership ID, and below that have a series of drop down boxes, one under the heading Cardio and one under the heading Weights. I should be able to select an exercise in one of the many combo boxes (for example jogging) - and then enter the time / distance in text boxes. I should be able to do the same then with the weights but with sets / reps / weight instead. I also want to have Sessions 1,2 and 3 for each member ID, as part of the training plan they will have to do 3 sessions a week, these should be able to be different. Thanks in advance.
View Replies !
Gym Training Form / Table
Hi, I want to create a simple training form which would allow a personal trainer to input a series of exercise types, name, sets / reps for a member which then could be printed out as a "Session" for them. I have completed the rest of the database which deals with members, payment and so on but this part is leaving me stumped, any help greatly appreciated. Jon
View Replies !
Tracking Employee Training
I am tracking training for employees. I have a database that keeps track of the dates a particular training was taken. Employee training is ongoing from year to year. I have an Employee Training with a subform showing only the specific employee's training. I need a help with a few things. I need to keep track of training by the year. If I enter 2006 dates it will show in one line, if 2007 dates, another, all the way across the list of training classes for an employee. I also only want to limit a person enter more than one date for a particular class for a calendar year...Are these things possible. I have attached the database. Please help, make changes and suggestions. Thank you so much in advance.:eek:
View Replies !
Setting Up A Training Database Help!
I have a table with the following fields flddate fldclassname fldemployeename fldstatus I have data entered all current employee training and dates that training was done. I am looking for an explanation on how I can set it up so i can see who of the employees have not recieved the training. I am also looking for code for the query to calculate recurrent training dates (when the next training is due for each employee) Dates of initial training for each employee may be different, as well the training may be required every one year or every two years etc. I am hoping that I am explaining this more clearly in hopes to get some input back from the experts on this site. Thanks in advance.
View Replies !
Tracking Expired Training
Hi I have a query that tracks employee training that is incomplete. The query grid includes a yes/no fieldsthat show if it is completed, so I put criteria to say no, so if the course is not done, it will show up, But it also has to show if the training was already completed but expired, So i created an expired field in the query grid which calculated the expiry date. To show if training is expired, I put in an OR condition, training complete =yes, and expiry date <=now. It does show the correct results. My problem is, if someone completes one of the expired courses, and the data is entered with a new expiry date (calculated) I want the previous courses (the expired one) to be removed from the view of the query. Right now it still shows because of the criteria. What can I add to the criteria for the expired training to make it dynamic, based on the data entered into the table, or do I have to put a new or condition in. any help would be appreciated Marlie
View Replies !
Database To Record Training Data
Hi All I am trying to setup a database to record details of who and where I trained staff. The ones I have found all include grades and marks which I don't want. Does anyone have a sample database that can help get me started please. Tee.
View Replies !
Query To Find Ee's With Training Not Completed
I am working with a training database. I am a fresh newbie to access (more of an excel user). I need to find employee's who have never completed a certain training (DPW Medication Training), which is mandatory. I have the following tables: Employee data TBL - Contains active ee's names CompletedTrainings - Contains all trainings completed by individual Events - name of all the trainings, including mandatory trainings I have the following queries: DPW Med Training - Lists all who have completed the training DPW-Med-Last - Lists when each employee last had the training Med_01 - Lists those who have had the training, but need it renewed Any thoughts?
View Replies !
|
TRACKER
