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