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.
||Users of Sage 300 Construction and Real Estate - Office Connector Query
||Live instructor with online meeting and teleconference. Normally conducted as group training with participants from multiple companies.
||Lecture style with question/answer
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.
Check Availability / Register
The instructor will cover the following objectives:
Note: Once purchased, training seat must be used within one year from purchase date. Unused training does not carry forward.
- 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