Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Create a new query in Design View that is based on the tblCoach and tblLevel table Add the LevelName field from the tblLevel table to the query design. Add the CoachFirst, CoachLast, BGCExp, and CertificationExp fields, in that order, from the tblCoach table. Use qryCoachBGCExpirations to save query. Add criteria to the BGCExp field to select records with BGCExp dates that occur on or before 12/31/2019. Save and run the query, and then close it.

Create a new query in Design View that is based on the tblCoach and tblLevel table Add the LevelName field from the tblLevel table to the query design. Add the CoachFirst, CoachLast, BGCExp, and CertificationExp fields, in that order, from the tblCoach table. Use qryCoachBGCExpirations to save query. Add criteria to the BGCExp field to select records with BGCExp dates that occur on or before 12/31/2019. Save and run the query, and then close it.

Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter13: Views
Section: Chapter Questions
Problem 2MC
See similar textbooks
icon
Related questions
icon
Concept explainers
Question
  1. Create a new query in Design View that is based on the tblCoach and tblLevel table Add the LevelName field from the tblLevel table to the query design. Add the CoachFirst, CoachLast, BGCExp, and CertificationExp fields, in that order, from the tblCoach table. Use qryCoachBGCExpirations to save query. Add criteria to the BGCExp field to select records with BGCExp dates that occur on or before 12/31/2019. Save and run the query, and then close it.
File Home Create External Data Database Tools NP_AC16_CS1-4a_Raven MarieJones_1: Database- C:\Users\Owner\OneDrive\Desktop\Spring 2023 Coursework and Notes\NP_AC16_CS1-4a_Raven MarieJones_1.accdb (Access 2007 - 2016 file format) - Access View Run Select Make Append Update Crosstab Delete Table All Access... Search... Tables # _GradingInfo Table tblAthlete FEB tblCoach tblLevel B tblLocation Queries Equal Collegiate FEE qryAthletesBorn2011 And... qryCoachBGCExpirations qryLevelsAndAthletes Ready Results Query Type SECURITY RISK Microsoft has blocked macros from running because the source of this file is untrusted. < qryCoachBGCExpirations X tblCoach CoachID LevellD CoachFirst CoachLast BGCExp Field: LevelName Table: tblLevel Sort: Show: Criteria: or: Help 00 Query Design CoachFirst tblCoach Union Pass-Through Data Definition tblLevel LevellD LevelName MonthlyFee Registration Fee Add Tables CoachLast tblCoach Tell me what you want to do ← Insert Rows Ex Delete Rows Builder BGCExp tblCoach LIInsert Columns Delete Columns Return: All Query Setup Learn More Microsoft Access On Or "before 12/31/20 OK ✓CertificationExp tblCoach Data type mismatch in criteria expression. Σ Totals Parameters Help X Property Sheet Table Names Show/Hide Marie Jones MJ Add Tables Tables Links Search _GradingInfoTable tblAthlete tblCoach tblLevel tblLocation Caps Lock 0 Num Lock Queries Add Selected Tables All SQL X X X
Transcribed Image Text:File Home Create External Data Database Tools NP_AC16_CS1-4a_Raven MarieJones_1: Database- C:\Users\Owner\OneDrive\Desktop\Spring 2023 Coursework and Notes\NP_AC16_CS1-4a_Raven MarieJones_1.accdb (Access 2007 - 2016 file format) - Access View Run Select Make Append Update Crosstab Delete Table All Access... Search... Tables # _GradingInfo Table tblAthlete FEB tblCoach tblLevel B tblLocation Queries Equal Collegiate FEE qryAthletesBorn2011 And... qryCoachBGCExpirations qryLevelsAndAthletes Ready Results Query Type SECURITY RISK Microsoft has blocked macros from running because the source of this file is untrusted. < qryCoachBGCExpirations X tblCoach CoachID LevellD CoachFirst CoachLast BGCExp Field: LevelName Table: tblLevel Sort: Show: Criteria: or: Help 00 Query Design CoachFirst tblCoach Union Pass-Through Data Definition tblLevel LevellD LevelName MonthlyFee Registration Fee Add Tables CoachLast tblCoach Tell me what you want to do ← Insert Rows Ex Delete Rows Builder BGCExp tblCoach LIInsert Columns Delete Columns Return: All Query Setup Learn More Microsoft Access On Or "before 12/31/20 OK ✓CertificationExp tblCoach Data type mismatch in criteria expression. Σ Totals Parameters Help X Property Sheet Table Names Show/Hide Marie Jones MJ Add Tables Tables Links Search _GradingInfoTable tblAthlete tblCoach tblLevel tblLocation Caps Lock 0 Num Lock Queries Add Selected Tables All SQL X X X
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS