Details of this Paper

MIS582 iLab 1 SQL Queries Using Access

Description

solution


Question

Question;MIS582 iLab 1 SQL Queries Using AccessiLab 1: SQL Queries Using AccessiLAB OVERVIEWScenario and SummaryThis week, you will learn to create and run SQL SELECT queries in the Access database. You will need todownload the Lab_1_SQL.accdb database from Doc Sharing and be able to run Access 2010, either through Citrix or installed on your workstation or laptop.DeliverablesRename the Lab_1_SQL.accdb database using your first initial, last name, and assignment number as the file name (e.g., JSmith1.accdb). Create and save your SQL queries in your database. When you are done, submit.iLAB STEPSSTEP 1? Download the Lab_1_SQL.accdb database from Doc Sharing.? Rename the Lab_1_SQL.accdb database with the following naming convention: Lab1_FirstinitialLastname as the file name (e.g., Lab1_JSmith.accdb).STEP 2Using the data in the table in the database, create a SQL query to satisfy each of the tasks below.Save each SQL query using the name associated with the task in the table below.NameTaskQuery1Write a SQL statement to display Students' First and Last Name.Query2Write a SQL statement to display the Major of students with no duplications. Do not display student names.Query3Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888.Query4Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888 and have the major of Biology.Query5Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888 or 88808. Do not use IN.Query6Write a SQL statement to display the First and Last Name of students who have the major of Biology or Math. Use the SQL command IN.Query7Write a SQL statement to display the First and Last Name of students who have the Status greater than 1 and less than 10. Use the SQL command BETWEEN.Query8Write a SQL statement to display the First and Last Name of students who have a last name that starts with an S.Query9Write a SQL statement to display the First and Last Name of students having an a in the second position in their first names.Query10Write a SQL expression to display the Status and a sum of the Status of each Status value as SumOfStatus. Group by Status and display the results in descending order of SumOfStatus.STEP 3Upload the following files to the Week 1: Course Project Dropbox. Lab1_FirstInitialLastName.accdbSubmit your assignment to the Dropbox located on the silver tab at the top of this page.

 

Paper#36544 | Written in 18-Jul-2015

Price : $33
SiteLock