1 / 35

Mastering Queries for Efficient Database Management

Learn to create, modify, and use queries effectively in database management. Hands-on session for beginners focusing on predefined and custom queries. Explore powerful tools to extract specific student data. Get help with individual queries and printing reports. Discover the flexibility and usefulness of queries in managing databases.

joroy
Download Presentation

Mastering Queries for Efficient Database Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Session 10- 1

  2. Session 10 Queries: Powerful and flexible tools that anyone can use. Session 10-

  3. Queries Hands-On • Who is this session geared for? • Beginners • Evaluations • Questions • Feel free to ask questions throughout the session. • There will be time at the end for individual help. Session 10-

  4. What is a query? • A request for information from a database • “A query is a set of criteria that describes a particular student population. Queries are used in functions like Print, Package, and Export to select specific groups of student records from all the records in the database. Some queries have fixed values, or you can enter different values each time you use the query.” EDExpress Help Text Session 10-

  5. Session Overview • Using predefined queries • Creating your own queries • Modifying existing queries • The power of queries Session 10-

  6. Predefined QueriesHANDS ON • Predefined queries in EDExpress Session 10-

  7. Predefined QueriesHANDS ON • Printing List-Processed ISIRs using predefined query • File|Print Session 10-

  8. Select report type “List-Processed ISIRs • Select destination “Screen” • Click on the Selection Criteria button Session 10-

  9. Click on the ellipsis button Session 10-

  10. Choose the desired query Session 10-

  11. Notice that the name of the selected query fills the “Query Title” field • Click OK Session 10-

  12. Returns to the Print screen • Click OK Session 10-

  13. Session 10-

  14. Creating your own query... • Step 1: Decide what you want to query BE SPECIFIC EFC < 2500 (Independent and EFC < 2500) or (is Orphan) Ind Orphan Session 10-

  15. Basic Query Rules • Queries process left to right, AND before OR • Parenthesis change the order of precedence (1+3) ÷ 2 = 2 1 + (3 ÷ 2) = 2.5 • Difference between AND and OR Session 10-

  16. Creating a QueryHANDS ON • Query to find Auto Zero EFC students Session 10-

  17. Session 10-

  18. Creating a QueryHANDS ON • Query to find Auto Zero EFC students • Query to find students who are • Independent AND • EFC < 2500 AND • Comment Code 053 (left “Drug Eligibility Question” blank Session 10-

  19. Session 10-

  20. Modifying Existing Query HANDS ON • Modify C CODE query to choose students by dependency status Session 10-

  21. Change the title Session 10-

  22. Choose “Field” DEPENDENCY STATUS • Set “Operator” to = • Check “Prompt at Execution” Session 10-

  23. Session 10-

  24. Session 10-

  25. Modifying Existing Query HANDS ON • Modify C FLAG query to choose students by dependency status • You can also modify user-defined queries Session 10-

  26. The Power of Using Queries • Printing Reports • Multiple Entry Session 10-

  27. The Power of Using Queries • Printing Reports • Multiple Entry • Exporting EAPS and CORR Session 10-

  28. The Power of Using Queries • Printing Reports • Multiple Entry • Exporting EAPS and CORR • User Database fields • Queries in combination with File Formats Session 10-

  29. Session 10-

  30. Session 10-

  31. Session 10-

  32. Session Review • Using predefined queries • Creating your own queries • Modifying existing queries • The power of queries Session 10-

  33. Further Assistance We appreciate your feedback and comments. CPS Customer Service Phone: (800) 330-5947 Fax: (319) 358-4260 Email: <cps@ncs.com> TDD/TTY: (800) 511-5806 SFATECH http://www.ed.gov/offices/OSFAP/sfatech/index.html Session 10-

  34. Questions? • Individual assistance available for remainder of this session. • Visit the PC lab for more individual assistance. Session 10-

  35. Session 10-

More Related