Lab equipment database

Lab equipment database: Hi, I’m looking for a system to inventory all of our equipment.

Ideally it would also allow us to store commonly ordered practical activities so that they can be retrieved and reused. But at a simple level, I want to record the location and quantities of all of our stuff.

I found this www.quartzy.com, it looks good, but has much more of a commercial/research lab focus.

Voting:

No votes yet

Laboratory Technicians:

Laboratory Technicians

Answer by labsupport on question Lab equipment database

Submitted by sat on 19 August 2014

Answer reviewed 20 February 2023 There are a variety of options currently being used in schools.

Many schools have set up their own inventory system using MS Excel and MS Access programs,

some have also added bar codes to their systems to enable easy stocktakes.

Some schools are developing school-wide intra-net options for whole school inventories.

many schools use one Excel spreadsheet for equipment and another for chemicals, which allows sorting of entries such as equipment location or chemical DG class.

Some keep an Excel database of commonly ordered practical activities i.e., name of activity, equipment/chemicals required and their location if stored as a kit.

Some schools use RiskAssess for ordering equipment and archiving information regarding activities.

For chemicals, some schools use chemical management systems, such as ChemAlert or Chemwatch and

some government school sectors have templates. For example: https://education.qld.gov.au/initiatives-and-strategies/health-and-wellb...

Lab equipment database

Submitted by on 05 November 2015

Hi, For equipment location and quantities of the lab items simple and fast way is to use MS excel. For equipment request sheets, easy and simple option is use of MS excel. With MS excel you can prepare and re-use recorded repeat equipment request sheet (with expt name as each excel sheet) according to your own system requirement. That is the easiest way to prepare and re-use the repeat request sheets every year.I used MS excel this way for long time and then switched to MS access database which is more useful and powerful database tool. If you are looking for advanced features for system of recording and using request sheet with report, summary and various queries etc. than MS Access database can satisfy the all requirements. I used MS Access database to prepare own database and am still using it for many years and I found it very useful for our equipment request sheets with all advanced functionality integrated into it. I hope it assists With regards N Trivedi