Access 2010 Forms and Reports: How to Group and Sort Data


show more Grouping and sorting data provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Forms and Reports in Depth show less
please wait ...

Grouping and sorting data

Access's way of preparing material and data for the printed page is through the report object. Reports take data from tables and queries, applies formatting and organization rules, and bundles all of it together into documents that are ready to be sent to a printer or a PDF file, for example. In this movie, we're going to take a look at how Access organizes data into grouping and sorting levels. If you've ever used the totals row within a query, this may seem somewhat familiar, as the concept is really similar. Let's get away from the Olive Oil Company for just a moment and we're going to take a look at a database that's all about playing cards.

I'm going to double-click on this table here called Draw. We can see that this table has 5000 total records at the bottom here, and we have a listing of randomized cards. Basically, I took a random card from a deck of cards and I made a record of each pull. So, for the first pull I had 6 of Hearts, on the second pull I h...

Grouping and sorting data
Video duration: 4m 36s 3h 7m Intermediate

Viewers:

Grouping and sorting data provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Forms and Reports in Depth

Subject:
Business
Software:
Access
Author:
please wait ...