Extracting data from the Synergetic database

You can extract data from the Synergetic database for your own purposes, using tools such as:

• Microsoft Excel
• Microsoft Word.

Views have been developed to make it easier to extract data. See Synergetic views.
Stored procedures have also been developed, particularly for extracting data for mail merge letters. See Using stored procedures to retrieve Synergetic data.
How to

• Extract data using the Microsoft Query wizard. See Extracting data using the Microsoft Query wizard.

Note: We do not recommend using the wizard as subsequent changes to your query are more complex to implement. The wizard is used mainly for creating quick queries but does not introduce you to the full functionality of Microsoft Query.

• Edit a query using the Microsoft Query wizard. See Editing a Microsoft Query using the wizard.
• Open a query that has already been perfected. Inserting an existing SQL statement.
• Edit a query using Microsoft Query directly. See Extracting data using Microsoft Query directly.
• Create a query using Microsoft Query directly. See Extracting student name and contact details example.
• Create advanced queries using Microsoft Query directly. See Advanced Microsoft Query and SQL examples.
• Extract data for crystal reports. See Extracting data for Crystal Reports.