This exercise will help you learn the functions of the PS query by modifying an existing query. You need Query Manager access.
Please use the query in CSPRD, UMS_DTS_DEMO and do these 10 exercises.
Exercise:
1. Log into CSPRD MaineStreet and search the query, UMS_DTS_DEMO. Click “Edit”.
2. Save the query as “UMS_DTS_DEMO_TEST” (as private)
3. Delete the “CLASS_NBR ” field
4. Change the column name: Change “Sum Progress” to “Credit hours”
5. Change the order of the column: Move INSTITUTION to be the first column
6. Add new criteria: STDNT_ENRL_STATUS "equal to" E
7. Sort data: sort by SUBJECT then CATALOG_NBR
8. Add prompt for “SUBJECT” with the "Optional" box checked
9. Run the query
10. Delete the query you just created
Answer Key:
- Running Reports with Query Viewer & Query Manager
- Saving & Organizing Queries
- Editing Queries - Delete a Field
- Editing Queries Change Heading Text (fieldname)
- Editing Queries - Column Order
- Changing a Selection for Variables in a Criteria
- Editing Queries - Sorting Order
- Adding a New Prompt
- Select the "Run" tab and the prompt screen will show up automatically. Enter values on prompts and then click OK.
- Saving & Organizing Queries
Attachments:
image2022-3-17_12-29-19.png (image/png)
image2017-10-20_8-58-38.png (image/png)
image2017-10-20_8-54-56.png (image/png)
image2017-11-1_13-56-35.png (image/png)
image2022-3-15_16-4-54.png (image/png)
image2022-3-15_16-8-13.png (image/png)
