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.
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.
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.
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.
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.
I am preparing a "simple" training database. I want to do this smartly and not duplicate data.
My first table is the list of employees and their information. I have set a primary key (PK) up for each employee.
My second table is a list of training courses - title, description, start/stop time, credits, ... Each of these courses has a unique number (PK).
It's the final database table that is driving me nuts. I want it to show whether a n employee has taken/will take/not planning to take a course. My idea is to have a status field and then wanted to link that with a student number and a course number from the other tables.
In the past I would just have put common data fields StudentName from one table and CourseName from the other into the final database tables as a means of linking them. But I thought/read it's better to use a PK instead. Well when I make the third table up I get all of this Type Mismatch errors.
I am creating a training database and i have a courses table. And I need to somehow record all of the different employees that attended a course?
What i can do to make this happen? My employees have an employee number so is there a way of putting all of the employees together in one field? what field would the attendees be? currently is numeric which doesn't seem to work.
I am building a database for employee training. In the FrmNewTrainingGroup I am trying to create a form that will allow selection of a single class, a completion date, one or more instructors (or none at all) and a list of students by LName, FName, MI, EMP#. in my latest attempt, I have tried using a query of the TblEmployee to act as a go between, and dropped a subform into the FrmNewTrainingGroup, and that is not working.
Trying to get the student roster to work has been frustrating. I have been attempting to make it a check box select list that is also searchable by LName and FName [which would perhaps display a reduced list of names, as the name was typed?. This list would update a class roster text box to reflect all the selected employees for training so far, prior to the class being committed (I am planning on a button on the form).
I am in the process of creating a training database that includes levels of proficiency with certain tasks for employees.
In one of my reports I would like to appropriately display with tasks the employee "Cannot Perform";"Can Perform with Assistance";"Can Perform Alone";"Trainer" (straight from the field list of the task). But I can't seem to get the hierarchy correct. Tried it in a PivotTable too as I thought similar to PTs in Excel you could get some kind of "count" of values. Couldn't make that happen either.
Each employee has a proficiency rating on about 20 different tasks. Proficiency input is controlled by a field list. I would like to structure this part of the report like so:
I'm a access novice who is looking to create a database to store training records for permanent and agency staff, and contractors staff. I need the database to be able to produce reports on how many courses were trained over each month, and the total duration of the course completed (in hours).
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!
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.
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,
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
I need to create an inventory database that will track customer owned inventory as it is received stored serviced and sent back to my customer. I am in the oil and gas industry and store large amounts of customer owned pipe. many joints will have the same part number but each joint is one of a kind in that it has a joint,heat, lot, and batch number. here is an example,
Job Name: Shell ex Part Number: 129001 Quantity: 1000
Each one of the thousand joints will have a combination of this information making it one of a kind.
My system needs to allow my users to receive jobs, record where we store the pipe in a rack location, pull the specific joints out of inventory as the customer calls for them. We will receive 1000 at a time but the customer calls for portions of that job over long periods of time..
I have appx 500 customers that have contracts..... The contracts have 15 products that are available. Not all of the customers purchased all of items on the contract. I want to have a database that lists (on one page) the client information, contract information and the product details for that customer. I have no clue how to go about doing this. The Contact database template is what I am starting with. I want to click on a customer and pull up the information all on one page.
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.
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?
I want to set up a Library File containing code that I can call from numerous access databases.
I try to make reference to the newly created Library.accdb file in Tools - References and get the error message: Name conflicts with existing module, project or object library.
I have checked the names of all of these and there does not appear to be a conflict.
I run a soccer league where we track players attendance for each game. I currently do it on a spreadsheet where each game date is a column and each player is a row. We also track which team they play on at each game (they can play on different teams different weeks). I currently have a second tab in the spreadsheet to record which team a person plays on each week.
Setting up a table of fields for this is relatively easy. The problem comes to data entry. I want to be able to visually see the data like I can in a spreadsheet (names in rows, dates in columns, intersections containing either team name or whether attended) and whilst a cross-tab query gives me the layout, I cannot input data in a cross-tab query.
I have been tasked with setting up a certificate request database. I have an Access 2032 FE & SQL 2012 BE. I need to store PDF documents from all our branches.
I have been working on this for the past 3 working days and I have seen a great deal about saving the file path to the database vs saving the actual document in the DB. The documents would be located on each users computer.
I have a Form with all the information that is required by the certification department. On the form is a button (Called InsertID(ID in this case is the persons Identity Docuement)) and the button is linked to a table called dbo_CertificationSupportingDocuments. The table is referenced to the Main Certificate Request table.
The dbo_CertificationSupportingDocuments table is structured as follows:
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?
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.
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?
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?.
