Hi,
I am a newbie to Access (well the last time I used it was at school 15 years ago!!) and I want to create a database to track where stock is in a warehouse but I don't know where to begin. I have had a little play this afternoon and have managed to create tables for the info I want to capture but then when I try to create a form so that I can capture the data I get lost, at this point I realised that the tables I created would not capture the info I needed.
My Task.
To create a database to track stock items in a warehouse, I have all of my warehouse shelves uniquely labelled. When stock comes in I want to give that item unique ID, then add it to a pallet number, and link it to a stock location. I then want to be able to edit the location if the item is moved or sold and also query the database to find items easily.
What I need.
I need someone to point me in the right direction of what tables/forms/queries etc I need to be creating and hints on how to go about doing it.
Thanks for any advice given
John
Bookmarks