The 20-Minute Guide to Using MS Access 2007
I get the following results returned.
3 records have been returned for the state of ‘CA’.
Removing the criteria from the query grid would return all records.
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 ‘Customers’ table and it becomes highlighted.
At the Ribbon make sure the ‘Create’ tab is selected.