Access Tutorial 7 Creating Custom Reports COMPREHENSIVE Objectives
Access Tutorial 7 Creating Custom Reports COMPREHENSIVE
Objectives XP • View, filter, and copy report information in Report view • Modify a report in Layout view • Modify a report in Design view • Design and create a custom report • Sort and group data in a report New Perspectives on Microsoft Office Access 2007 2
Objectives • • • XP Add, move, resize, and align controls in a report Add lines to a report Hide duplicate values in a report Add the date, page numbers, and title to a report Create and modify mailing labels New Perspectives on Microsoft Office Access 2007 3
Customizing Existing Reports XP • Report view provides an interactive view of a report New Perspectives on Microsoft Office Access 2007 4
Customizing Existing Reports New Perspectives on Microsoft Office Access 2007 XP 5
Customizing Existing Reports New Perspectives on Microsoft Office Access 2007 XP 6
Customizing Existing Reports New Perspectives on Microsoft Office Access 2007 XP 7
Designing a Custom Report XP • Before you create a custom report, you should first plan the report’s contents and appearance – – – – – Purpose and record source Sort order Grouping fields Balance attractiveness and readability Group related fields Identify field values Include title, page number, and date on every page Identify end of report Use little formatting Use consistent style New Perspectives on Microsoft Office Access 2007 8
Designing a Custom Report New Perspectives on Microsoft Office Access 2007 XP 9
Creating a Blank Report in Layout View XP • Click the Create tab on the Ribbon • In the Reports group on the Create tab, click the Blank Report button to open a blank report in Layout view New Perspectives on Microsoft Office Access 2007 10
Working with Controls in Design View XP • Compared to Layout view, Design view gives you greater control over the placement and sizing of controls, and lets you add and manipulate many more controls, but at the expense of not being able to see live data in the controls to guide you as you make changes New Perspectives on Microsoft Office Access 2007 11
Hiding Duplicate Values in a Report XP • Display the report in Layout or Design view • Open the property sheet for the field whose duplicate values you want to hide, set the Hide Duplicates property to Yes, then close the property sheet New Perspectives on Microsoft Office Access 2007 12
Adding the Date and Time to a Report XP • Display the report in Layout or Design view • In the Controls group on the Design tab in Design view, or on the Format tab in Layout view, click the Date & Time button to open the Date and Time dialog box • To display the date, click the Include Date check box, then click one of the three date option buttons • To display the time, click the Include Time check box, then click one of the three time option buttons • Click the OK button New Perspectives on Microsoft Office Access 2007 13
Adding the Date and Time to a Report New Perspectives on Microsoft Office Access 2007 XP 14
Adding Page Numbers to a Report XP • Display the report in Layout or Design view • In the Controls group on the Design tab in Design view, or on the Format tab in Layout view, click the Insert Page Number button to open the Page Numbers dialog box • Select the format, position, and alignment options you want • Select whether you want to display the page number on the first page • Click the OK button to place the page number expression in the report New Perspectives on Microsoft Office Access 2007 15
Adding Page Numbers to a Report New Perspectives on Microsoft Office Access 2007 XP 16
Adding a Title to a Report New Perspectives on Microsoft Office Access 2007 XP 17
- Slides: 17