Inventory Management Tool Using Excel/Access
$10-30 USD
Paid on delivery
LONG TERM REQUIREMENT:
I am envisioning a product that'd manage inventory of small business. The end user would be small business owner/retailer who is currently using manual ledgers to get his work done.
ESSENTIALS:
1. Need to provide form based interface for data input.
2. Reporting mechanism for e.g. number of products sold between a date range, no. of stocks left for a particular product etc
3. The tool should be scalable run time for e.g. shopkeeper can add new products/update prices etc
4. The tool should be desktop based and simplistic. We really dont want too much technicality so that it goes beyond understanding of basic computer literacy. For e.g. we don't want to build a tool on LAMP platform and push end user to new IT management tasks like hosting, server management etc
At this stage I am only looking for a PoC. (proof of concept/demo)
However, how this product would be technically implemented is yet to be decided.
FEW IDEAS
Option 1 - Choose excel as a backend and design custom forms
Option 2 - Choose Access as backend and use infopath forms
HERE IS WHAT I EXPECT IN RESPONSE
a. tell me your understanding of this tool.
b. tell me tools/technologies you'd use to create this
b. share any examples of something similar you've done before
WHAT I'd DO
i. if your idea appeals to me, I would award this small project to you to get a poc done.
ii. poc would essentially include designing a form (based on technology you suggest) and making it to talk to backend (based on your suggestion)
NEXT STEPS
i. if the POC works out well, I'd create a bigger project (around $1000) to get a complete product created.
Please let me know your thoughts.
Thank You !!
Project ID: #15951920
About the project
23 freelancers are bidding on average $98 for this job
Greeting, I have understood your Inventory Management Tool Using Excel/Access task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel, More
Hi, My name is Florin, I'm from Romania and I am a database applications developer (with a degree in database administration). Based on the project description, I would propose the following solution. We can buil More
I have extensive knowledges in MS Access and Excel, especially in VBA and any other programming tools related to VB which include VB.NET. I'm sure can work and finish this project as requested.
An Access database would be best for this. My name is Deepak. I work as a full-time MS Access Programmer. I have spent the past 4+ years doing full automation, building custom applications, number crunching, and datab More
Hi, your request caught my attention. From your description, I can deduce that you need an inventory system built with either MS Access or MS Excel. I completed exactly a project of such requirement with MS Access, y More
I have create desktop tools for multiple companies for the last 20 years. From your description I would use MS Access, however we would need to know how many users to avoid any limitations, and also would this be us More
Dear Customer . i understand your requirement and will Provide sample work within 1 hours. trust me and Hire me . I have complited many data analytical work high quality and accuracy last five year. using mic More
A. Forms will be created for creating new product, updating product details, enter sold product details B. Will use excel vba macros with excel as backend. sheets INVENTORY, SOLD with details Relevant Skills and Expe More
Hello my friend, I am a highly skilled database programmer with vast experience in ms access and sql server. I am sure you would love the product if you assign me this project. Regards, Ruben
All you need is a data entry form where in you will store the data to your ms access database then pull data like a report with specific queries
I have already developed same solution for shops in MS Access. You can check portfolio section of my profile to see some screenshots. Price for you is within your budget and product can be delivered as and when demande More