Build a Microsoft Access Database
Budget: $30 – $250 USD
This is a relatively simple MS Access Database.
There will be three primary tables; products, customers and suppliers.
From these tables and using forms, a number of reports can be generated; quotations, invoices, proforma invoices, packing lists, purchase orders.
I have attached an MS Database for the fields for the 3 primary tables. Also attached a brief outling the system architecture as well as the forms required to generate each individual report.
Ideally I would like this to be done with minimal VB scripting and just using simple queries/relationships within MS Access. But if this is not possible then happy to be advised otherwise.
There will be three primary tables; products, customers and suppliers.
From these tables and using forms, a number of reports can be generated; quotations, invoices, proforma invoices, packing lists, purchase orders.
I have attached an MS Database for the fields for the 3 primary tables. Also attached a brief outling the system architecture as well as the forms required to generate each individual report.
Ideally I would like this to be done with minimal VB scripting and just using simple queries/relationships within MS Access. But if this is not possible then happy to be advised otherwise.