Synergetic: MS Query

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.

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.

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

• 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

To get the most out of your Training, it is highly encouraged that you turn on your camera. There is no single thing that will make as big a difference in the quality of your collaboration than turning your cameras on.