Synergetic: MS Query

Learn how to use MS Query as a tool to extract data from Synergetic in multiple forms

Description

This hands on session covers how to create simple database queries using MS Query (both using and not using the query wizard). It covers database concepts such as tables, views, joining tables and how to put everything together to create more complex queries. It also looks at how to use retrieved data for mail merges, pivot tables and pivot charts

Target Audience

This course is ideal for anyone who needs to extract data from Synergetic

Prerequisites

To enable participants to make the most of this training we suggest their permissions are reviewed to allow access to relevant MS Query tables back at their school in order to be able to produce future queries

Learning Outcomes

Synergetic data structures
Recognise views and base tables
Create/modify queries
Create mail merges to produce letters/envelopes/labels (mail-merges)
Turn any crystal report into an MS Query
Use MS Excel pivot tables and pivot charts for data analysis, summaries and graphs