Create a report
Reports allow you to show data in a printable format. You can base a report on a table or a
query. So let’s go ahead and create a very quick basic report in MS Access 2007. Click on a table in the navigation pane
Here I click on the ‘students’ table and it becomes highlighted
At the Ribbon make sure the ‘Create’ tab is selected
At the reports section click on the item called ’Report Wizard’
Select the table or query to base the report on.
In the left box double click the field you wish to show on the report. The item will move to the box on the right. You can also use the arrow keys to move fields between the two boxes.
Then click next for grouping options
Then click next to select the criteria acc to which the records should display
Then click finish button
The report will show in print preview mode. As