Intelligent Query Architect (IQA) is a tool provided with iMIS that offers simple access to iMIS data for reporting, mailings, or letter and email merges and provides the ability to create sophisticated queries against the iMIS database even if you have limited experience with SQL. This on-line workshop covers the basics of creating, editing and running a query. You will learn how to perform simple joins, apply filters and work in both basic and advanced mode.
This workshop combines lecture, hand-outs and labs, with time for lab completion and discussion.
At the end of the class, attendees will have an understanding of:
- Running and editing queries
- Creating basic queries
- Applying filters and sort orders
- Creating a simple join