Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the ABC Company database provided, which is used to track students as well as their program and consists of only one table tblStudents, create
Using the ABC Company database provided, which is used to track students as well as their program and consists of only one table tblStudents, create the following queries in Access 2016: 1. How many students are enrolled in the Nursing program and save the query as Qry1? (1 point) 2. List all full-time IT students with studID, full name and status and save the query as Qry2 (1 point) 3. How many students have been with ABC from 1995 until 2000 and save the query as Qry3? (2 points) 4. List all MBA students currently enrolled with studID, full name and year started and save the query as Qry4 (1 point) 5. How many students are enrolled within each program and save the query as Qry5? (1 point) 6. Which students were enrolled in Sociology as part-time between 1997 and 2002 save the query as Qry6? (2 points) 7. Which program(s) did ABC have available prior to 2002 save the query as Qry7? (2 points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started