Develop the Access database of Project (including tables, the relationship of tables and queries), and submit screenshots 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. Please show the queries design table but not the SQL sentence.

Transcribed Image Text:

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. b. List the total number of new connections set per month during the last year. 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. Customer: Customer ID Service: Service ID Sign: Type Description Service ID CName Customer ID Project Consumed Units Per Month Customer ID Address Due Date Pay Date Classification Rate Per Unit Sign In Date Min Monthly Charge 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. b. List the total number of new connections set per month during the last year. 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. Customer: Customer ID Service: Service ID Sign: Type Description Service ID CName Customer ID Project Consumed Units Per Month Customer ID Address Due Date Pay Date Classification Rate Per Unit Sign In Date Min Monthly Charge

Answer rating: 100% (QA)

CREATE TABLE Customer CustomerID INT NOT NULL PRIMARY KEY ... View the full answer