I have a project that needs to be done in 24 hours. The task will involve designing 3 simple Access databases
Database 1 will hold invoices. It should have a user interface landing page like the first attachment with buttons for adding a new vendor, adding a new invoice, and adding a disbursement. The disbursements table should have a join to the invoices table for invoice number. The fields within the invoice table should be invoice date, invoice amount, invoice order number, invoice contract number, and a column for the folder directory that the invoice file itself is in. Within the disbursements table, there should be fields for disbursement date, disbursement amount, disbursement order number, and disbursement contract number.
Database 2 will hold contracts. It should have a similar user interface to the first attachment with buttons for contracts and modifications. The fields within the contract/modifications tables are specified in attachment two (see tblContracts).
Database 3 will have obligations. It should have a similar user interface to the first attachment with buttons for 1) enter obligation of funds, 2) enter de-obligation of funds, and 3) running a report that shows all outstanding obligations.