Hi,
I am trying to create a database with Microsoft Access for my new setup small shop to track my inventory, product ordering to suppliers, customers ordering to me and reporting.
At the end I would like to able to view/print reports as below:
- Order to supplier:
1. View/print reports by products code
2. View/print reports by date I ordered to my suppliers
3. View/print all ordering to suppliers based on the selected date
4. View/print the specific products ordered by which customers
- Order by customers
1. View/print all orders by a specific customer
2. View/print all orders by selected date
- Inventory Checking
1. View/print what are remaining in stock
2. View/print if product ordered from suppliers already arrived
3. View/print if product already delivered to customers
I am trying to come up tables as below:
- Product
- Inventory
- Ordering
- Supplier
- Customer
Since I am pretty new to this Microsoft Access, could you please advise if the 5 tables that I am trying to come up are good enough with the required reports about? Your comments on reporting requirements will also be very appreciated.
Thanks,
sanlen