Creating a square grid from X,Y,Z values

[bmckenzie05]

I have a table TestScores consisting of StudentID, TestNumber, and TestGrade for a class with 3 tests. My goal is to produce a row for each student ID and 3 columns for the student's grade on each test. What would be the best way to set this up?

(Given: each student will have 0-1 test scores for each test).

 

[isladogs]

Save the data in a normalised table with one test mark per record.
Use a crosstab query to view the data in a 'spreadsheet type layout.