Using MS Access/adding stock

Advertisement


Question
Hello Manish,
I am a very beginner with Access. I am trying to design a database to control stock.
I have a simple problem, but I can't find the answer when I google it.
I have a table with stock on hand. Each product has a unique batch number. I want to create a form in wich I can find the product by batch number with an empty field for quantity. In that field I want to be able to add a number. That number then should then be added to the quantity in my stock table. The next time I use this form, the field for quantity should be empty again for adding a new number etc.
I hope I explain it clearly.
Is there an easy solution for this?
Many thanks,
Hilde

Answer
Hi Hilde,

Usually in a Simply Inventory database you have Stock Inwards and Stock Outwards form. There will also be a Product Master table in which you will have the below fields

Product Name
Product Batch number
FixedStock - Stock to be strictly maintained
ActualStock - Actual stock on hand
Re_OrderStock - Quantity to be ordered every time you place an order for this item

The number in your case which you plan to create and add is the "Actualstock" in this case.

In your Stock Inwards form you must have a field to enter the quantity which you have received from your vendor. When you add this quantity that figure should get updated in your "Product Master table". so you will be actually updating the ActualStock by adding the quantity you have just received from your vendor.

The above scenario reverses when you sell items, out here your inventory from the "Product Master table" reduces.

You will need to follow this Simple Inventory Method in order to get started. Large enterprise Inventories have a separate stock table since it's linked with various departments in the organization. This isn't in your case, hence I suggested you to use a small Product table to control your inventory.

Your question to add a simple field also requires you to write the above bible...wink.

Hope this helps,

Best regards
Manish Batola  

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Manish Batola

Expertise

ALL MICROSOFT ACCESS DESIGN AND Development QUESTIONS which occur in a Access Projects Lifecycle. Can offer constructive help on Designing Advanced MS-ACCESS Applications such CRM/FRM(Follow-up),HSE-Health,Safety & Environmental Applications,School Management Systems,Hotel Software, Hospital Software,Chemicals Indenting,Import/Export,MRP - Manufacturing Resource Planning, ERP - Enterprise Resource Planning, Automotive Management Systems, Business Intelligence for Oil & Gas Drilling Operations, CRM,KPI- Key Performance Indicators,HealthCare, Hospitality, Constructions, Loyalty Clubs, Call Centers, Travel & Tourism, Educational Institutions, Industrial Strength Invoicing and many more being added every year.

Experience

29+ yrs in the Software industry with 23yrs completely dedicated on more than 350 Various Microsoft Access Projects from different Industry Sector[s]. I'm using Access ever since it was born.

Organizations
Worked in various multinationals catering from Aerospace, Oil & Gas etc.

Education/Credentials
-BSc - Computer Science -MSAP (Master in Software & Applications Programming) -BPRE (Business Process Re-engineering Engineer) -SQAE (Software Quality Assurance Engineer) -STIE (Software Testing & Inspection Engineer) -Project Engineer (Software Development)

Past/Present Clients
Catered to various clients in the following industries • Oil & Natural Gas (BPM/CRM/Access Development) • Sales / Marketing (CRM) • Automotive (Automobile Dealers) • Logistics & Indenters (Import/Export) • HealthCare / Hospitals • Hotels 3* & 5* • Restaurants • Construction Co’s (Project Billing) • Clubs (Concept Selling) • Shoe-Chains • Solicitors/Lawyers • Call Centers • Aerospace (Preventive Maintenance) • Travel & Tourism • Computer Vendors • Manufacturing • Music Shops • Education • Data Warehousing • Health,Safety & Environmental Applications • Mud Engineering • School Management Software

©2016 About.com. All rights reserved.