INF/322 INF 322 INF322 Database Systems Ashford - Week 3 Individual Assignment - A+ guaranteed!

INF/322 INF 322 INF322 Database Systems Ashford - Week 3 Individual Assignment - A+ guaranteed!

Customer Service Database

Use as a guide! 

If you purchase this: Thanks for purchasing my tutorial! Open the attached file to get the paper/solutions. If you have any questions, comments, or concerns, please let me know! I can help you with future courses. Thanks again! Free feel to PM me, or send me a message at:

algebraexpert @ homeworkmarket.com

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 “Customer Service” and student First and Last name as the file name.

All data and screen shots should be included in a word document with a brief explanation of the actions you performed.