Question: this needs to be done on microsoft access, I am a beginner for this and need urgent help, pls and thank you When you complete

this needs to be done on microsoft access, I am a beginner for this and need urgent help, pls and thank you  this needs to be done on microsoft access, I am a
beginner for this and need urgent help, pls and thank you When
you complete the test, upload your Access database file with the tables,

When you complete the test, upload your Access database file with the tables, report, and queries specified below. The data below shows for each invoice, its number, the invoice date, the amount billed, and the billed customer's last name, company, and department: Invoice 7234 on 3/1/21 for $140 billed to customer Harris at GE, Finance Department. Invoice 8946 on 3/2/21 for $500 billed to customer Doby at IBM, Accounting Department. Invoice 9103 on 3/2/21 for $430 billed to customer Harris at GE, Finance Department. Invoice 9280 on 3/2/21 for $800 billed to customer Collins at IBM, Marketing Department. Invoice 9338 on 3/3/21 for $650 billed to customer Doby at IBM, Accounting Department. Note: Each invoice is billed to one customer. Suggestion: Design the schema on paper before starting work on the Access Database. Using Microsoft Access: ge 101 258 Flight Using Microsoft Access: 1. (40 points) Set up the two tables and their structures. 2. (15 points) Link the tables, ensuring data integrity. 3. (5 points) Enter the data. I 4. (10 points) Produce a report to show each customer's name and company and their individual invoice numbers with the amount billed on each invoice. 5. (10 points) Create the query to show all customer names and their companies who have individual invoice amounts over $400. Name the query: InvoiceAmount. 6. (10 points) Create the query to show the departments at IBM that were billed on 3/2/21. Name the query: Departments 11 7. (10 points) Create the query to show the total amount billed to each company. Name the query: Total. When you complete the test, upload your Access database file with the tables, report, and queries specified below. The data below shows for each invoice, its number, the invoice date, the amount billed, and the billed customer's last name, company, and department: Invoice 7234 on 3/1/21 for $140 billed to customer Harris at GE, Finance Department. Invoice 8946 on 3/2/21 for $500 billed to customer Doby at IBM, Accounting Department. Invoice 9103 on 3/2/21 for $430 billed to customer Harris at GE, Finance Department. Invoice 9280 on 3/2/21 for $800 billed to customer Collins at IBM, Marketing Department. Invoice 9338 on 3/3/21 for $650 billed to customer Doby at IBM, Accounting Department. Note: Each invoice is billed to one customer. Suggestion: Design the schema on paper before starting work on the Access Database. Using Microsoft Access: ge 101 258 Flight Using Microsoft Access: 1. (40 points) Set up the two tables and their structures. 2. (15 points) Link the tables, ensuring data integrity. 3. (5 points) Enter the data. I 4. (10 points) Produce a report to show each customer's name and company and their individual invoice numbers with the amount billed on each invoice. 5. (10 points) Create the query to show all customer names and their companies who have individual invoice amounts over $400. Name the query: InvoiceAmount. 6. (10 points) Create the query to show the departments at IBM that were billed on 3/2/21. Name the query: Departments 11 7. (10 points) Create the query to show the total amount billed to each company. Name the query: Total

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!