The way that you have designed your Microsoft Access User Interface will determine how you approach this. http://www.databasedev.co.uk/tab-control.html
In this tutorial, we going to go a step further and learn how to create professionally formatted reports automatically from our database informatio http://databases.about.com/od/tutorials/l/aareports1.htm
You can use the AlternateBackColor property to specify a color to be displayed or printed on every other line in the detail section. http://www.databasedev.co.uk/alternate_rows_2007.html
The technique applied to the tables in the following Practical Learning section can also be applied to a wide query. http://www.functionx.com/access/Lesson23.htm
This article details how we can display random records from a Microsoft Access table using the Rnd function in our query. http://www.databasedev.co.uk/random_query.html
A Microsoft Access crosstab query presents summary information in a compact format that is similar to a spreadsheet. http://www.databasedev.co.uk/crosstab_queries.html