3305 Main Street Ste 019 Vancouver, WA 98663

Mastering Report Design Using Office Connector Query

Session Details

Looking to round out your understanding and use of Office Connector Query by embarking on some of the more advanced concepts? In this class, you will learn about ways to extend what you can accomplish on your way toward becoming an Office Connector Query expert.

Audience Users of Sage 300 Construction and Real Estate - Office Connector Query
Length 120 minutes
Required Software Office Connector Query Designer
Recommended Previous Training In order for this class to be considered helpful, we STRONGLY recommend first taking the following class(es):
Delivery Live instructor with online meeting and teleconference. Normally conducted as group training with participants from multiple companies.
Format Lecture style with question/answer
Price $225.00 per seat. Receive a 50% discount on additional seat purchases.
To add this class to your cart, you must first enter your business e-mail address.

Enter Your Business E-mail Address:


For a list of available times:

VIEW CLASS SCHEDULE

NOTE: A registration password is required to successfully register for a class. The password will be emailed to you upon successful payment.


This is a lecture style class conducted via an online meeting and teleconference. Materials provide fairly detailed, tutorial-like instructions, so that you can work through the examples on your own time in order to cement what you have learned.

The instructor will cover the following objectives:

  • Introduction to Structured Query Language (SQL)
  • Incorporating data from multiple tables in query (joining tables)
  • Giving worksheet functions (like TSSUM) more power by leveraging SQL

Note: Once purchased, training seat must be used within one year from purchase date. Unused training does not carry forward.