Highlighting important data with conditional formatting


show more Highlighting important data with conditional formatting provides you with in-depth training on Business. Taught by Gini Courter as part of the Access 2010: Real-World Projects show less
please wait ...

Highlighting important data with conditional formatting

Here's the challenge. You have lots of data. That's what you're storing it in Access 2010. And yet, the more data you have, the harder it is to represent that data in ways that make it understandable, particularly for people who only work with the data set infrequently. Most people cannot look at a table full of numbers and understand what those numbers mean. Conditional Formatting was one of the most exciting enhanced features in Excel 2007. Access 2010 includes some of those same data visualization features.

So we're going to use our Order Summary report to see how some of these features work. As you can tell, we have lots and lots of data in this report, every order that's been placed since we began in business. In order to apply Conditional Formatting, we need first to switch to Layout View in our report. We get four new tabs Report Layout Tools. We're going to switch to Format and then we're going to apply some simple Conditional Formatting to the Order Tot...

Highlighting important data with conditional formatting
Video duration: 6m 39s 28m 27s Appropriate for all

Viewers:

Highlighting important data with conditional formatting provides you with in-depth training on Business. Taught by Gini Courter as part of the Access 2010: Real-World Projects

Subject:
Business
Software:
Access
Author:
please wait ...