Programs: Microsoft Access(r)

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.......