Quick reference

• 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.