Inventory Management Tool Using Excel/Access

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, Microsoft Access, Software Architecture, Visual Basic

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 Tool Using Excel/Access. I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career before. I am senior Access/SQL/VB /Excel developer since 1997 and I can write for you a user-friendly program using MS Access/Excel . I am not engaged with any other project right now and I will work for 8 hours day for this Job. You can look into my portfolio here for my software screens for my previous work. Do revert me back if you feel like I am a suitable candidate for this Job and discuss further details. Thank You and Regards, Zura

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 build a simple and user friendly application that will consist of two files: - a database file to store the records (Access) - an interface file that will be linked to the database and will handle all queries. Several advantages of this solution type are: - the application does not require installation, it can be copied on the target machine and run. - the user does not work directly in the database tables, hence the data is safe to accidental edits. - the interface can be customized in any way: font type, color and size, field arrangement etc. In its minimum version the application should include: - product management - stock management - reports. Based on purchase orders, products are added in stock at a specific time and date, with a purchase price. Based on sales orders, products leave stock at a specific time, date and price. Using purchase and sales, we can produce a wide array of reports: current inventory, products purchased/sold in date range, best selling products etc. We can add user management, with user roles, for larger businesses for example. This will help keep track of who sold a product, who changed a price and so on. I can provide a simple demo for the app, if required. Thanks! Florin

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.

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 generate reports as needed. I am ready to start immediately,, please send me message to discuss more in detail to proceed.

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 database management for MS Office businesses, and I am keen to continue developing my career in the field of data analysis, Access Database, Excel and VBA programming.   My expertise relies on: 1.         Solid knowledge of table/query design, form/report design, and automation utilizing VB modules. 2.         Expertise in debugging developed VBA codes and fixing them. 3.         Having Experience in Support Access and Excel application with SQL Server backend  4.         Experience in Identifying and understanding the requirements of the clients with respect to the database administration system that needs to be developed. 5.         Well versed with database concept and experience in using SQL statements for data validations.  6.         Have experience in developing Access databases and applications using VBA for data transformation and validation projects. 7.         Experience in design, automation, and solution development of various applications, including integrating existing user-developed Access databases into SQL server back-end and modifying front-end screens with professional UI interfaces. 8.         Developing data models and designing the database architecture as per the given instructions and modifying them to accommodate the system requirements. Installing several security features and granting access levels as per the user privileges set by the client to ensure maximum protection of the database system and avoiding theft of valuable data. 9.         Collecting data from various sources like QuickBook, Excel, MySQL, SQL, Azure and Manipulating, cleansing & processing data using Excel, Access, Macro, VBA, and SQL. 10.       Creating attractive and dynamic Reports in MS Access. 11.       Implementing Google Charts, Map into MS Access Forms, Reports (both offline and online).

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, you can check it out in my portfolio. I can also show you more samples if needed.

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 used over a network. We can also use infopath forms if entry will be web based. The database would have easy to use button driven forms with reports based upon the requirements specified at the time. I have written, inventory management systems, Patient data systems, garden centre stock managements systems as examples over the last twenty years so I believe I will have the experience you need when it comes to the full project. Please don't hesitate to contact me if you have any questions.

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 microsoft word,microsoft excel perfectly. i can start now your project according to the your guide line with Confirmation.

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 Experience Sheets will contain product details like name, id, stock, added date, sold details

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 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 back end - that will give it scalability. The front end can be either web based or we could build a VB screen to handle the functions. I would envision it needing a product entry form, a search product function to locate specific inventory items, update item detail capability. Update inventory levels - various ways to enter, possible product delivery entry - product sale entry. I excel at building interfaces for the known tech minded end users. Hope you will consider me. Thank you. Ken

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 demanded.

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 could be customized in a very short period of time. The proposed database application (in MS Access/VBA, ACCDE format) will run in any version of MS Office (on or above 2007), and in any version of MS Windows (on or above 2007). By default it supports both 32 and 64 bits windows, and ready to be configured as Single user application (Single PC) or as a Multi-user application for multiple shared PC’s (through LAN), with secured user privilege/access management. I have more than 20 years of experience in design and development of BESPOKE database applications. As a ready reference you can please see a few samples (screenshots with brief features) in my portfolio here, and more could be shared once we initiate a discussion. If it appears okay to you please do not hesitate to write me back so that we can explore the possibilities. Thank you for reading, and Best Regards Zak