Linking Sage 50 Accounts with Microsoft Office training course
Linking Sage 50 Accounts with Microsoft Office is a one-day course. Our price is £130.00 (Sage's RRP is £265.00).
» Overview: Create professional documentation, dynamically linked to your live Sage Accounts data.
» What do I learn?
See how Microsoft® Office can integrate with Sage 50 Accounts. It includes dynamically linking spreadsheets in Excel, running mail merges in Word and creating live links to PowerPoint presentations.
» By the end of this course you will:
- Have had a basic introduction to the ODBC (Open DataBase Connectivity) driver
- Be able to navigate around the menu options available in Microsoft® Query
- Know how to update the live link between the query and Sage 50 Accounts using the refresh option
- Understand how to add both single and multiple calculations to a query, then return the data to Microsoft® Excel and format the cells
- Be able to run a mail merge within Microsoft® Word to link the data in Sage 50 Accounts to a Word document
- Know how to create labelled envelopes from the names and addresses in Sage 50 Accounts
- Understand how to use the If…Then…Else statement within Microsoft® Word
- Be able to use multiple tables within Microsoft® Excel and join the tables together
- Know how to use the cycle through totals option in Microsoft® Query
- Be able to create graphs in Microsoft® Excel based on data from Sage 50 Accounts and create a live link to Microsoft® PowerPoint
- Know how to create pivot tables and charts in Microsoft® Excel to dynamically interrogate the Sage 50 Accounts data
- Know how to add criteria to select specific data from Sage 50 Accounts
- Be able to set up parameter queries to enable specific ranges to be entered when requesting data from Sage 50 Accounts
Book now
| Course | Centre | Start date |
Duration | Total places | Available places | Book |
| Link Sage 50 Accs - MS Office | Croydon | 09/09/2010 | 1 day | 10 | 6 | |
| Link Sage 50 Accs - MS Office | Reading | 23/09/2010 | 1 day | 10 | 5 | |
| Link Sage 50 Accs - MS Office | Manchester | 24/09/2010 | 1 day | 12 | 0 | |
| Link Sage 50 Accs - MS Office | N.London | 29/09/2010 | 1 day | 12 | 4 | |
| Link Sage 50 Accs - MS Office | Birmingham | 06/10/2010 | 1 day | 12 | 8 | |
| Link Sage 50 Accs - MS Office | N.London | 18/10/2010 | 1 day | 12 | 9 | |
| Link Sage 50 Accs - MS Office | Bristol | 19/10/2010 | 1 day | 10 | 10 | |
| Link Sage 50 Accs - MS Office | Glasgow | 21/10/2010 | 1 day | 12 | 11 |
Linking Sage 50 Accounts with Microsoft Office is a one-day course. Our price is £130.00 (Sage's RRP is £265.00).
You can book your course in several ways:
- Online: Just click the "Book now" button (your payment will only be processed after we have booked your course with Sage).
- Phone: Just call 0845 009 3990 to pay by card or arrange BACS or cheque payments.
- Use the contact form: Click here and fill out the contact form.
Important notes about booking your Sage classroom training course
- When booking a course online, if the course is not for the paying cardholder, please enter the name it should be booked for in the notes section when paying.
- If a vegetarian meal is required instead of the standard meal provided, please enter this in the notes section as well.
- If a course is showing no availability it is still worth contacting us as there maybe cancellations or the possibility of switching the course to a bigger room.
- Also note that the number of available places given is updated regularly, but it is not live, so it's always best to ask us for the latest availability if the number of available places is running low.
- *for all courses except Instant Accounts, which is £215 and Payroll Year End, which is £190.
Detailed course content
Click to see the course content
Session 1 - Introduction to the ODBC Driver and MS Query
- The Drivers and Language used in the Link
- The Default Data Source Name and Data Path
- Finding the Data Path
- Creating New Data Source Names
Session 2 - Linking Sage 50 Accounts With Microsoft Excel
- Accessing Sage Accounts data from Microsoft Excel
- An overview of Microsoft Query
- Building a data query
- Returning the data to Microsoft Excel
- Creating a Query without using the Query Wizard
Session 3 - Using Expressions
- Using Expressions to Perform a Calculation
- Using Multiple Expressions
- Formatting cells in Excel
Session 4 - Creating Mail Merges & Using Criteria
- Creating a Mail Merge Letter in MS Word
- Using Criteria in a Query to Limit the Records Required
- Building the Mail Merge Document
- MS Word Functions - If...Then...Else
- Creating Labelled Envelopes
Session 5 - Using Multiple Tables
- Selecting Multiple Tables
- Joining Tables
- Viewing Joins
Session 6 - Totalling Data and Graphs
- Using Sage Custom Fields in a Query
- Cycle Through Totals
- Creating Graphs in MS Excel
- Live Links to Microsoft PowerPoint
- Cycle Through Totals on an Expression
Session 7 - Using Pivot Tables and Charts
- Creating a Pivot Chart with a Pivot Table
- Building the Query with Multiple Tables
- Selecting the Tables and Variables
- Adding Sorts and Multiple Criteria
- Creating the Pivot Table
Session 8 - Parameter Queries
- Building a Multi-Table Query
- Switching off Automatic Query
- Creating Parameter Queries
- Changing the Parameters in Excel
- Producing Totals in the Report
- Applying Autofilters
Other relevant links
- Sage 50 Accounts training menu
- Sage 50 Accounts Report Designer (2 days)
- Microsoft Excel - Stage 1 (1 day)
- Microsoft Excel - Stage 2 (1 day)
- Sage 50 Accounts essentials course(1 day)
- Sage 50 Accounts stage 1 (2 days)
- Sage 50 Accounts stage 2 (2 days)
