Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!