StudID Full $\_$ Name Year $\_$ Started Program Status

$114$ ?Julian Rice $1995$ ?English P

$123$ ?Mike Ricci $1999$ ?Sociology F

$133$ ?Nelson Pedri $1997$ ?Nursing P

$134$ ?Brenda Kerry $2001$ ?Nursing F

$136$ ?Aaron O'Neal $2001$ ?Math F

$140$ ?Willie Brown $2002$ ?MBA F

$142$ ?Nathan James $1998$ ?Psychology P

$147$ ?Paul Maciag $1999$ ?IT P

$150$ ?Andrew Sims $2000$ ?Sociology P

$151$ ?Jason Pete $2002$ ?Sociology P

$153$ ?Eric Snow $2000$ ?IT F

$154$ ?Melanie Jaysen $1998$ ?Psychology P

$160$ ?Pam Bella $1998$ ?Nursing F

$180$ ?Shawn Lee $1999$ ?Nursing F

$201$ ?Tyler Smith $2001$ ?MBA P 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 $$ Qry $1?$

$2.$ ?List all full $-$ time IT students with studID, full name and status and save the query as $$ Qry $2$ ?

$3.$ ?How many students have been with ABC from $1995$ ?until $2000$ ?and save the query as $$ Qry $3?$ ?

$4.$ ?List all MBA students currently enrolled with studID, full name and year started and save the query as $$ Qry $4$ ?

$5.$ ?How many students are enrolled within each program and save the query as $$ Qry $5?$ ?

$6.$ ?Which students were enrolled in $$ Sociology $$ ?as part $-$ time between $1997$ ?and $2002$ ?save the query as $$ Qry $6?$ ?

$7.$ ?Which program $($ s $)$ ?did ABC have available prior to $2002$ ?save the query as $$ Qry $7?$ ?Please send me the steps using the Query Design in Access