Practice Module 3 – Access (Query, Design View)
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 Query Design mode, not SQL. 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 5 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 5 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 5
1. Question
Q1_InputLanguage
- List all classes curriculum (CurriculumID, CurriculumNumber, CreditHours) from a user-inputted language (the user should be prompted to enter a value for language after running the query).
- Sort numerically in ascending order by CurriculumNumber.
- Run the query and enter “PY” as the language. You should get 8 records.
- Save the query as Q1_InputLanguage.
CorrectIncorrect -
Question 2 of 5
2. Question
Q2_InputStudentYear
- Display all student information (StudentID, First, Last, LanguageID) where the user enters all or part of the student’s graduation year.
- Run the query. If you enter 25, you should get 56 records.
- Save the query as Q2_InputStudentYear.
CorrectIncorrect -
Question 3 of 5
3. Question
Q3_Female_SelectLanguages
- List all female students, including their First, and Last name, that are studying either the SQL or PY languages.
- Sort alphabetically by first name.
- Run the query. You should get 73 records.
- Save the query as Q3_Female_SelectLanguages.
CorrectIncorrect -
Question 4 of 5
4. Question
Q4_PYGradeDist
- Create a query that displays the count of students receiving A’s, B’s, and C’s who have taken a course in Python (PY). Display the result by semester.
- Sort the query by semester.
- Run the query. You should get 30 records.
- Save the query as Q4_PYGradeDist.
CorrectIncorrect -
Question 5 of 5
5. Question
Q5_300Level_Curriculum
- List all curriculum (CurriculumID, CurriculumNumber, Description) where the CurriculumNumber begins with a 3.
- Sort by CreditHours in descending order, then CurriculumNumber in ascending order.
- Display an additional column, called CreditHours, that displays the credit hours for the course, followed by a “*” if it is a required course. If it’s not a required course, then don’t add anything after the credit hours. Check out the image below for an example of how this should look.
- Run the query. You should get 12 records.
- Save the query as Q5_300Level_Curriculum.
CorrectIncorrect