Inventory-Production-Sales

[TIM HAGEDORN]

I am currently using excel that tracks all of my incoming
items, inventory, production and sales. This is working
OK. I have a problem when I go to change the form (new
products or deleted products). I have to change the whole
workbook to ensure that cells haven't changed.

I know I can build and track my inventory in Access, but I
want to be able to put my sales and production in as
well. My goal is to be able to input production numbers
in everyday and have my inventory pull the appropiate
pieces (box, bags, labels) for that particular product. I
then want my "stock" of finished products to accumulate
based on my weekly numbers. I also want to input my sales
so my inventory of finished product also flucuates.


Thank you
Tim

 

[Gary Miller]

Tim,

It sounds like a well thought out goal. Do you have any
specific questions for the group?

Gary Miller
Sisters, OR

 

[TIM HAGEDORN]

Yes.

I don't know how to set this up.

-----Original Message-----
Tim,

It sounds like a well thought out goal. Do you have any
specific questions for the group?

Gary Miller
Sisters, OR




.

 

[Gary Miller]

Tim,

Access is a great flexible relational database program that
can certainly do everything that you outlined. What you are
looking to achieve will be a fairly involved project though.

How would you describe your Access skills and knowledge? I
have a feeling that they are not terribly strong or you
would probably know that there is no way that anyone could
tell you how to set all that up in one email answer to your
question. My apologies if I am mistaken there.

If you would like some help with your initial table
structures, that would be a good place to start, but you
will need to provide a lot of details on exactly what you
need . If you know zip about Access, in reality you have a
big learning curve to be able to put together a combination
sales tracking, inventory and MRP program from scratch.

Take a look at the Northwind sample database that comes with
Access to see some examples of how things are structured and
coded.

If you are a newbie and are serious about creating this,
looking for an Access Consultant/Programmer could be a very
wise move, at least to get you started.

Gary Miller
Sisters, OR

 

[Terry]

Tim,
How are you gathering the information you are tracking on
your spreadsheet?

Terry