Question
Show a SQL Query and screenshot your results in a Word document to submit to your instructor. There will be 4 results with explanations required for this assignment.
Part 1
1. Please download, unzip, and open this zip file of the MS Access Customer Service Database.
2. Save your database.
3. You should now be able to use MS Access and the database created to complete the assignment.
Part 2
1. Add 10 customers to the database using the "Customers" table.
2. Using SQL query, update one customer. Show before and after data as well as the SQL Code.
3. Add an eleventh customer and then delete them with a SQL Query, Show before and after data as well as the SQL Code.
4. Write a report showing your customers identify the primary key in the table you are reporting on. Show the results of your Report via a screen shot.
5. Upload a copy of the database using
Show a SQL Query and screenshot your results in a Word document to submit to your instructor. There will be 4 results with explanations required for this assignment. Please download, unzip, and open this zip fileof the MS Access Customer Service Database. Save your database. You should now be able to use MS Access and the database created to complete the assignment. Add 10 customers to the database using the "Customers" table. Using SQL query, update one customer. Show before and after data as well as the SQL Code. Add an eleventh customer and then delete them with a SQL Query, Show before and after data as well as the SQL Code. Write a report showing your customers identify the primary key in the table you are reporting on. Show the results of your Report via a screen shot. Upload a copy of the database using "Customer Service" and student First and Last name as the file name.
Explanation / Answer
As you can see i have completed a customer database shown below. i need help completing the task at hand and completing the intial assignment. Can anyone help? I would award all of my 7,250 points to whom ever can successfully assist me with this final task. Thank you. 1. Use the Access database you created in Week 3: Customer Service Database 2. Output 3 queries using SQL code and not the standard access view: