Inventory Management Tool Using Excel/Access


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.


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.


Option 1 - Choose excel as a backend and design custom forms

Option 2 - Choose Access as backend and use infopath forms


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


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)


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 !!

Beceriler: Excel, Microsoft Access, Yazılım Mimarisi, Visual Basic

Daha fazlasını görün: inventory management system using, inventory management report using, inventory management project using swing, free inventory management database using open office, risk management tool forex excel, create royalty report using excel access, inventory management application using cnet, inventory management software using, inventory database samples using microsoft access, free inventory management software using, developing hotel management sytem using microsoft access, inventory management system using vbnet sqlserver, article inventory management system using sms philippines, inventory management system using php sql, inventory management application using visual basic oracle books, develop inventory management application using visual basic, database management project using excel, design interface inventory management system using vbnet

İşveren Hakkında:
( 4 değerlendirme ) Pune, India

Proje NO: #15951920

25 freelancers are bidding on average $93 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, Daha fazlası

in 4 gün içinde400$ USD
(229 Değerlendirme)

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 Daha fazlası

in 15 gün içinde999$ USD
(48 Değerlendirme)

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 Daha fazlası

in 2 gün içinde30$ USD
(21 Değerlendirme)

I have a lot of practical experience in Excel. Including the development of databases and User Forms. Your task is clear to me and I am ready to execute the project for the 250 USD. For example, I send a screen of one Daha fazlası

in 5 gün içinde250$ USD
(41 Değerlendirme)

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.

in 3 gün içinde30$ USD
(34 Değerlendirme)

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 Daha fazlası

1 gün içinde 20$ USD
(7 Değerlendirme)

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 Daha fazlası

1 gün içinde 25$ USD
(3 Değerlendirme)

we are enthusiastic and expert in meeting deadlines. your satisfaction is our first priority .we will be having fun working together. price are negotiable,experienced projects can be shown as screenshots on demand Daha fazlası

1 gün içinde 25$ USD
(1 Değerlendirme)

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 Daha fazlası

1 gün içinde 25$ USD
(3 Değerlendirme)

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 Daha fazlası

in 2 gün içinde10$ USD
(3 Değerlendirme)

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 Daha fazlası

in 3 gün içinde20$ USD
(1 Değerlendirme)
in 3 gün içinde25$ USD
(1 Değerlendirme)

Please share detailed requirements of the project. I have placed a higher bid as it will require a lot of work

in 10 gün içinde55$ USD
(1 Değerlendirme)

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 Daha fazlası

in 3 gün içinde20$ USD
(1 Değerlendirme)

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

in 2 gün içinde30$ USD
(0 Değerlendirme)

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

in 3 gün içinde35$ USD
(0 Değerlendirme)
in 5 gün içinde30$ USD
(0 Değerlendirme)

I would choose excel, as it's easier for me to manage data in excel while creating easy to use sheets that allow the user little headache. I consider myself an excel master, currently working for a $1B bank as a busine Daha fazlası

1 gün içinde 30$ USD
(0 Değerlendirme)

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 Daha fazlası

in 3 gün içinde25$ USD
(0 Değerlendirme)
in 5 gün içinde25$ USD
(0 Değerlendirme)