X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Coal Inventory Database, Access 2016    
post Nov 20 2019, 01:19 AM

Posts: 13
Joined: 8-May 19

I am willing to design Coal Inventory Management but still not sure how to start?

What I have?

1- Trucks coming to plant via automatic weighbridge - Data is downloadable in excel table.
How to integrate this data in MS Access ? Giving access to table to copy excel tables is not secure.

2- Sampling Carried out from random trucks.

3- Stacker Re-claimer Data.
Total Coal Stacked in Coal Yard and Reclaimed for used in Plant. [Stacked - Reclaimed] = Total Inventory ( Dead Stock + Running Stock )
Coal Area has 2 yards where Coal is stacked and can be reclaim with FIFO Method - ( First In First Out )

4- Query to be synced with another Access Database for report generating.

I am beginner but manage to design plant Database now I am starting this one and have no idea with Inventory management of solid materials. Anyone have sample or help me with Database structure.
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    18th February 2020 - 08:11 PM