Question: Develop the Access database of Project (including tables, the relationship of tables and queries), and submit screen shots showing the Relationships view of the Access

Develop the Access database of Project (including tables, the relationship of tables and queries), and submit screen shots showing the Relationships view of the Access database, the datasheet view of every table in your Access database, and the design view and the query result of every query in the ACCESS database.

Develop the Access database of Project (including tables, the relationship of tablesand queries), and submit screen shots showing the Relationships view of the

Project Customer: Customer ID CName Address Classification Service: Service ID | Type Description Customer ID Consumed Units Per Month Due Date Pay Date Rate Per Unit Min Monthly Charge Sign: Service ID Customer ID Sign In Date Queries: 1. At the end of each month, a statement is sent to all the customers. The statement presents the total consumption by service and total $ amount due. Create a list that has the following information: customer name, customer's total consumption (by service), and total $ amount due. 2. To analyze how the business is doing, the management needs the following information: a. List the total number of new connections set per month during the last year. b. List the monthly income that was collected from domestic, commercial, and industrial customers during the last year. C. List the monthly income that was collected by electric, natural gas, water, and telecommunication services during the last year. 3. The management has realized that some of the customers have made it a habit to submit late payments. List the customers that always pay late. Project Customer: Customer ID CName Address Classification Service: Service ID | Type Description Customer ID Consumed Units Per Month Due Date Pay Date Rate Per Unit Min Monthly Charge Sign: Service ID Customer ID Sign In Date Queries: 1. At the end of each month, a statement is sent to all the customers. The statement presents the total consumption by service and total $ amount due. Create a list that has the following information: customer name, customer's total consumption (by service), and total $ amount due. 2. To analyze how the business is doing, the management needs the following information: a. List the total number of new connections set per month during the last year. b. List the monthly income that was collected from domestic, commercial, and industrial customers during the last year. C. List the monthly income that was collected by electric, natural gas, water, and telecommunication services during the last year. 3. The management has realized that some of the customers have made it a habit to submit late payments. List the customers that always pay late

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 Accounting Questions!

Q:

\f