Page Comparison

...

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

• Extract data using the Microsoft Query wizard. See Extracting data using the Microsoft Query wizard (on page ).

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 (on page ).
• Open a query that has already been perfected. Inserting an existing SQL statement AnchorH_15096H_15096 (on page ).
• Edit a query using Microsoft Query directly. See Extracting data using Microsoft Query directly (on page ).
• Create a query using Microsoft Query directly. See Extracting student name and contact details example (on page ).
• Create advanced queries using Microsoft Query directly. See Advanced Microsoft Query and SQL examples AnchorH_15098H_15098 (on page ).
• Extract data for crystal reports. See Extracting data for crystal reports AnchorH_33482H_33482 (on page )Crystal Reports.