Learn about the most used commands on the Format Tab. Author Jen McBee will demonstrate how to insert a background image, and how to apply alternate row colors, also known as Banded Rows, and how to use Conditional Formatting rules, all of which you will
- [Instructor] I hope you're starting to feel…more comfortable with creating and formatting your reports.…The next tab that we're going to talk about is…the format tab.…Now on the format tab, we can insert a background image,…we can apply alternate row colors, also known as…banded rows.…Remember when we did this on our forms?…Makes it so much easier to read.…We can also format our fonts.…And by formatting fonts, it's not just changing…the font color or making it bold, but we're going to talk…about conditional formatting.…
I have the 0604 exercise file open, so if you're ready…let's tackle this topic.…Let's first look at our customer's report.…I'll double click to open it up,…let's go ahead and go into layout view…and go to our format tab.…Want to go ahead and include a background image…in our report.…We happen to have an H plus sport washed out logo.…Don't want anything too dark or bright…because we still want to be able to read all of our data.…
Looks pretty good.…So that's how easy it is to insert a background image.…
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports
Skill Level Intermediate
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 18s
2. Managing the Access Environment
3. Building Tables
4. Create Forms
5. Create and Manage Queries
6. Create Reports
7. Final Practice Exam
- 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.