Open topic with navigation

Queries Workflow

This workflow provides the basic, high-level steps for using this module. The steps and links in this workflow do not reference every possible procedure. For more procedures, see the links in the Related Information section.

The process of creating a simple Select query includes the following steps:

1. Access the Design workspace.

   Note: Interaction with diagramming and design canvases is not available on touch-screen devices.

2. Add at least one query source.
3. Add at least one field from that query source.
4. Run the query to make sure it returns the expected results.
5. Save the query.

The process of creating a more complicated query might include the following additional steps:

6. Add criteria using expressions.
7. Add prompts.
8. Add hyperlinks.
9. Define the results.

After you have initiated the process of creating a Select query using either of these options, when the Design workspace appears, you can modify the query type to create any of the following types of queries based on that Select query:

• Crosstab query
• Delete query
• Update query
• Append query

Copyright © 2018 General Electric Company. All rights reserved.