1 / 24

Welcome to

Level II Query Training. Welcome to. Level II Query Training. Fields must include the table as a prefix (e.g. STU.GR). Table Order Matters. Level II Query Training. Query Structure - Review Multi Table Query Steps Functions / Output – Labels and Reports Time Savers:

jamal
Download Presentation

Welcome to

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. Level II Query Training Welcome to

  2. Level II Query Training • Fields must include the table as a prefix (e.g. STU.GR). • Table Order Matters

  3. Level II Query Training • Query Structure - Review • Multi Table Query Steps • Functions / Output – Labels and Reports • Time Savers: • Printout the Code Table • Sample Saved Queries • Change

  4. QUERY Language • LIST STU ID GR BY GR ID IF GR = 12 • TOTAL STU ID GR BY GR ID • LIST STU FN RC1 ID GR BY GR IF RC1 >= 299

  5. Level II Query Training • Query Structure - Review • Multi Table Query Steps • Functions / Output – Labels and Reports • Time Savers: • Printout the Code Table • Sample Saved Queries

  6. Multi-Table QUERY Language • The biggest change is that all fields must include a Table prefix.

  7. Try the following queries: LIST STU CSE STU.ID STU.LN STU.GR CSE.PL LIST CSE STU STU.ID STU.LN STU.GR CSE.PL Compare the results…

  8. Practice Print a class list of elementary teachers, including student name, grade, sex, parent or guardian, father’s work, mother’s work, teacher name. Sort the list by teacher’s name. LIST STU TCH STU.NM STU.GR STU.SX STU.PG STU.TL STU.FW STU.MW TCH.TE BY TCH.TE

  9. Practice List of students suspended with the ADS code and dates of suspension. LIST STU ADS STU.NM ADS.DT ADS.CD ADS.DS ADS.DD ADS.ED IF ADS.DS : SUS Multiple records may be returned.

  10. Aeries is looking for any record that contains a matching record. Any record with a STU.ID is returned. Can we sort records out? Yes…no? -There are limitations to what can be sorted. Comparing ELA and Math can get quirky. Can we get single records per line yes and no. -Not in query…

  11. Level II Query Training • Query Structure - Review • Multi Table Query Steps • Functions / Output – Labels and Reports • Time Savers: • Printout the Code Table • Sample Saved Queries

  12. Functions

  13. Functions New - Clear the query window. Run – Run the current query. Report – Create a report of Query data. Labels – Set out put for Avery 5150 from Query data. Letters – Not used. Letter Editor – Not used. Envelope – Not Used. To File – Save the Query result to a delimited text file. Save – Save the Query Language not the data. Load – Load a Saved Query Startup – Setup Aeries to load a keep statement. Reset – Clear all SKIPs and KEEPs. Tables – Reload tables, if results seem quirky. Exit – Leave the Query window.

  14. Report • Run the desired query. • Close the resulting table. • Click report. • Select options. • Select OK.

  15. Report To make the report… use BY in the query: LIST STU ID GR LN FN LIST STU ID GR LN FN BY GR

  16. Labels • The structure of the query can be used to create labels. • The Special menu shows “\” means new line.

  17. Labels • Run the desired query. • Close the resulting table. • Click Labels. • Select options. • Select OK. LIST STU FN LN \ AD \ CY ST ZC ZX

  18. Any text can be added to a query. LIST STU To the Parents of: FN LN \ AD \ CY ST ZC ZX

  19. Labels Practice Make a list of students using ID, grade, Last Name, First Name, Sex and Special ED placement by sex. LIST STU CSE ID: STU.ID Grade: STU.GR \ STU.LN , STU.FN \ SEX: STU.SX \ CSE.PL BY STU.SX IF CSE.PL # “”

  20. Level II Query Training • Query Structure - Review • Multi Table Query Steps • Functions / Output – Labels and Reports • Time Savers: • Printout the Code Table • Sample Saved Queries

  21. Time Savers: • Printout the Database Definitions from Reports • Save it as a PDF on your desktop • Search it to find: • Fields • Table links

  22. Time Savers: What does this tell us about the ADS Table? • It is related by STU. • It uses the student number not Perm ID.

  23. Time Savers: • Save Queries to notepad or Word document • Find Common Queries : • Online at Aeries • Online at Assessment and Data Systems. http://www.empire.k12.ca.us/District/Department/22-Technology-Department/1537-District-Technology-Resources.html

  24. ReminderIf you make a mistake… • The clock is ticking… • The system is backed up hourly. • The longer the you wait the more data that could be lost. • Sooooo…. • Call Extension: 2218

More Related