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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 !
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 For Missing Values From Training Database
Hi I have inherited a database that contains details of staff training data and the tables contain the following: Personal Information Table: PersonalID Surname Forename EmploymentStatus (this contains either Staff, Operative, or Supervisor) Training Courses Table: CourseID Course Name Course Description Supervisor (Yes/No) Operative (Yes/No) Staff (Yes/No) Training Courses Attended Table: RecordID PersonalID CourseID Date Each of the courses in the Training Courses Table should be attended by one or more of the groups identified in the EmploymentStatus field (ie. Supervisor, Operative, Staff) and the relevant field in the Training Courses Table is flagged eg. Training Courses Table: CourseID, CourseName, Supervisor, Operative, Staff 100, basic safety, Yes, Yes, Yes 101, safety management, Yes, No, No 102, working with ladders, No, Yes, No 103, VDU, No, Yes, Yes I need to identify which individuals have not attended the courses that they should have been completed (ie. compare courses attended with the list of courses associated with the EmploymentStatus associated with individual staff members, and identify which courses have no attendance dates). How can I structure the query, I can't see how to do this with the existing tables, but I think it should be possible, but my Access expertise is just not good enough to work through this. Any advice would be much appreciated.
View Replies !
Help Setting Up A Database
17412 Hi, I am trying to set up a database for organizing Track and Field meets. I'm a newbie to a lot of the Access capabilities. I've attached a PDF of what I'm looking at doing for my Access tables. Some of the tables I think I have right. I don't know how to organize the meets, events, days. Should I have a table for each event? Can you look at my tables and give me advice on problems you can see? In the end I would like to enter the event results by race. Some races could have 10 or more heats. There are also field events that have different number of attempts depending on the meet. There are different track meets with different events each time and the order in which the events occur changes from meet to meet. Any help or advice you can give me would be great. Thanks! CK
View Replies !
Need Help W/ Setting Up Database
Hi, I'm working on this huge project and would like to see if anyone has any advice on how to structure and build my database. This is for the Accounting of Payroll for Staff, Contractors, and Per Diems (untaxed travel and housing exp) for a theater company about to do a major production. The problem is there are several categories of Staff (Directors, Producers, Actors, Orchestra, Sound / Light, Costume, etc.) and each one gets paid differently. Some may get a weekly salary, a per diem, or paid contract in installments throughout the performance (e.g. 500 on openining night, 500 on closing night). Some get paid a combination of the above. The hard part is some get processed through an online payroll, while others are paid through manual check (yet in this case, certain deductions must be made). That's what made this so complicated as some will require a % of gross paid to their agent, a % to union, and balance to them. I thought I had this figured out w/ a massive spreadsheet showing who gets what and in what period, To further complicated it, payroll is bi-weekly, so then my data within a spreadsheet became just too much to even make sense of although the data is correct. So my question is, what tables should I create? Pay Periods / Actors / Agents / Pay Type / Contractors / or all of these in one table? I don't expect anyone to reply to this as it is asking so much and not clearly defined. But if anyone has had a similar experience I'd appreciate your help. Thanks
View Replies !
Setting Up A Birthday Database
Basically - well maybe not lol What i'm trying to do is create a worksheet that contains information regarding childrens birthdays for a playcentre, so that it will show me at least 2 weeks before the birthdate so i can get a letter sent out to the parents reminding them of our party facilities, However its been years since i've used windows programs and i'm struggling pls help, Regards Pandapops001
View Replies !
Setting Up Database - Need Help With Relationships Between Tables
Hi, I would like to create a small HR database that holds: * Employee details (Name, Date of birth, Entry Date, Exit Date, Function,Department, Shift) * Departments * Departments and capabilities needed * Employee, departments and capability achieved (1=yes, 0=no) The idea would be to have a link between the employee the departments capabilities I can tick fields of the capabilities they have or have achieved. When I have this I could run a report that shows a score per employee For example: Name: Department: Orderpicking: Packing: Cutting: John Warehouse 1 1 0 As the tasks / capabilities required are different per department you would see something different if you would have user Jane that works in accounting Is there anyone that can give me some hints so that I can get any further?? For the moment I have 3 tables: 1. Employee information - John, Jane 2. Departments - Warehouse, Accounting 3. Department tasks - Department, Cap1, Cap2, Cap3, Cap4
View Replies !
Setting Up User Accounts To Access A Database
I've created a database and I now need to set up user accounts for access to it, so that I can restrict who has read only and who has write only permissions. I've done this before and never had a problem! But this time, whenever I try and create a new account, the following message is displayed: Cannot update. Database or object is read-only. Can anyone help as to why I get this message and what I can do to stop it! Whilst it does this, I can't create any user accounts. Any help would be appreciated!! Thanks in advance
View Replies !
Setting Database Properties (i.e., Revision Number)
Good afternoon, I have finished completing the initial version of a database and am now ready to begin the testing phase. When looking at the database properties (Specifically - "Statistics") there is a "Revision Number", which is always blank. I expect some changes and would like to set the Version Number each time I make a revision. How do I set the "Revision Number" found under the Statistics tab from Database Properties which was pulled from the "File" button on the toolbar? Thank you, Scot
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 !
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 !
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 !
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 !
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 !
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 !
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 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
