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.
Apply conditional formatting rules
From the course: Access 2016: Forms and Reports
Apply conditional formatting rules
- [Voiceover] 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 can make sure that values that warrant a second look get noticed. We'll continue building on the Customer Lifetime Sales report that we started in a previous movie. Let's go ahead and double-click on it to open it up. Now in this case, I want to scroll through here and highlight all of my customers that have spent less than $100 with the company. I can do that with conditional formatting rules. And to get to those, we'll go into the Design View. I'll select the field that has the value I want to compare and come up to the Format tab and press Conditional Formatting. Here we'll add a new rule. We can come down here and it says, "Field value is," and I'll change between to less than. Then I'll type in the number 100. If this statement is true, the field value, in this case, the lifetime sales value, is…
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
-
-
-
-
-