When skimming a long report, it could 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 the values that were in the second look get noticed.…We will continue building on a Lifetime Sales report that we made in the last movie.…I'll double-click on it to open it to review where we are at.…Now let's go ahead and switch into Design View.…I will change my view here, switch to Design View.…We want to call out some data from our report.…Let's say that we wanted to highlight all of the values of Lifetime Sales…that were less than $20.…I will click on Lifetime Sales here, go up to the Format Tab, and click on…Conditional Formatting.…
This will start up the Conditional Formatting Rules Manager where we can apply…rules for formatting our data.…I am going to click on New Rule, and we can tell Access that I want to format…all the cells where the field value is less than, and I will type-in 20.…For all the data that is less than 20 in the Lifetime Sales field, I want to color that red.…
- Designing for the end user
- Organizing form elements
- Formatting a form
- Adding headers
- Linking to external content
- Entering and selecting data
- Adding charts
- Creating a main menu
- Creating a customer form
- Understanding report structure
- Building reports from wizards and queries
- Printing reports
Skill Level Intermediate
Managing and Analyzing Data in Excel 2010with Dennis Taylor1h 32m Intermediate
1. Introduction to Forms
2. Form-Design Basics: Creating a Directory
3. Form and Report Controls
4. Getting around the Database
5. Report Layout
6. Printing, Tweaking, and Automating
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.