Purchasing Database Help

[Waindog24]

Hi All

I am new to this site. I have some basic experience with MS Access but struggle with the more complex elements.

I have recently joined a new company, there current purchasing and stock control system is using MS Excel. As I’m sure you will all appreciate this is causing the company a lot of pain. In particular, finding what orders have been placed on what customers and tracking Purchase Order Amendments and controlling documents submitted to suppliers and booking goods into our site. My role is the Quality Manager and I have picked up various issues already that I need to resolve quickly. However I don’t have the time or skill to develop one from scratch.

I know this is a bit cheeky, but does anyone have a database that they could send me to help get me started or point me in the direction where I could find one? Any help anyone could offer would be greatly appreciated.

Many thanks

 

[Uncle Gizmo]

Lots of schema's here:-
http://www.databaseanswers.org/data_models/index.htm

For example
http://www.databaseanswers.org/data_models/customers_and_purchases_data_warehouse/index.htm

http://www.databaseanswers.org/data_models/fuel_stock/index.htm

Inventory
Fuel Stock
Inventory and Equipment Maintenance
Inventory and Sales
Inventory Control (Files in Boxes)
Inventory Control (Manuals)
Inventory Control (Publishing)
Inventory Control (Retail Store)
Inventory Control (Sports Centers)
Inventory Control and Pricing
Inventory - Customers and POS
Inventory of Furniture
Inventory of IT Assets
Inventory of Plants in a Nursery
Inventory of Rental Equipment
Inventory of Servers
Inventory of Ship's Stores
Inventory of Tooling Equipment

Theres is also a Short downloadable Tutorial on creating a Data Warehouse using any of the Models

 

[jdraw]

waindog24,

There are many posts on many forums regarding Inventory Control, Stock Control. Google/Bing and you will find many. Often it is good to read the dialog in various threads --you get a "feel" for what the poster is asking, the issues etc, and some answer/options.

I'm going to recommend you watch this 26 min youtube video. It may give you a lot of real world info, rather than struggling through it first hand.

Good luck and welcome to the forum.

 

[Waindog24]

Many thanks for you help, I will look at your suggestions