Join Alicia Katz Pollock for an in-depth discussion in this video Identifying report structure in Design view, part of Access 2010 Essential Training.
Reports also have another view, the Design View, which gives you complete…control over your report. Understanding it, helps you with designing your reports,…and you can use it to make freestyle changes.…We explored many of the Design View features in the chapter about forms.…So we're just going to highlight the ones most relevant here for our…particular reports.…Scroll down on the Navigation pane, and double-click on the Sales Reps Phone List Report.…Here's what it looks like.…Now, come up here to the Views, drop it down, and choose Design View.…
Now let's look at the parts.…There is a Report Header and a Report Footer.…These appear at the top and the bottom of the report itself.…This will be on the first page.…This will be on the last page, no matter of how many pages the report is.…The Page Header and the Page Footer will appear at the top and bottom of every…single page in the report, whether it's one page or ten pages.…Then the Detail will repeat itself over and over again for every record in the table.…
Author
Released
6/10/2010- Understanding database concepts and terminology
- Building tables with Application Parts
- Defining field properties
- Creating relationships between fields and tables
- Sorting and filtering
- Creating forms with the Form Wizard
- Analyzing data with the Query Designer
- Automating with macros
- Formatting reports with Layout Tools
Skill Level Beginner
Duration
Views
Q: It seems there are movies missing in the course which should explain how to enter products in the Order table. How do I do this?
Q: In the Chapter 6 video "Using Design view," we work with the Combo Box Wizard. When I click on the Combo Box then click the location on the form, it does not start the Combo Wizard. Please advise.
A: Click on the Data tab and make sure one of the tables or queries appears selected in the Control Source. The form needs to be bound to a table or query before you make the combo box.
Also, Access is extremely finicky. When you're looking at the Properties window, be sure to click in the little box in the upper left corner of the form, between the vertical and horizontal rulers—as noted in the screenshot—before creating the combo box.

Q: It seems there are steps missing in the course. The file I built myself by following along doesn't match what's on screen. Why not?
A: The lessons in this course are only somewhat cumulative. Each movie is a standalone explanation of a technique or feature. The database is built throughout the course, but not every step between the lessons are shown. The course would be overly long if the author repeated every step in building a realistic, functioning database. However, the missing steps are variations on the techniques you've already learned. Also, this is one of those courses where using the exercise files is recommended.
Related Courses
-
Access 2010: Shortcuts
with Alicia Katz Pollock3h 43m Intermediate -
Access 2010: Queries
with Adam Wilbert3h 2m Intermediate -
Access 2010: Forms and Reports
with Adam Wilbert3h 7m Intermediate -
Managing and Analyzing Data in Excel 2010
with Dennis Taylor1h 32m Appropriate for all
-
Introduction
-
Welcome51s
-
-
1. Access Basics
-
Starting Access54s
-
Creating a new file1m 10s
-
Trusting a file56s
-
The Quick Access toolbar1m 8s
-
Backstage view2m 45s
-
Exploring ribbons2m 59s
-
Using the Navigation pane2m 11s
-
Getting help1m 29s
-
2. Creating a First Database and Using the Tools
-
Setting a primary key1m 20s
-
Creating a lookup field3m 59s
-
Creating multi-value fields2m 19s
-
3. Setting Up the Data
-
Setting field properties7m 34s
-
Setting input masks2m 3s
-
Setting validation rules3m 28s
-
-
4. Building Structure
-
5. Formatting and Appearance
-
Formatting tables4m 2s
-
6. Forms
-
Creating data-entry forms2m 31s
-
Using the Form Wizard1m 38s
-
Using Design view12m 41s
-
Setting tab stops1m 26s
-
Adding buttons to a form1m 49s
-
Using navigation forms2m 51s
-
-
7. Queries
-
Introduction to queries1m 9s
-
Using the Query Wizard1m 45s
-
Creating wildcard queries1m 24s
-
Creating yes/no queries1m 12s
-
Building calculation queries2m 44s
-
Using update queries2m 56s
-
Using delete queries1m 31s
-
-
8. Reports
-
Introduction to reports1m 28s
-
Creating multi-table reports1m 46s
-
Creating mailing labels2m 15s
-
Printing reports1m 9s
-
-
9. Putting Data to Work
-
PivotTables2m 29s
-
PivotCharts2m 3s
-
-
10. Automating with Macros
-
Creating macros2m 53s
-
Attaching macros to objects2m 26s
-
Using data macros2m 16s
-
-
11. Using Other Applications with Access
-
Exporting to PDF53s
-
Collecting data over email2m 42s
-
Using Package and Sign1m 14s
-
Publishing to SharePoint2m 58s
-
12. Advanced Tools in the Database
-
Splitting a database2m 27s
-
13. Customization
-
Customizing the ribbons1m 16s
-
Setting Access options7m 3s
-
-
Conclusion
-
Goodbye14s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Identifying report structure in Design view