MS Access database with forms and script
$30-250 USD
Paid on delivery
This project is to develop a simple system that will help me manage following for my store,
Inventory
Sales
Administration
Inventory
Inventory management and verification are the main reasons for developing this system. Each piece of inventory will be tagged with an asset barcode, so that I can track where each piece is and when it was sold at what price.
Also need to be able to generate a barcode in a query and report. See [login to view URL]
Each week, inventory will be scanned, and a report generated to figure out variations between physical stock and what the system says.
Inventory dashboard and reports like aging, velocity etc.
Sales
Should be able to create a customer from the sales order screen.
Sales order will be created using customer master and product master.
When order is saved,
Reduce stock based on asset code.
Update sales totals to customer master once sales order is save/closed. This will be a yearly total based on the date when the sales order is saved.
Some item level details will be copied to the asset table when the order is confirmed.
Bring up a print screen
Send pdf of the sale order if a customer email is available.
Administration
Need Log-in and user management and security protocols based on used profile.
Sample data will be provided to help with the development and testing efforts.
Open Questions as this stage:
Saving pictures of the product.
Database management tools (backup, compacting etc)
Project ID: #38045203
About the project
18 freelancers are bidding on average $196 for this job
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More
Ready to develop the required MS Access inventory management application. As round figure will breakdown the required project to 15 points, each $30 milestone. I'm professional, certified, check my profile link, copied More
Dear Sir, I am expert in MS Access. I can do it. Please take a look at my reviews. Thanks......
I have been working on various projects with Microsoft Access as a powerful tool for database management and programming. In fact, I have created extensive applications similar to the one you're envisioning that dealt More
Hi there! As a seasoned software developer with a deep mastery in programming languages like SQL and Visual Basic and a rich background in .NET and .NET Core, I'm confident in my ability to deliver a robust MS Access d More
With over a decade of experience in database programming, Microsoft Access, and software architecture, I have honed my skills to expert level. I am confident that my ability to efficiently develop comprehensive and use More
My experience, appreciation of VBA places and my understanding of sales and asset management places me in a better position to execute this project successfully and on time.
As an AWS Certified professional with a demonstrated skillset in Data Integration and Visualization, I am confident that I can deliver an outstanding MS Access database solution for your store. Not only do I have exten More
I have 15 year of experience in vb and ms access database application development. developed many like , Inventory management system, POS, Billing System.
Hi, I would love to help you execute your project. I have 27-plus years of experience in Software development/Web development including PHP and Laravel/DBA/QA Analyst/Project Management at Strand Management Solutions More