Learn about all of the command on the Report Design tab. Author Jen McBee demonstrates how to apply themes to reports, and add groups and totals to report fields, plus how to insert controls such as labels, add page numbers, logos and dates to the report.
- [Instructor] Now that you know…how to quickly create reports, we're going to talk about…how to design your reports.…In this video, we're going to focus…on the most commonly used commands…on the report layout tools design tab.…We'll learn how to add groups,…how to add totals to our reports, how to apply themes,…and how to insert controls.…I think you're going to be amazed at how closely related…forms are to reports, as far as creating them…and then formatting them.…
So it's nice that once you're comfortable with your forms,…you'll be just as comfortable with your reports.…On the Access 2010 MOS Exam, you may be asked…to insert some controls onto a report,…add groups to a report, total those groups,…and maybe even apply a theme.…I have the 0602 exercise file open…so let's go ahead and get started.…Let's go ahead and create a new report…based on the order details query.…
Right here, now go ahead and select it.…And let's just do a quick report.…So with that selected in the navigation pane,…all I have to do is click on report.…
- 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.