Activity 10.01 – Converting gender and job statistics

Your manager would like to convert the remaining GenderStats and JobStats queries to passthrough queries to allow them to be processed more efficiently. In summary, the following tasks will need to be completed:

1. Convert the SQL for GenderStats (SQL 2) and name the passthrough query GENCount.
2. Convert the SQL for JobStats (SQL 3) and name the passthrough query JOBCount.
3. Convert the SQL for Country (SQL 4) and name the passthrough query CTRYCount.

After implementing these steps, the expected output should look like this:

Figure 10.7 – Changes to the code and the affected onscreen controls

Hint

If a field name has spaces, Access encloses the field name in square brackets, whereas MySQL encloses them in backticks. Backticks are located in the top-left corner of your main keyboard, next to the 1 key.

We did not modify or move two of the original SQL statements. We...