peskywinnets
Registered User.
- Local time
- Today, 09:20
- Joined
- Feb 4, 2014
- Messages
- 576
I really want to learn access...& I've set myself a simple task (which will really help my fledgling business predict how much stock I need to hold based on recent sales - stock prediction is a nightmare so this will really help!)
I've some sample sales for about 8 months in spreadsheet form, structured with columns like this....
Order date product quantity sold
What I really need is an access database filled with that data, then to be able to run a report, something like this....
User enters a date period (from/to) to drill down on the data
User enters number of days stock holding required (how much stock I need to hold to satisfy the chosen number of days)
Which then gives the following output results....
Total quantity sold for each & every SKU in the database.
Average Units sold per day for each & every SKU in the database.
How many SKUs will be needed for the chosen number of days stock holding for each & every SKU.
To explain, let say over a 20 day period, I sold 2 items per day of a given product & I want to know how much of of this item I need to order to satisfy 180 days stock holding.
Example:
User selected date period = from 1 Jan 2014 to 20 Jan 2014
No of days stock holding required = 180
report result...
Total quantity sold = 40
Average units sold per day = 2
How many SKUs will be needed for the chosen number of days stock holding = 360
Bearing in mind I have little access database experience (But a fair amount of excel experience) ...with a little coding in Basic coding small MCUs (PICs), how long would it take me?
Can anyone help get me started (see sample data attached) ...I'm figuring I can't be first person who require a stock ordering predictor so there's probably a simple database that I can use/modify somewhere or other
Many thanks,
pesky.
I've some sample sales for about 8 months in spreadsheet form, structured with columns like this....
Order date product quantity sold
What I really need is an access database filled with that data, then to be able to run a report, something like this....
User enters a date period (from/to) to drill down on the data
User enters number of days stock holding required (how much stock I need to hold to satisfy the chosen number of days)
Which then gives the following output results....
Total quantity sold for each & every SKU in the database.
Average Units sold per day for each & every SKU in the database.
How many SKUs will be needed for the chosen number of days stock holding for each & every SKU.
To explain, let say over a 20 day period, I sold 2 items per day of a given product & I want to know how much of of this item I need to order to satisfy 180 days stock holding.
Example:
User selected date period = from 1 Jan 2014 to 20 Jan 2014
No of days stock holding required = 180
report result...
Total quantity sold = 40
Average units sold per day = 2
How many SKUs will be needed for the chosen number of days stock holding = 360
Bearing in mind I have little access database experience (But a fair amount of excel experience) ...with a little coding in Basic coding small MCUs (PICs), how long would it take me?
Can anyone help get me started (see sample data attached) ...I'm figuring I can't be first person who require a stock ordering predictor so there's probably a simple database that I can use/modify somewhere or other
Many thanks,
pesky.