Database Project Part1

Instructions

Assignment 1: Database Project Part A: Create and provide a laboratory inventory database/spreadsheet. 

The detail and meticulousness of your laboratory database serves as evidence of professional behavior in the workplace.

As the laboratory manager, the visitors (potential investors in the company) have asked you to “walk” them through your laboratory inventory database/spreadsheet. They want to be re-assured that the laboratory personnel are detailed and conscientious in their work and economic in their spending; they do not want their money wasted. 

Your inventory should, ideally, include, at least: purchase requester and date, approver and approval date, purchase dates, purchase cost centers (grants or re- investment money), vendors, costs, location of supply or item, location of the SDS (if a chemical), decommissioning date and reason, for chemical the hazard category. 

You will need to track the following:

· Consumable/disposable laboratory supplies: inventory of available supplies; requests from lab members to purchase new supplies; and purchase requests, costs, and receipts. Include at least 5 unique supplies in the inventory, 4 of which are chemicals each from a different hazard class.

· Durable laboratory equipment and supplies: inventory of available equipment and supplies; requests from lab members to purchase new equipment and supplies; purchase requests, costs, and receipts; for equipment and supplies greater than $1,000 in purchase price, the location of the equipment and the equipment identification (ID) number issued by your institution; for decommissioned equipment and supplies greater than $1,000 in purchase price, the date and reason for decommissioning and the location or transfer information of the equipment You should have a minimum of 2 items.

· In your database you will need to include 3 personnel by including them in the procurement area.

 To complete this assignment, do the following and post in your assignment folder by the deadline:

· Select Microsoft Excel (spreadsheet) for your tracking system. When you go to New search for inventory

·

· Using your selected spreadsheet, design and create a shell to track this information. Remember to include at least 3 personnel, 5 consumables (representing at least four classes of hazards (health or physical) from the 29 CFR 1910.1200 list available at:  https://www.osha.gov/Publications/OSHA3844.pdf  , and 2 Durable laboratory equipment or supplies.

· Submit a PDF version of your demonstration spreadsheet.

In an accompanying 1-2 pages written paper:

· Describe a strategy for the routine updating and maintenance of the database/spreadsheet, as well as for checking the accuracy of its contents.

· Describe a strategy for making the information in your database/spreadsheet accessible to all laboratory members while maintaining the integrity of the database/spreadsheet and its contents.

· explain the set up and organization of your database by explaining the purchasing and tracking process

Your grade for Part A will be based upon: (a) Completion of a sample database with the necessary fields (40%), (b) Written Paper including an explanation of the database form selected (5%), an explanation of the set-up and organization of your database (25%),  an explanation for user access and maintenance of the database (25%), and correct grammar, spelling, punctuation, etc. (5%).

Due Date

11:59 PM