MS Access: Custom reports generation

Question

I have two tables in an MS Access database as shown below.

Employee table:

Salary table:

I have created a query for the summary of salaries for each employee, to be shown as Year based.

Query:

SELECT Employee.EmployeeID, Employee.Name, Salary.AnnualYear, 
Salary.MinSalary, Salary.Salary, Salary.MaxSalary
FROM Employee INNER JOIN Salary ON Employee.EmployeeID=Salary.EmployeeID;

Query result:

What I want to achieve is,

To create a Report to show the details as Year based.

Report achieved so-far:

expected report:

Will Report wizard be able to help me to achieve the expected report?

Or Do I have to do any VBA programming?

MS Access file

Answer 1

What you are looking for is a Pivot table. You can take your existing query and switch to PivotTable View (open the query, right click on the tab and select PivotTable View). This results in something that looks like:

As requested. I have saved that in your file. Find it here.

Answer 2

Report wizard should be able to achieve that report.