Report View, Design View, Layout View and Print Preview

Locked lesson.

Upgrade

About this lesson

Identify how to switch between different views such as Report View, Design View, Layout View and Print Preview.

Quick reference

Report View, Design View, Layout View, and Print Preview

Application Terminology

Report View

Report View displays a report without pagination, like one long web page.  Report View does not run all the code behind the report.

Print Preview

Print Preview shows a report formatted for paper.  Use the navigation controls in the lower left to move to first page, previous page, next page, and last page.

Layout View

Layout View is a combination of Report View and Design View.  It shows data while giving you limited design capabilities.

Design View

Design View is the most important view for designing reports.  This is where you have the most control.

Steps

Switch View of a Report

  • To switch between different views of a report that is open, click the View drop-down on the HOME or DESIGN ribbon.
Login to download
  • 00:05 This is Access 2013, lesson 26.
  • 00:10 There are 4 views you can use to look at and work with reports.
  • 00:14 Hi, this is Crystal.
  • 00:16 Unless you have changed the default view,
  • 00:19 when you open a report, you are in Report View.
  • 00:22 This displays the report without pagination,
  • 00:26 like one long web page.
  • 00:28 Print Preview shows the report formatted for paper.
  • 00:32 When you come to the end of the page,
  • 00:34 the report doesn't necessary end.
  • 00:37 Use the navigation controls in the lower left
  • 00:40 to move to other pages.
  • 00:43 Design View is the most important view for designing reports.
  • 00:48 This is where you have the most control.
  • 00:52 Layout View is a combination of Report View and Design View.
  • 00:58 It shows data while giving you limited design capabilities.
  • 01:03 Make the control containing customer name wider.
  • 01:07 When you scroll through the report,
  • 01:09 you will see all the controls with customer have been resized
  • 01:12 because it is really the same control.
  • 01:16 Resize Time Type to be narrower.
  • 01:19 Press ALT-ENTER to turn on the Property Sheet.
  • 01:23 Set the Format of amount to Currency.
  • 01:27 Set the Border Style of Customer and Year to be Transparent.
  • 01:32 Use the Property Sheet,
  • 01:34 to set the width of the date to be 0.8 inches.
  • 01:39 When you change to Design View, all the changes
  • 01:42 you made in Layout View will show.
  • 01:45 The textbox control for time type was changed to 0.8 inches.
  • 01:51 This is not wide enough for the label.
  • 01:53 Click the time type textbox and shift-click the label.
  • 01:57 0.6" is too narrow to show the label caption. Make it wider.
  • 02:04 Look at the Width for the Work Date textbox.
  • 02:07 It is 0.8 so make the label 0.8 inches as well.
  • 02:13 On the Home ribbon, with the label and textbox for WorkDate
  • 02:16 still selected, click Right Align in the Text Formatting group.
  • 02:22 Right Align content for all labels and textboxes for numbers.
  • 02:27 Set the Width for time type and its label back to 0.7 inches.
  • 02:33 Set the Width for Time and its label to 0.9 inches,
  • 02:38 and Right Align the content.
  • 02:40 Right Align content for Rate and its label too.
  • 02:44 Select all labels and click the object Left Align on the QAT.
  • 02:50 Do the same for the controls in the detail section.
  • 02:53 On the REPORT DESIGN TOOLS, FORMAT ribbon,
  • 02:56 set the Shape Outline to light gray.
  • 02:59 Drag the right border of the report in
  • 03:02 to close up the extra space.
  • 03:04 Save the report and look at the Print Preview.
  • 03:08 Change to Layout View
  • 03:10 and change the Caption of Time Type to Type,
  • 03:13 since it is shorter and the data is short.
  • 03:17 In this lesson, you have learned how to
  • 03:18 use different report views to accomplish
  • 03:21 what you need to do and display reports.
  • 03:24 In the next lesson, we will add calculations
  • 03:27 and talk about control names.

Lesson notes are only available for subscribers.

Gift this course