Description & Screenshots Features Author: James C. Estill

Description

LabMan is a Microsoft Access based application designed for the management of lab related materials. This includes management of information related to lab equipment and chemicals, as well as inventory of where items are stored in the lab. This database was originally designed in FileMaker Pro, and was later ported to MS Access. Portions of this database have been written by Hash Lala.

Features

• Administration of orders through the process of ordering (Approved, Ordered, Arrived)
• Full history of ordering and use for all items inventoried in the database
• Printable order sheets needed for ordering through the University of Georgia central receiving services and selected vendors
• Database of all vendors and contact information associated with each item
• Searchable inventory of lab equipment, chemicals, and labware
• Pipette management including calibration status, location, and user
• Tracking of chemical safety information for all chemicals used in the lab including hyperlinks to Material Safety Data Sheets

Screenshots

The following screenshots are shown at 50% of their actual size.

PGML LabMan Program

Main interface to the subsections of the LabMan program. These subsections include lab inventory, ordering database and pipette management database.

Inventory Location

Every location in lab can be assigned a unique ID. We have assigned Unique IDs to every cabinet and drawer in our lab and have printed out bar-coded labels for them. Scanning the bar code brings up the lab inventory data entry form, and all items that are at that location.

Finding Inventoried Items

You can search for inventoried items and find out where they are in the lab.

PGML Ordering Database

A major component of the lab management database is the PGML ordering database. This provides administration by the PI and the person in charge of ordering as well as browsing by all lab personnel.

Password Protection

Administration of the database is password protected, and database security is provided by nuns with guns.

Ordering Database Browsing

The database browsing form is provided for all lab members to access information related to lab materials and the current status of ordered products. This also serves as an online Material Safety Data Sheets collection since the chemical safety information for each chemical is listed, and links are provided to HTML copies of MSDS sheets.

Ordering Database Administration

This password protected database administration form allows for updating all information related to ordering lab supplies.

Author: James Estill Last Updated: Thursday, 26 May 2005

The content and opinions expressed on this web page do not necessarily reflect the views of nor are they endorsed by the University of Georgia or the University System of Georgia.