From the course: Access 2016: Forms and Reports
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Build a report with the wizard
From the course: Access 2016: Forms and Reports
Build a report with the wizard
- [Voiceover] Reports don't know anything about data. All a report knows is formatting. This font, this color, in this position, and that's it. For all other data needs, reports rely on a data source. Data comes either directly from a table or, a little more round about from a query. The nice thing about using a query as a data source, is that you can bring in fields from multiple related tables, calculated fields and expressions, and give it all to the report, in one nice and tidy package. When using a query, we have the option of using a pre-built query that you can find in the navigation pane, or creating what's called an embedded query, directly inside of the report. Let's take a look at how a report gets data, by having the Wizard walk us through the first few steps. You can find the Report Wizard up here on the Create tab, and in the Reports Group, we'll find Report Wizard. Let's work towards getting a report that looks at our customer's orders. The Report Wizard looks and feels…
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
-
-
-
-
-
-
-
Organize records with group and sort5m 8s
-
Understanding report structure7m 31s
-
Build a report with the wizard6m 49s
-
Build a report from a query3m 55s
-
Format the report in Design view5m 27s
-
Apply conditional formatting rules7m 13s
-
Create calculation fields4m 44s
-
Add a report header5m 7s
-
Segment data into groups5m 43s
-
Challenge: Create an employee report23s
-
Solution: Create an employee report3m 50s
-
-
-
-
-