I am toying with the idea of setting up a chemical data base in MS access - so i can search chemicals by name or class, and see how much i have left etc.
Has anyone done this before? I have a husband who is willing to set the values up on the programme etc.
Microsoft Access
- Labbie
- Posts: 3247
- Joined: 28 Nov 2006, 10:00
- Job Title: Retired
- Suburb: At Home
- State/Location: NSW
Re: Microsoft Access
I have my register on spread sheet or excel microsoft. It works for me. It's on the computer and I can look it up any time I like, or add or delete chemicals as I use them.
Regards Labbie
Lab Manager/Lab Tech, mind reading etc etc
Now retired
Lab Manager/Lab Tech, mind reading etc etc
Now retired
-
- Posts: 62
- Joined: 09 Jul 2010, 15:19
- Job Title: laboratory technician
- School: Calrossy
- Suburb: Tamworth
- State/Location: NSW
Re: Microsoft Access
I also have used excel spreadsheet for my chemical stocktake and have also added a column for the msds date, so at a glance I will know when they need updating
annett
annett
Annett Stanley
Tamworth
Tamworth
Re: Microsoft Access
hi narelle
I have the schools chemical register on a spreadsheet. its easy to use and the DET has seen it and are happy with it
I have the schools chemical register on a spreadsheet. its easy to use and the DET has seen it and are happy with it
Re: Microsoft Access
My chemicals data is on an excel spreadsheet also. Annette good idea about the MSDS cloumn I am going to do that now too.
I have all of the practicals we do here on an access data base program and teachers just find the prac they want by a drop down arrow and then fill out the rest of the form, It is absolutely best resource ever.
So I guess whichever program you are more familiar with will work best for you.
I have all of the practicals we do here on an access data base program and teachers just find the prac they want by a drop down arrow and then fill out the rest of the form, It is absolutely best resource ever.
So I guess whichever program you are more familiar with will work best for you.
You do not have the required permissions to view the files attached to this post.
Re: Microsoft Access
thanks for your thoughts!
I too have an excel spreadsheet with my chemicals on - i thought that the MS access would give a more searchable feature, and then move over to having the equipement there too.
I looked for something yesterday for about 20 mins, as the item hasn't been asked for in the almost 1 year I have been here, and it wasn't where the current list said it should be. And everyone calls things different names....
I too have an excel spreadsheet with my chemicals on - i thought that the MS access would give a more searchable feature, and then move over to having the equipement there too.
I looked for something yesterday for about 20 mins, as the item hasn't been asked for in the almost 1 year I have been here, and it wasn't where the current list said it should be. And everyone calls things different names....
-
- Posts: 1795
- Joined: 20 Mar 2007, 10:00
- Job Title: Lab Assistant
- Suburb: Tamworth
- State/Location: NSW
Re: Microsoft Access
The one nickyw has is great!! I looked at it before we got RiskAssess with the intent to add to it with what we use and try to keep track of chemicals and to encourage teachers to actually order pracs. When we ended up going with risk assess I just let the idea go. It would be great to have a system that automatically reduces your stock levels when things are requested.
Re: Microsoft Access
The LTAV has a MS Access Inventory database.
Perhaps you can purchase it?
All the work is done for you. You enter in the data and then can pull up chemicals low on stock, a list of Dangerous Goods, Hazardous Chemicals etc.., or search per item.
Will save you a lot of time and effort.
Perhaps you can purchase it?
All the work is done for you. You enter in the data and then can pull up chemicals low on stock, a list of Dangerous Goods, Hazardous Chemicals etc.., or search per item.
Will save you a lot of time and effort.
Christine
Lab Tech
DET school, Melbourne
Lab Tech
DET school, Melbourne
Re: Microsoft Access
will look into that - thanks.
Otherwise hubby is my helpful IT guy
Otherwise hubby is my helpful IT guy
Re: Microsoft Access
Hello
http://www.education.vic.gov.au/hr/ohs/ ... sgoods.htm
This is the VIC education site...this does not require a password etc... I use Chemwatch Gold 3, manifest...
amanda
http://www.education.vic.gov.au/hr/ohs/ ... sgoods.htm
This is the VIC education site...this does not require a password etc... I use Chemwatch Gold 3, manifest...
amanda