Sage 50 Accounts Report Designer v2008 training. Write your own Sage reports and design stationery.

*New course search page   You can use our new course search page to find the up-coming Sage classroom courses and the latest information we have about the number of places available.

We are the number one Sage 50 Accounts training partner in the UK. We provide quality training and can give you the most appropriate training programme. We'll get you where you want to be as soon as possible, and we get it right first time.

When you've read all the course details, you can use the course search page to see course dates and availability, or call us on 0845 641 0624. You can also get us to call you by filling out the enquiry form, and we'll contact you as soon as we can to discuss your training needs.

2 day course

About the course

This course helps you make the most of the flexible report designer supplied with the Sage 50 Accounts range. Create your own high-impact layouts that incorporate data from Sage 50 Accounts. This will ensure your company can easily present vital information in ways that meet specific requirements. Also learn how to amend existing stationery layouts to fit in with your own business needs.

The aim of this course is to give you an understanding of how to use the Sage Report Design software to tailor and create reports to suit your specific needs.

Sage Accounts is supplied with a range of standard reports. However, it may be necessary to alter these reports to suit your business needs, and even perform your own specific analysis by creating new reports from scratch.

Some of the functions that we will use are:

• Amending reports
• Creating new reports manually
• Creating new reports using the Report Wizard
• Combining the advanced features of the program to analyze and format reports to your specific requirements.

Sage 50 Accounts Report Designer course session 1 - Introduction To Report Design and Amending Existing Reports

• 5 Key Ideas Behind Report Design
• Amending Existing Reports
• Saving Reports

Sage 50 Accounts Report Designer course session 2 - Creating a New Report - Manually

• Creating a New Report
• Understanding Report Types
• The Design Screen
• Grouping Objects
• Editing In Preview Mode

Sage 50 Accounts Report Designer course session 3 - Creating a New Report - Using the Wizard

• Using the Design Wizard
• Multiple Sorts

Sage 50 Accounts Report Designer course session 4 - Expressions and Snippets

• Creating A New Stock Report
• Adding An Expression
• Saving Snippets
• Using Expressions In Further Calculations
• Formatting Numeric Variables

Sage 50 Accounts Report Designer course session 5 - Grouping and Totalling Data

• Adding Groups
• Adding Subtotals
• Adding Grand Totals
• Keep Together

Sage 50 Accounts Report Designer course session 6 - Grouping Data Using the Wizard

• Understanding the Audit Tables
• Adding Groups and Totals using the Wizard
• Totalling An Expression
• Error List
• Suppressing Duplicates

Sage 50 Accounts Report Designer course session 7 - Using Report Filters

• Creating Filters
• Show Field Values Button

Sage 50 Accounts Report Designer course session 8 - Editing Group Functions

• Character Breaks
• Modifying The Group
• Producing a Trial Balance
• Controlling Debit & Credit Values
• Adding Net Totals

Sage 50 Accounts Report Designer course session 9 - Adding Criteria

• Understanding Criteria
• Setting Criteria
• Printing Criteria on the Report
• User Defined Criteria

Sage 50 Accounts Report Designer course session 10 - Applying Multiple Sub-totals

• Building a Management Activity Report
• Filter Options
• Adding Multiple Sub-totals
• Moving Groups
• Dealing with Unwanted Sections
• Count Function

Sage 50 Accounts Report Designer course session 11 - Conditional Properties

• Conditional Printing
• Advanced Conditional Formatting

Session 12 - Joining Tables

• Understanding Tables
• Adding Tables
• Performing A Join
• Adding Data From The New Table

Sage 50 Accounts Report Designer course session 13 - Layouts and Letters

• Customising Invoices
• Using Your Own Stationery
• Editing Statements
• Creating Letters
• Inserting Images

Sage 50 Accounts Report Designer course session 14 - Secure Email & Batch Reporting

• Configuring Email Settings
• Secure PDF Settings
• Batch Reporting

Sage 50 Accounts Report Designer course session 15 - Introduction to ODBC

• What is ODBC?
• What does it do?

• Sage 50 Accounts setup course (1 day)
• Sage 50 Accounts stage 1 (2 days)
• Sage 50 Accounts stage 2 (2 days)
• Sage 50 Accounts stage 3 (2 days)
• Sage 50 Accounts Project costing workshop (1 day)
• Sage 50 Accounts Upgrade workshop (1 day)
• Sage 50 Accounts home study

For your information we also supply the full range of Sage software, support and stationery. Contact us for advice and prices.

Training is an incredibility important investment. Having the right job skills in the right areas of your business is key to success in today’s competitive market. An investment with Advantage Services will actually save you money as well-trained employees are less likely to make costly mistakes. Not only will you be gaining fabulous skills for your CV, but it will help improve your business’s productivity, profitability and competitive advantage.

Get ready to experience the UK’s top tuition with Advantage Services and start working effectively and trouble-free. Contact an advisor for more information and make a booking today.