From the course: Access 2016: Forms and Reports
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Organize records with group and sort
From the course: Access 2016: Forms and Reports
Organize records with group and sort
- [Voiceover] 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 organizational rules, and 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 gonna take a look at how Access organizes data into grouping and sorting levels. If you've ever used the Totals row within the query then this may seem somewhat familiar as the concepts are really similar. Let's get away from the H Plus Sport database for just a moment here and take a look at this sample database that's built around a standard deck of playing cards. In this database, I have a table here called Draw, and if I open it up and take a look on the very bottom, we'll see that I have 5,000 individual records. Each of these records represents a random card pull from that deck of cards. So for instance, up here at the very top, the very first card we drew out of the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Organize records with group and sort5m 8s
-
(Locked)
Understanding report structure7m 31s
-
(Locked)
Build a report with the wizard6m 49s
-
(Locked)
Build a report from a query3m 55s
-
(Locked)
Format the report in Design view5m 27s
-
(Locked)
Apply conditional formatting rules7m 13s
-
(Locked)
Create calculation fields4m 44s
-
(Locked)
Add a report header5m 7s
-
(Locked)
Segment data into groups5m 43s
-
(Locked)
Challenge: Create an employee report23s
-
(Locked)
Solution: Create an employee report3m 50s
-
(Locked)
-
-
-
-