Modify an Acess Database
- or -
Post a project like this1732
$750
- Posted:
- Proposals: 7
- Remote
- #2461382
- Awarded
Web Design & Development | Ecommerce | Html | CSS | javascript | React | PHP | PSD to Responsive | Mysql | Software Development
Dhaka
HR Systems Administration | Excel | PowerBI | Data Warehouse | MS Access | Web Development
Armidale
1104254870016636902118187252655828283022848455
Description
Experience Level: Expert
Estimated project duration: less than 1 week
Tool store database using MS Access which tracks issues and returns plus issuing of consumables. Functionality of the database needs to be modified and improved for ease of use and generating reports.
Specifics
• Keep functionality of current database but be able to issue tools and return them via barcode scanner.
• Scan employee code, which will show current tools out then scan tools for issues and also scan tools for returns.
• Add in Consumables issues which will automatically update current stock levels.
• Create consumable order report (partially done)
• Differentiate which store is currently being utilized
• Automatically generate report for tools out
• Generate defective and missing tool reports
• Generate stocktake list and be able to enter data from this back into the database to generate missing tool list
• Be able to highlight when testing and tagging is due on electrical and rigging gear.
• Update switchboards for ease of use.
• Make the whole this idiot proof.
• Generate PPE, consumable usage graphs/reports for seeing what is high usage.
• Easily update consumables quantities when new stock is purchased
Specifics
• Keep functionality of current database but be able to issue tools and return them via barcode scanner.
• Scan employee code, which will show current tools out then scan tools for issues and also scan tools for returns.
• Add in Consumables issues which will automatically update current stock levels.
• Create consumable order report (partially done)
• Differentiate which store is currently being utilized
• Automatically generate report for tools out
• Generate defective and missing tool reports
• Generate stocktake list and be able to enter data from this back into the database to generate missing tool list
• Be able to highlight when testing and tagging is due on electrical and rigging gear.
• Update switchboards for ease of use.
• Make the whole this idiot proof.
• Generate PPE, consumable usage graphs/reports for seeing what is high usage.
• Easily update consumables quantities when new stock is purchased
Tim A.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
12 Aug 2019
Australia
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies