Inventory Management Tool Using Excel/Access

Closed Posted 6 years ago Paid on delivery
Closed 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 !!

Excel Microsoft Access Software Architecture Visual Basic

Project ID: #15951920

About the project

23 proposals Remote project Active 6 years ago

23 freelancers are bidding on average $98 for this job

schoudhary1553

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

$400 USD in 4 days
(260 Reviews)
7.5
zu02

Hello, sir I saw your project and analyze your requirements. I don't want to waste my and your time for demo versions. Please look at my portfolio here and you will guess how I can code your Inventory Management To More

$999 USD in 15 days
(54 Reviews)
6.2
florinserban

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

$30 USD in 2 days
(21 Reviews)
5.2
crypthne

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.

$30 USD in 3 days
(35 Reviews)
4.7
sloker18

I would like to present myself as a candidate for your project. I am a programmer proficient in Microsoft applications, an Excel form will be created for user input and bring up existed inventory to modify, and code to More

$20 USD in 3 days
(27 Reviews)
4.3
VBAautomation

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

$20 USD in 3 days
(10 Reviews)
4.2
reedsystems

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

$25 USD in 1 day
(5 Reviews)
3.0
sjDavidson

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

$25 USD in 1 day
(4 Reviews)
2.6
Nicecreator

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

$20 USD in 1 day
(8 Reviews)
2.3
garykirsten

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

$10 USD in 2 days
(3 Reviews)
1.5
rubenpereira70

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

$35 USD in 3 days
(0 Reviews)
0.0
jdace1231

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

$30 USD in 2 days
(0 Reviews)
0.0
kenmwhite

I will be more than happy to complete a poc for this project. I have some additional questions for the overall project. Is this going to be part of a POS system? That is just one. I would build this with a access b More

$25 USD in 3 days
(0 Reviews)
0.0
khuramonline

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

$29 USD in 1 day
(0 Reviews)
0.0
Zaki2015

Hi I shall let provide you a fully functional demonstration (as PoC) of a similar system available with me. It has all the features and functionalities you are looking for. Any variances or additional requirements cou More

$35 USD in 3 days
(0 Reviews)
0.0