Student Scores display in multiple columns

[mychael14]

Hi everyone could you please help me with this. I'm really new in Access and I'm trying to learn it by my self.
My first question is, how can I display the scores of a student in horizontal? (Bad english)
I have two tables, one with students information and another for students' score.
When I query may table using this

SELECT Student.StudentName, WrittenScores.Score
FROM Student INNER JOIN WrittenScores ON Student.[ID] = WrittenScores.[StudentID];

It resulted to this as expected

All I want to do is something like this

pls I need your advise here

 

[Joe4]

Your images did not come through. You can do Copy/Paste from Access Queries, and the images should appear.

Also, the underlying structure of your tables is important here, so we would need to understand how they are set up.