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|
|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||$249.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.
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.