From the course: Access 2019: 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.
Build a report with the Wizard
From the course: Access 2019: Forms and Reports
Build a report with the Wizard
- [Instructor] Reports don't know anything about data. All a report knows is formatting, this font, this color, in this position. That's all. For their data needs, reports rely on a data source. Data comes either directly from a table, or a little bit 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, tidy package. When using a query we have the option of using a pre-built query that you would find in your navigation pane, or creating what's called an embedded query directly inside of the report. Let's take a look at how our reports get data by having the wizard walk us through the first few steps. To do that, I'll come up here to the Create tab, and in the Reports group, I'm going to click on the Report Wizard button. Let's work towards getting a report that looks at our customers' orders. The Report Wizard looks…
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 sort6m 48s
-
(Locked)
Understand report structure8m 13s
-
(Locked)
Build a report with the Wizard3m 32s
-
(Locked)
Explore the report wizard output4m 8s
-
(Locked)
Build a report from a query4m 54s
-
(Locked)
Format the report in Design view5m 42s
-
(Locked)
Apply conditional formatting rules3m
-
(Locked)
Advanced conditional formatting5m 10s
-
(Locked)
Create calculation fields5m 49s
-
(Locked)
Add a report header5m 5s
-
(Locked)
Segment dates into groups4m 31s
-
(Locked)
Format date header sections3m 42s
-
(Locked)
-
-