From the course: Access 2019: Forms and Reports

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Organize records with group and sort

Organize records with group and sort

From the course: Access 2019: Forms and Reports

Start my 1-month free trial Buy for my team

Organize records with group and sort

“

- [Instructor] Access's way of preparing material and data fro the printed page is through the report object. Reports take data from tables and queries, apply its formatting and organizational rules, and then bundles all of it together into documents that are ready to be sent to a printer or a PDF file. 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 similar. Let's get away from the H+ Sport database for just a moment and look at this sample database that's built around a deck of playing cards. Here I have a table called Draw and if I take a look at the very bottom I see that I have 5,000 records in this table. This table represents 5,000 random card pulls from a standard deck of playing cards. You can see that the first time I pulled a card out it was the six of hearts. Then I put that card back in, reshuffled, and pulled out…

Contents