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.…
Author
Jennifer McBee
Released
11/8/2016- 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
Duration
Views
-
Introduction
-
Welcome53s
-
Using the challenges1m 50s
-
-
1. Microsoft Office Specialist Exam Overview
-
Prepare for the exam2m 18s
-
2. Managing the Access Environment
-
Create a new database4m 30s
-
Manage a database6m 42s
-
Apply application parts6m 9s
-
Backup a database2m 53s
-
✓ Solution: Create databases3m 25s
-
-
3. Building Tables
-
Create a new table4m 56s
-
Create and modify fields6m 24s
-
Sort and filter records4m 57s
-
Primary key4m 33s
-
Set table relationships5m 21s
-
Manage records5m 23s
-
Import data5m 31s
-
✓ Solution: Build tables6m 13s
-
-
4. Create Forms
-
Create basic forms4m 51s
-
Set form controls8m 15s
-
Arrange objects on forms6m 37s
-
Format form controls6m 18s
-
✓ Solution: Create forms6m 59s
-
-
5. Create and Manage Queries
-
Create multi-table queries6m 42s
-
Create crosstab queries3m 35s
-
Append query4m 3s
-
Use Total and Group By3m 25s
-
✓ Solution: Create queries10m 46s
-
6. Create Reports
-
Create a report4m 55s
-
Apply Format tab options4m 19s
-
✓ Solution: Design Reports6m 19s
-
-
7. Final Practice Exam
-
Conclusion
-
Next steps41s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Apply Report Design tab options