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:
- How many students are enrolled in the Nursing program and save the query as ‘Qry1’? (1 point)
- List all full-time IT students with studID, full name and status and save the query as ‘Qry2 (1 point)
- How many students have been with ABC from 1995 until 2000 and save the query as ‘Qry3? (2 points)
- List all MBA students currently enrolled with studID, full name and year started and save the query as ‘Qry4 (1 point)
- How many students are enrolled within each program and save the query as ‘Qry5? (1 point)
- Which students were enrolled in ‘Sociology’ as part-time between 1997 and 2002 save the query as ‘Qry6? (2 points)
- Which program(s) did ABC have available prior to 2002 save the query as ‘Qry7? (2 points)