inventory

[eiron]

good day to all members
im a newbie
this is my second post that still not solved.
please any one help me
i just need to have a sample access form sample for inventory
i guess this is hard to understand.


i dont know how to start this
but i am realy novice in access
i just want to make this inventory access
it will be called parts masterlist
its like that the db will be in a form view
like i have a box main menu there with multiple button that will show the form
on the first button on main menu it will be the master list of the parts
part number , description location and actual stock on hand..this will be on the first button, that cannot be change by the user only for viewing the stock, where there is a button inside for querry search that when type the part number it will show the details of that part.
and on the second button will be the adding and subtracting quantity..
where inside will be a button of add quantity and subtract quantity..
where there is also a button for search a part then a button for adding and subtracting quantity,
and if posible a query for the history of its part.
like if possible another button to put the history of that part where it was used and when it was withdraw from the ware house..that when i put the starting date and end date will show all the data of that parts in that date..
hope i am clear my friends
please any sample form will be good, i will all try and modify for the needs..please help this newbie and willing to learn more and share to other what i will learn..
hoping for all help
any suggestion can be send to me or even post here then i will dl the sample..
pleaseeee
thanks in advace

[HMEpartsmanager]

good day to all members
im a newbie
this is my second post that still not solved.

Did you follow the links in your other post with the reply in it? Those links will help you understand how the tables need to be setup and what you need to know.

That was a good starting point to read. It is important to understand how the database works, as you will have to adapt and/or repair this database you create. Even if you find a ready made database that is 'close' to what you want, you will still have to know how to maintain it.

Look again at your other post, and follow those links, it should prove useful.

[June7]

You might explore this template Inventory database http://office.microsoft.com/en-us/te...ai:TC010206882|

[eiron]

ok ..now i think i will make a data base from a scratch,,hope guys youll help me along doing this from the start..after i made the data base and some stuff..and if i need something to ask i will post again here, then help me figure it out..i will try to make it from the scratch..then post what is the development
thank you guys

[HMEpartsmanager]

ok ..now i think i will make a data base from a scratch,

I have done this, and it was a great learning experience. Not only are you building something you need, but you will know your database inside and out.

Keep in mind that there are different parts to building the database. There are forums here that can help as you approach stumbling blocks.

Database Design & Table Development will be the meat of your database, be prepared to really tackle this area of your creation. Believe me, having the right tables and design will save you headaches later. There have been many people who have started where you are, so have fun it.