ACCESS FEED: RE: [MS_AccessPros] Help with inventory access database

Selasa, 06 Agustus 2013

RE: [MS_AccessPros] Help with inventory access database

Something you might consider instead of separate purchase and sales tables
is an inventory transactions table with purchases being represented by
positive quantities and sales, by negative quantities. The net of purchases
and sales is your quantity on hand. However you set it up, you will also
have to allow for periodic inventory adjustments to bring calculated
quantities on hand into line with physical counts.

Glenn

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Gina Whipp
Sent: Tuesday, August 6, 2013 1:56 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Help with inventory access database

I would start with the Northwind database included with every version of
Access. Should get you started...

Gina Whipp
Microsoft MVP (Access)

http://www.access-diva.com/tips.html

From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Jorge
Muralles
Sent: Monday, August 05, 2013 6:19 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] Help with inventory access database

Hello everyone, I need some help, I am wondering who can help.

I need to see a sample database of an inventory application.

I have an idea:

Tables: categories and products

Tables: Purchase and sales.

I need each transaction on the purchase table to increase the quantity on
hand on my products table.

I need each transaction on the sales table to debit the quantity on hand on
the products table.

You folks get an idea of what I am trying to do.

Does anyone have a sample database I can use to start up?

Thank you very much.

Jorge Muralles

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]