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