UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Production Inventory, Access 2013    
 
   
johnnyenglish775
post Dec 19 2017, 10:13 AM
Post#1



Posts: 43
Joined: 27-November 17



Hello does anyone know of a template in Access or Excel for production and inventory that I can start with and modify as needed?

Thanks very much for any help or suggestions.
Go to the top of the page
 
doctor9
post Dec 19 2017, 10:59 AM
Post#2


Remembered
Posts: 18,324
Joined: 29-March 05
From: Wisconsin


Johnny,

Please keep in mind that inventory control is one of the most complex things you can try to handle with Access - it's very much an expert-level thing to create. It would likely be more cost effective to seek out ready-to-use software rather than trying to roll your own.

Having said that, you might want to read this article on Allen Browne's website that discusses how to handle stock takes and tracking inventory.

Hope this helps,

Dennis
Go to the top of the page
 
johnnyenglish775
post Dec 19 2017, 11:09 AM
Post#3



Posts: 43
Joined: 27-November 17



Thank you Dennis I am willing to give it a go. I have the time and want to learn. I will check out your suggestion thanks again.
Go to the top of the page
 
GroverParkGeorge
post Dec 19 2017, 11:21 AM
Post#4


UA Admin
Posts: 33,794
Joined: 20-June 02
From: Newcastle, WA


You can also get some ideas, I believe, from the classic Northwind database which has an inventory component, among others. My version has some modifications such as a revised naming convention.

Go to the top of the page
 
johnnyenglish775
post Dec 19 2017, 11:36 AM
Post#5



Posts: 43
Joined: 27-November 17



Would it be too much trouble to show what you mean with the modifications please?

Thank you so much for helping me
Go to the top of the page
 
GroverParkGeorge
post Dec 19 2017, 12:57 PM
Post#6


UA Admin
Posts: 33,794
Joined: 20-June 02
From: Newcastle, WA


I explained them on the page where the download is available.
Go to the top of the page
 
johnnyenglish775
post Dec 19 2017, 02:21 PM
Post#7



Posts: 43
Joined: 27-November 17



Can you please provide the link? I haven't been able to find it yet.

Thank you George

PS Sorry I found the link thanks for the suggestions
This post has been edited by johnnyenglish775: Dec 19 2017, 02:37 PM
Go to the top of the page
 
GroverParkGeorge
post Dec 19 2017, 03:50 PM
Post#8


UA Admin
Posts: 33,794
Joined: 20-June 02
From: Newcastle, WA


No problem. Good luck with the rest of your project.
Go to the top of the page
 
HiTechCoach
post Dec 20 2017, 08:55 PM
Post#9


UtterAccess VIP
Posts: 19,008
Joined: 29-September 03
From: Oklahoma City, Oklahoma


QUOTE
Can you please provide the link? I haven't been able to find it yet.


go to: http://www.gpcdata.com/Downloads.aspx

Scroll down to "GPC's Customized Northwind Sample Database " and click on it underlined text.
Go to the top of the page
 
« Next Oldest· Access Q and A· Next Newest »
 
Display Mode: Standard · Switch to: · Switch to: Outline

Track this topic ·Email this topic · Print this topic · Subscribe to this forum

Custom Search
RSSSearch   Top   Lo-Fi    23rd October 2018 - 07:53 AM