Microsoft Access : Chapter 3 : Exercise 8


Exercise 8:  Creating and Running a Crosstab Query

 

•
•1.)  Select the queries button in the database
•

     Click on new

•

     Click on the crosstab query wizard in the new box

•

     Click ok to begin

•2.)  Select the StudentStat query and click next

•3.)  Click Major in the field list and click “>” to put it in the selected fields box
•

      Click Next

•4.)  Click gender for the column headings
•

      Click Next

•5.)  Click on credits as the field to be calculated
•

     Select “Max” as the function to use for the credits

•

     Click Next

•6.)  Keep the name given by the program for the name of your query
•

      Click Finish

 

Continue to Exercise 8 solution to compare your final Query with the correct answer....... 

 

Back to Exercise 7

Continue to Exercise 8 Solution

 Back to Menu 


Microsoft Access : Chapter 3 : Exercise 8