Introduction to Querying

Understanding querying functionality in Axiom is integral to utilizing the system to its full potential. Learn the basics of querying by watching this video:

Basic Criteria

Totals and Subtotals

Exercises: Building Basic Queries

Try these five exercises on your own, then you can check your work by watching the video that follows. 

Exercise: Identifying Queries

Find three queries on the Main homepage and list the names of these queries as well as their query IDs. You'll see an example of identifying queries in the first part of the video below. 

Query One: Students

The registrar is looking for a list of high schoolers' homeroom teachers and advisors. 

• Create a query by starting on a Find Students query on the Main homepage
• Limit to upper school students
• Include the fields:
• Person ID
• Full Name
• Current Grade
• Advisor
• Homeroom Teacher
• Gender
• Roles
• Sort by grade and then last name
• Save the query and name it “High School Students Advisors, Homeroom Teachers."

Query Two: Organizations

You need to produce a list of all non-profit and religious organizations you have a record of. Create a query for this. (Hint: Start with a Find Organizations query).

Query Three: Birthdays

"Can I get a list of all lower-school students' birthdays with the earliest birthdays first? Can you also include the parents' names and email addresses?"

Query Four: Classes

The head of school needs a list of all classes taught by each teacher. Create a query of classes sorted first by school level, then by teacher, then finally by class ID.