/
Extracting data from the Synergetic database

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.

 

Related content

Main Synergetic views
Main Synergetic views
Read with this
Extracting student name and contact details example
Extracting student name and contact details example
More like this
Extracting data using Microsoft Query directly
Extracting data using Microsoft Query directly
Read with this
Importing information from other applications
Importing information from other applications
More like this
Using stored procedures to retrieve Synergetic data
Using stored procedures to retrieve Synergetic data
Read with this
Exporting information to Microsoft Excel
Exporting information to Microsoft Excel
More like this