Training Sessions
ACL offers many training opportunities.
http://www.acl.com/services/course_catalog.aspx
The St. Louis ACL User Group often offers training opportunities at quarterly meetings.
————————————————————–
Web ‘n’ Learn
I’m excited to announce that ACL has generated a new training program just for our user group! Based on feedback from members, we wanted to provide some training at varying experience levels. We’ve selected topics at the beginning, intermediate, and advanced levels. Below are recorded sessions:
Beginner Session Topics:
- Define a report file in ACL
- Connect to XLS using ODBC
- Identify highest $ invoice by customer
- Quick sort and quick filter
- Copy log entries into Word or ACL script
- Use of SUBSTRING() and similar functions
- Connect directly to DB through AX
Session 1 Feb 19, 2009
Session 2 Feb 26, 2009
Intermediate Session Topics:
- MOD() function to ID rounded amounts
- Automate a data connection and tests
- Use of variables in scripts
- Group dates by month or day of week
- Dialogue use in scripts
- Join employee & vendor by address
- Define delimited file with SPLIT() function
Session 4 March 12, 2009
Session 5 March 19, 2009
Advanced Session Topics:
- DIRECTORY command
- Simple GROUP example
- Conditional GROUP example
- Creating PDF reports
- NOTIFY command
- Error trapping in scripts
- Nested scripts using DO WHILE
- Scheduling scripts
- Complex file definition with scripts
Date: March 22, 2010