Practice Module 4 – Access (Query, SQL)
You are currently viewing a sample of the Cram Kit. Click here to unlock everything.
Click here for the Access files!
You must complete each of the below query using SQL, not Design View. Make sure that for each query, you resize columns to the best fit.
I would recommend downloading this ZIP file, and then emailing it to yourself.
Then, log into your email in your Virtual Desktop and re-download & unzip it there.
Practice Exercise Summary
0 of 8 Questions completed
Questions:
Information
You have already completed the practice exercise before. Hence you can not start it again.
Practice Exercise is loading…
You must sign in or sign up to start the practice exercise.
You must first complete the following:
Results
Results
0 of 8 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 8
1. Question
Q6_SQL_2021S1LevelStudents
- Create a list (descending by last name) of all students that took courses in 2021S1 between a 300 and 400 level. Display their first and last name.
- Run the query. You should get 160 records.
- Save the query as Q6_SQL_2021S1LevelStudents.
CorrectIncorrect -
Question 2 of 8
2. Question
Q7_SQL_CoursesInSelectLanguages
- Create a query that lists all EXL and ACS curriculum. Display all the fields and sort by credit hours, then language, then curriculum number.
- Run the query. You should get 16 records.
- Save the query as Q7_SQL_CoursesInSelectLanguages.
CorrectIncorrect -
Question 3 of 8
3. Question
Q8_SQL_StudentBirthdate
- Create a query that lists each student’s first name, last name, and language. Only include students born after 1/1/2002. List the students alphabetically by the language they’re studying.
- Run the query. You should get 110 records.
- Save the query as Q8_SQL_StudentBirthdate.
CorrectIncorrect -
Question 4 of 8
4. Question
Q9_SQL_CountByState
- Create a list that gives the count of the number of students by state. This count should be displayed as TotalNumberOfStudents.
- Run the query. You should get 12 records.
- Save the query as Q9_SQL_CountByState.
CorrectIncorrect -
Question 5 of 8
5. Question
Q10_SQL_StatesOver50
- Create a listing of the total number of students by state, displayed as CountOfStudents. Only include states with more than 50 students.
- Run the query. You should get 1 record.
- Save the query as Q10_SQL_StatesOver50.
CorrectIncorrect -
Question 6 of 8
6. Question
Q11_SQL_Classes2022S2
- Create an alphabetical list by language that includes the language, curriculum number, and instructor for all classes during the 2022S2.
- Run the query. You should get 31 records.
- Save the query as Q11_SQL_Classes2022S2.
CorrectIncorrect -
Question 7 of 8
7. Question
Q12_SQL_OhioAccessStudents
- Create a list of all the students who are from Ohio and who are studying Access (ACS). Display all fields associated with a student and sort by graduation year in ascending order.
- Run the query. You should get 11 records.
- Save the query as Q12_SQL_OhioAccessStudents.
CorrectIncorrect -
Question 8 of 8
8. Question
Q13_SQL_CountOfGradeByGender
- Create a list by gender that counts the number of each letter grade within the registration records. Only provide counts for students that study the Python language. Order the list in descending order by count of letter grade.
- Run the query. You should get 10 records.
- Save the query as Q13_SQL_CountOfGrade.
CorrectIncorrect