Does each customer order one type of item at a time, or do your customers order a range of parts or items from you all at the same time?
Do you have just one supplier for each part you stock?
But all this is a more advanced topic really, so we’ll just show you the simple way for now using tables with more basic goals.
Set up fields within the tables Within a table, information is held in “fields”.
You can also follow this tutorial using our You Tube video that explains each step and provides demonstrations to help you do it yourself; click on the link above to open the video in a new tab/window.
Before you get started Please note that in order to follow this walkthrough, or run the free finished database linked above, you must have a full version of Microsoft Access installed on your computer.
Basically a field is the specific piece of information about the thing the table is responsible for.
But for other tables where this may not be the case, we can invent ID numbers or codes for internal use in the system to make sure it can uniquely identify any entry in any table.If you would like to try and create your own stock control database then read on...In this article we'll guide you through some step-by-step instructions for creating your own stock management database or stock control system in MS Access.A well-designed database will be simpler to maintain, and to adapt later on if your requirements alter.For example, the simple database we are creating needs to be able to: Think about the details of the way your business works.We have also included some hints and tips based on our many years of experience creating Access databases for real businesses.