STOCK

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I want to get the current stock level of a product. So I deduct the total
quantity of it consumed in the tblUse from the total quantiy of it supplied
in the tblSupply. This works fine for now. I use Access 2002.

My fear however is what happens when records in the tables are their
thousands or hundreds of thousands? I suspect the program may slow down. Are
there techniques to avoid this from onset?
 
There is an Inventory Control template that you can use, when setting up a
new database in Access. You may want to look at that, and see if it would
fit your needs. It will set up a nice interface, and there are various forms
and reports that come with it. I think that the way you have set up your
database could cause problems for data entry, and a more organized approach
to setting up tables, queries, and forms would help you a lot.

Besides the templates that install with Access, Microsoft also has some on
their office website,

http://office.microsoft.com/en-us/templates/CT011359381033.aspx
 
Thanx Mnature for your suggestions.
I had indeed looked at the Inventory database in the past. My worry still
appears valid however as I have not detected how the program will not slow
down when it has to deal with 100,000 records of purchases, and 200,000
records of sales, (assuming that the design of the database split the tables
that way).

Is there a way to design the tables such that one can set aside or archive
very old records and still get accurate figures when one does calculations on
the tables?
 
Periodically (once a year, every few months, etc.) you should perform a full
inventory. When you do that, make an archival copy of your database, print
out a paper copy of your inventory, zero out accounts, input your current
inventory as starting inventory for the year, and start inputting data again.
Much of this can be automated with macros or some VBA programming. However,
this gives you an excellent excuse for doing some clean-up and clean-out of
your stock, rearranging shelves and boxes, and assessing the safety and
cleanliness of your operation. Most companies don't keep old information
close at hand for more than a year. As long as you have your archival
copies, and the paper copies, you can look up anything you may need from
prior years.
 
Back
Top