Hi,
The data base in MS Access is to assist in shops inventory.
I have created set of tables with relations in Access using existing data.
I would need someone to do the following
1. Check existing structure of table, relations and do required changes for database to operate correctly.
2. Create the following forms and printable reports for
a. Purchase Order
b. Sell invoice
c. Transfer reports (transfers of products between shops)
d. Loss reports
3. Create the following queries and printable reports
a. Purchase orders in date range with selection for: all and selected shops
b. Sale invoices in date range with selection for: all and selected shops
c. Transfer reports in date range with selection for: all and selected shops
d. Loss reports in date range with selection for: all and selected shops
c. Inventory: total and selected shops.
Existing tables:
Branches (shops)
Customers
Employees
Inventory / transactions
Loss records
PO’s
Products
Products Category
Sell invoices
Suppliers
Transfer Reports_IN
Transfer Reports_OUT
Required layout of forms and reports will be provided.
Thank you for your bids.