About Us Courses Schedules Learning Options Certifications Training Rooms Skills Testing Case Studies Events Contact Us
Training Information Technology Forsythes Group
Courses & Certifications Desktop Applications Microsoft Product Courses Microsoft Word Courses Microsoft Excel Courses Microsoft Access Courses Microsoft Outlook Courses Microsoft Project Courses MS PowerPoint Courses Updating to Office 2007 InfoPath 2003 Microsoft Visio Microsoft Publisher Microsoft Frontpage Windows XP Adobe Product Courses Adobe Acrobat 8 Adobe InDesign Courses Photoshop CS Courses Adobe Photoshop CS-3 Adobe Illustrator Courses Adobe Flash CS3 Dreamweaver 8 Dreamweaver MX MYOB Accounting Corel Draw v12 Crystal Reports Level 1 Crystal Reports Level 2 Technical Professional Development Need further information on Crystal Reports Courses? Click here Enrollment form Crystal Reports - Introductory - Level 1 Course start date: 12-Feb-2009, 16-Apr-2009, 11-Jun-2009 Training Location 9 Denison St, Newcastle West Training Format: Classroom Duration: 2 Days Price: $1,100.00 Inc GST Overview In this course, students will build basic list and group reports that work with almost any database. Prerequisites This course requires a basic understanding of databases and their underlying purpose. Students should also have basic word processing skills, such as copying and pasting text, formatting text, and so on. Students should be familiar with the basic functions of their computer's operating system such as creating folders, launching programs, and working with windows. Course Outline Lesson 1: Creating a Report Set Default Report Settings Specify Fields for a New Report Preview the Report Modify Field Display Add a Report Title Position Fields Add Fields from Additional Tables Lesson 2: Displaying Specific Report Data Find Data Sort Data Filter Data by Single Criteria Lesson 3: Grouping Report Data Insert a Group Add Summaries Format Summary Information Change Group Options Add an Additional Group Create a Top N Sort Group Lesson 4: Building Formulas Write a Formula Edit a Formula Group by Formula Delete a Formula Build a Filter by Multiple Criteria Modify a Filter with Multiple Criteria to Create an OR Condition Create a Parameter Field Write a Formula that Incorporates Null Fields Lesson 5: Formatting Reports Remove White Space Insert Page Header/Footer Data Add Borders and Lines Change the Background Colour Change the Margins Lesson 6: Enhancing Reports Create a Section to Contain a Watermark Insert Objects Using Object Linking and Embedding Modify Format Based on Data Value Conditionally Suppress Data Insert Hyperlinks Hide Blank Report Sections Lesson 7: Creating and Modifying Pie Charts Create a Pie Chart with a Drill-down Modify Chart Text Format a Chart Present a Chart by Group Lesson 8: Distributing Data Export to PDF Export to Excel Export to an Access Database Create a Report Definition Create Mailing Labels Forsythes IT & Training provides instructor led computer training on the Microsoft Office and Adobe range of applications. We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia. With our mobile training room we can provide a range of courses on-site at your premises.

	2008 Forsythes IT & Training - All Rights Reserved	Privacy Policy	Terms & Conditions	Site Map	Links & Resources	Home	Website Design - Indelible Image