Need a data warehouse db.
used by 4-5 users.
1. We need to record incoming/outbound item (3 dock doors).
what the driver gives to the dock will by verified by what was received.
The item number given must match the number keyed in by the dock
(the driver types the items in = 12345678
his user name TOM BURK from drop down
The dock employee then types the item received
his user name Jim Taylor from drop down
a field in case of comments needed (ex. box 123011 was wet)
and then hits the VERIFY button .
The verify checks to see what the driver (delivery) and the dock (received) are the same.
If the same print a report 2 times with the items, delivery name, receiver name and time and date and comments
2. Once received the inside warehouse will add more info to the items scanned in
they will add : from what [url removed, login to view], the value and a comment field
The inside warehouse will then forward the items to area 1 or area 2 (need to record this).
Also the inside ware. will create new orders, so the will need to :
type in the item 55556666
only then the dock will be able to send out an item (must exist in the system prior).
any move. to the dock doors from area 1 and 2 will be done by the inside ware. fowarding the items to the dock.
We need to be able to print reports:
what was received by dock door 1, 2,3 and by all doors (also by date)
report of items sent to area 1 or 2 for inside ware.
a report from inside ware. on newly created items
and be able to track an item by its number.
In essence an items db tracking movement and creating reports.
This can be done in Access or ?