Session Description

earn basic procedures for creating and using Aeries Query statements in a request for data or information from your Aeries database. Basic Query will cover entering basic commands, the use of single table queries, selection of data fields, sorting data fields, and constructing simple conditions. This session is geared for the new Aeries user or Aeries users who have not worked with Query before.

Session Content

  • Aeries Tables & Fields
  • Accessing Query on the Aeries Web Navigation Tree
  • Features of the Query Form 
  • Overview of Query Commands
  • Creating a Basic Query from STU Table
  • Query Results
  • Query Reports
  • Using Query Sort Command: BY
  • Query Conditions: IF, AND vs. OR
  • Including Inactive Students in Queries
  • Saving & Loading Queries
  • Creating additional Basic Query using single tables (i.e. TCH, CRS)
  • Basic Troubleshooting of Query Errors

Related Documentation

Query Overview

Table Structure

Beginning Query

Tables and Fields Icon

Query Save or Load

Query Report

Extended Student Fields for Query

Related Videos

Query Overview Video

Query Fields and Functions Video

Query Sorting Video

Query Multiple Sorting Video

Query Simple Conditions Video