Question: Create an account receivable system database for the ABC College Faculty Dinning Club, named, Final (your Last Name) Create the tables Members: MemberlD (text, Primary

 Create an account receivable system database for the ABC College Faculty

Create an account receivable system database for the ABC College Faculty Dinning Club, named, Final (your Last Name) Create the tables Members: MemberlD (text, Primary Key), Name (text), Address (text), Phone (text) Invoices: IavoiceNumber(autonumber, Primary Key). QrderDate(date/time) Memberll. ItemNo(text)Quantity(number) TotalPrice (currency) Paid(yeso), Amount paid (currency)datePaid (date) Enter 3 members and 8 invoices. Make up your own data. Pretend that 6 invoices have not been paid and only 2 have been paid. The system shall include a main switchboard with the following features (items) Enter new Invoices. (note: when the form is opened for adding new invoices it should be a blank form.,) Enter payment received. (This is a parametric form, linked to the Invoice table 1. 2. The prompt shall be "Enter Invoice number", The form opened shall be the invoice form with the same invoice number in edit mode. If the amount of payment is correct, the cashier will change the "Paid" value from No" to "Yes". If the amount of the payment is different from the amount shown on record, the payment will not be accepted and will be returned to the payer.) 3. Print unpaid bills report (The report shall include Member ID, Invoice Number, Order Date and Total Price). (The report will only show unpaid bills (Paid-No) (If there are more than one unpaid bills of the same person, the sum of unpaid Bills will be totaled.) Create all the queries, forms and switch board items as required for the system. Create an account receivable system database for the ABC College Faculty Dinning Club, named, Final (your Last Name) Create the tables Members: MemberlD (text, Primary Key), Name (text), Address (text), Phone (text) Invoices: IavoiceNumber(autonumber, Primary Key). QrderDate(date/time) Memberll. ItemNo(text)Quantity(number) TotalPrice (currency) Paid(yeso), Amount paid (currency)datePaid (date) Enter 3 members and 8 invoices. Make up your own data. Pretend that 6 invoices have not been paid and only 2 have been paid. The system shall include a main switchboard with the following features (items) Enter new Invoices. (note: when the form is opened for adding new invoices it should be a blank form.,) Enter payment received. (This is a parametric form, linked to the Invoice table 1. 2. The prompt shall be "Enter Invoice number", The form opened shall be the invoice form with the same invoice number in edit mode. If the amount of payment is correct, the cashier will change the "Paid" value from No" to "Yes". If the amount of the payment is different from the amount shown on record, the payment will not be accepted and will be returned to the payer.) 3. Print unpaid bills report (The report shall include Member ID, Invoice Number, Order Date and Total Price). (The report will only show unpaid bills (Paid-No) (If there are more than one unpaid bills of the same person, the sum of unpaid Bills will be totaled.) Create all the queries, forms and switch board items as required for the system

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!