BPC110 Access Practice 3
Channel: PVCCOERSpecialist
Date: 2021-04-21

For Access Practice 3, we will continue to work with the same database we started in Practice 2 that manages student and faculty data in the Honors program at Paradise Valley Community college. For this practice, we will focus on creating queries for the database. 

We will create queries that answer the following questions:

How many students are enrolled in the honors program?
How many students have declared Health Sciences as their Field of Interest and how many are undeclared?
What students have been awarded a scholarship?
What faculty teach in the Honors Program, and what students are they assigned to?