Hi. I am Samuel. I am a full time IT support and experienced in database and reporting develop. I have experience in develop database in python, sql and access.
My proposal as below
1. Build a database that can accommodate 50,000+ records
2. Fast DB Performance Response
3. local server storage
4. Import data from Excel or CSV format
5. Easy and simple solution for record Spare Parts data, Search, track, export…etc
6. Fuzzy search & individual search per column. Ignore punctuations during search
7. Edit, Update, Delete, Sort, Save, Save As, backup….
8. Delete and/or create columns
9. Alert during entry of information if similar field exist in the DB
10. Able Create new columns in the DB
11. Export pre-defined, partial, or searched result
12. Add attachments to the record
13. Create menu
14. Processor name (Drop-Down) will be provided
15. Status (Drop-Down) will be provided
16. Status Date/time
17. Access and roles assignment for Processor and Administrator
18. Reports and Dashboards of the data and chart. (similar to PivotTable)
o Create data summary
o KPI
o Reports (daily, weekly, monthly
o Customized Reports
o Reports of records with similar info
I have similar experience in create network equipment inventory and network usage report for some company. free feel to contact me for information.