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.
Apply conditional formatting rules
From the course: Access 2019: Forms and Reports
Apply conditional formatting rules
- [Instructor] When skimming a long report, it can be pretty easy to skip right over some very significant numbers. By utilizing the conditional formatting rules within your reports, you could make sure that the values that warrant a second look get noticed. We'll continue building on the Customer Lifetime Sales report that we started over the course of the last couple of movies. In it, we have all of our customers organized based off of the state that they live in. And we can see the lifetime sales are the amount of money that they spent with the company. What I want to do is start to highlight some of these people. For instance, if I scroll down on the report, I want to find all the people that have spent less than $100, and call attention to them. To do that, I'll switch my view into design view. Then, I'm going to click on the Lifetime Sales value, right over here, and come up to the formatting tab, and click on the Conditional Formatting button. That'll start up the Conditional…
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)
-
-