SQL to Access Query Procedure

SELECT
ROW_NUMBER()OVER(order by dbo.tblTestPaper.fxTestCode)AS ROWNUMBER,
(SELECT t.fcEducationalDescription FROM dbo.tblEducationalType t WHERE t.fxEducationalType=tblTestPaper.fxEducationalType)AS EducationalType,
(SELECT t.fcEducationalDescription FROM dbo.tblEducationalLevel t WHERE t.fxEducationalLevel=tblTestPaper.fxEducationalLevel)AS EducationalLevel,
(SELECT t.fcEducationalDescription FROM dbo.tblEducationalPeriod t WHERE t.fxEducationalPeriod=tblTestPaper.fxEducationalPeriod)AS EducationalPeriod,
(SELECT t.fcEducationalDescription FROM dbo.tblSubject t WHERE t.fxEducationalSubject=tblTestPaper.fxEducationalSubject)AS EducationalSubject,
dbo.tblTestPaper.fxQuestionnaire,
dbo.tblTestPaper.fxTestCode,
dbo.tblQuestionnaire.fcTopic,
dbo.tblQuestionnaire.fcSubTopic,
dbo.tblQuestionnaire.fcQuestion,
dbo.tblQuestionnaire.fbA,
dbo.tblQuestionnaire.fcA,
dbo.tblQuestionnaire.fbB,
dbo.tblQuestionnaire.fcB,
dbo.tblQuestionnaire.fbC,
dbo.tblQuestionnaire.fcC,
dbo.tblQuestionnaire.fbD,
dbo.tblQuestionnaire.fcD,
dbo.tblQuestionnaire.fbE,
dbo.tblQuestionnaire.fcE,

dbo.tblReportHeading.fcHeader1,
dbo.tblReportHeading.fcHeader2,
dbo.tblReportHeading.fcHeader3,
dbo.tblReportHeading.fcHeader4,
dbo.tblReportHeading.fcHeader5,
dbo.tblReportHeading.fcInstruction,
(
CASE WHEN fbA=1 THEN 'A'
WHEN fbB=1 THEN 'B'
WHEN fbC=1 THEN 'C'
WHEN fbD=1 THEN 'D'
WHEN fbE=1 THEN 'E'
END)as AnswerKey,
(
CASE WHEN fbA=1 THEN fcA
WHEN fbB=1 THEN fcB
WHEN fbC=1 THEN fcC
WHEN fbD=1 THEN fcD
WHEN fbE=1 THEN fcE
END)as Answer
FROM dbo.tblTestPaper INNER JOIN
dbo.tblQuestionnaire ON dbo.tblTestPaper.fxQuestionnaire = dbo.tblQuestionnaire.fxQuestionnaire CROSS JOIN
dbo.tblReportHeading

END

this is my code in SQL Query

Sample:
ROW_NUMBER EDUCTYPE EDUCLEVEL EDUCPERIOD EDUCSUBJECT FXKEYQUESTIONAIRE
1 Tertiary 1st Year 2nd Semester Biological Science 428
2 Tertiary 1st Year 2nd Semester Biological Science 429