This is the output of my query:
SELECT TOP (100) PERCENT dbo.tblApplicationScores.applicationScoreID, dbo.tblApplicationScores.applicationID, dbo.tblApplicationScores.scorerID, dbo.tblApplicationScores.plScore, dbo.tblApplicationScores.siScore, dbo.tblApplicationScores.ciScore, dbo.tblApplicationScores.lorScore, dbo.tblApplicationScores.scorerNotes, dbo.tblApplicationScores.totalScore, dbo.tblApplicationScores.scoringGroupID, dbo.tblApplicationScores.scholarshipYear, dbo.tblScoringGroups.scoringGroup, dbo.tblApplications.applicantID, dbo.tblApplicants.first_name, dbo.tblApplicants.last_name, dbo.users.Fname AS scorerFname, dbo.users.Lname AS scorerLname FROM dbo.tblApplicationScores INNER JOIN dbo.tblScoringGroups ON dbo.tblApplicationScores.scoringGroupID = dbo.tblScoringGroups.scoringGroupID INNER JOIN dbo.tblApplications ON dbo.tblApplicationScores.applicationID = dbo.tblApplications.applicationID INNER JOIN dbo.tblApplicants ON dbo.tblApplications.applicantID = dbo.tblApplicants.applicantID INNER JOIN dbo.users ON dbo.tblApplicationScores.scorerID = dbo.users.userID