Northwind Database Accuracy

Manning

Registered User.
Local time
Today, 06:24
Joined
Sep 12, 2005
Messages
19
I am just wondering how good of an example Northwind is?

I have been playing with the database and noticed that the number of units in stock doesn't decrease after I have created an order. I am trying to build an inventory database and would like this feature.

Am I wasting my time with Northwind?
 
Creating an order would not necessarily decrease the units on hand. I can't be sure how far Northwind takes you, but in a real world scenario, the inventory decrease will only happen after you process the sales order (ie. actually fill the order and ship the units). During this process, an invoice is produced and the inventory is reduced at the same time.

Northwind is, in my opinion is an excellent way of understanding how to program in Access. It is not the only way, but I surely learned plenty from it.
 

Users who are viewing this thread

Back
Top Bottom