This project will involve creating a database that will track computer equipment and employees. I have a small business and I want to be able to have a database that will inform me after five years a computer must be replaced. Also, after every three years to update printers, monitors, CPU's and other related hardware equipment. I also want to keep track of employees pay rate, vacation, sick, annual leave, address, DOB, phone numbers, email address etc.
I prefer a Microsoft Access database or a database that is simple that will keep track of all computers, monitors, and printers. Each piece of hardware will have a 10 digit barcode on it. After five years I want the database to be able to inform me that a specific piece of hardware needs to be updated. I have a total 25 workstations.
In the same database I want to keep track of every employee using a six digit employee number. There are a total of 75 employees. When entering an employee name and employee number I would like to view pay hours for the week, vacation & sick balance, employee address, phone number, email address, SSN, DOB, and emergency contact with name and number.
This is a very simple database and I am very open to suggestions. If everything is completed by the deadline I have other services that will require additional services as well as other projects for other clients and businesses.
Project should compatible using Microsoft Office 2007.