I am so lost when it comes to MSACCESS but I know it is the only way to get the result I need.
I perform fit test on individuals who work for my organization. The fit testing is to ensure they receive the proper size of respirator and then account for each individual respirator that is issued out over the course of the day.
The way it has been done up to this point is using generic excel sheet and the info required is entered between multiple sheets; Such as list of personnel, size of respirator and date fit test was performed. While this gets the job done it is very tedious and the accountability is not 100%.
I am basically looking for a way to make a database of individuals; the database will require the usual info such as name, office location, phone number, immediate supervisor, date the fit test was performed and an expiration of one year for the test from the date of the fit-test.
I also need to have a database of 2 different model respirators in 3 different sized for each model. Each respirator will be serialized. The information unique to the respirators will be make, model and size. As a respirator is issued out for use I need the database to remove it from list of available respirators.
When a respirator gets issued to an individual certain information is required. This is where the tediousness comes in. 80% of my wasted time is verifying a valid fit test and manually typing each cell with the pertinent info about the individual and then the size and serial number of the respirator.
I want to make it so that when an individual shows up to check out a respirator I enter his name and all of his info is brought forward including the size of respirator that individual is fit tested to. Then I want to know what respirators in that particular size are available to issue and complete the business of issuing them what they need. If I have a team of workers show up Id like to be able to print one receipt that is sorted by their job control number which will show each individual and respirator s/n # assigned. I am also responsible to ensure, during the day when the work is being performed, that respirators are being used properly so having a way to print a report of all active jobs, personnel assigned to work, respirator # for each worker and the location of each job on one sheet of paper would make this task so much easier.
I also need to be able to generate a report what is currently checked out and to whom. If anyone can help with this either by putting something together or sending me some easy to follow instructions on how to do this myself I would be very grateful.
I am running MSACCESS 2003; unfortunately I have no input on when upgrade to current MSOFFICE will happen.
Thank you in advance
~~Shums~~
I perform fit test on individuals who work for my organization. The fit testing is to ensure they receive the proper size of respirator and then account for each individual respirator that is issued out over the course of the day.
The way it has been done up to this point is using generic excel sheet and the info required is entered between multiple sheets; Such as list of personnel, size of respirator and date fit test was performed. While this gets the job done it is very tedious and the accountability is not 100%.
I am basically looking for a way to make a database of individuals; the database will require the usual info such as name, office location, phone number, immediate supervisor, date the fit test was performed and an expiration of one year for the test from the date of the fit-test.
I also need to have a database of 2 different model respirators in 3 different sized for each model. Each respirator will be serialized. The information unique to the respirators will be make, model and size. As a respirator is issued out for use I need the database to remove it from list of available respirators.
When a respirator gets issued to an individual certain information is required. This is where the tediousness comes in. 80% of my wasted time is verifying a valid fit test and manually typing each cell with the pertinent info about the individual and then the size and serial number of the respirator.
I want to make it so that when an individual shows up to check out a respirator I enter his name and all of his info is brought forward including the size of respirator that individual is fit tested to. Then I want to know what respirators in that particular size are available to issue and complete the business of issuing them what they need. If I have a team of workers show up Id like to be able to print one receipt that is sorted by their job control number which will show each individual and respirator s/n # assigned. I am also responsible to ensure, during the day when the work is being performed, that respirators are being used properly so having a way to print a report of all active jobs, personnel assigned to work, respirator # for each worker and the location of each job on one sheet of paper would make this task so much easier.
I also need to be able to generate a report what is currently checked out and to whom. If anyone can help with this either by putting something together or sending me some easy to follow instructions on how to do this myself I would be very grateful.
I am running MSACCESS 2003; unfortunately I have no input on when upgrade to current MSOFFICE will happen.
Thank you in advance
~~Shums~~
