A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2000 inventory template



 
 
Thread Tools Display Modes
  #1  
Old February 20th, 2008, 07:00 PM posted to microsoft.public.access.tablesdbdesign
Adan
external usenet poster
 
Posts: 4
Default Access 2000 inventory template

I'm working on a project and have very agrewssive time restrains so don't
have time to create from scratch. I need an access 2000 database template
for inventory planning. The data base will have products and Min and Max
levels that vary for each of our warehouses. I need it to lookup available
and in-transit qtys for each product at each warehouse from 2 excel sheets
that will be posted daily, one sheet has the available qty and the other the
in-transit qty for each product at wach warehouse. Based on the available +
in-transit qty, the database will create a re-stocking report to list every
product that is at or below min and the re-order qty to bring it up to max.
I need it to also lookup the available qty at our distribution center from
another excel sheet and identify which replenishments orders can or cannot be
filled. Is there any place where I can find a template that will at least
have some of the ground worj already done for this database?
  #2  
Old February 21st, 2008, 05:00 AM posted to microsoft.public.access.tablesdbdesign
M.L. Sco Scofield
external usenet poster
 
Posts: 9
Default Access 2000 inventory template

Adan,

For 2000 templates, go to
http://office.microsoft.com/en-us/te...aspx?av=ZAC000.


For 2003 templates, go to
http://office.microsoft.com/en-us/te...aspx?av=ZAC000,


Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005
Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
This email made with 100% recycled electrons!
Miscellaneous Access "stuff" at www.ScoBiz.com


"Adan" wrote in message
...
I'm working on a project and have very agrewssive time restrains so don't
have time to create from scratch. I need an access 2000 database template
for inventory planning. The data base will have products and Min and Max
levels that vary for each of our warehouses. I need it to lookup
available
and in-transit qtys for each product at each warehouse from 2 excel sheets
that will be posted daily, one sheet has the available qty and the other
the
in-transit qty for each product at wach warehouse. Based on the available
+
in-transit qty, the database will create a re-stocking report to list
every
product that is at or below min and the re-order qty to bring it up to
max.
I need it to also lookup the available qty at our distribution center from
another excel sheet and identify which replenishments orders can or cannot
be
filled. Is there any place where I can find a template that will at least
have some of the ground worj already done for this database?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.