Back to Search
Ashford
Database management systems
week 3
INF 322 Week 3 Assignment Customer Service Database

INF 322 Week 3 Assignment Customer Service Database

Short description

Customer Service Database. 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. Create a “Customer Service Database” using New in MS Access and select from Microsoft Online on left, double-click business and then double click on “Customer Service.” On right, click Download. (**Note: The Customer Service Database is no longer available as part of MS Access 2010. Please download the zip file of the database within the online course). 2. This will create a file on your hard drive called “customer service.accdb”. It will also open this file in Access. If you get a security warning, you can click on the security warning in Access option and set the selection to enable content and click ok. 3. Maximize the Shutter Bar to show the tables, queries/views and reports. Note: You are not seeing tables in this view and that can be changed. Click on the down arrow in the shutter view next to the database name “Customer Service” and click on “Tables and Related Views” Save your database. 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.
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.

Document preview
Image Preview
Image Preview
Image Preview
Back to Search
Couldn’t find your assignment?
human

Related Homeworks

Couldn’t find your assignment?

Send your Email and our manager
will help you find the right solution
Live Chat
+18882805042 copy number
FB Messenger