This course is now available ONLINE. You can now work at your own pace. Course Investment includes extensive downloadable documentation (including queries that you can immediately use) and online access to videos for each lesson.
LESSON 1 – The Foundation
- Basics of querying in Visual by using browsing and query tool.
- Introduction to Tables & Field Names including a cheat sheet for the most common financial tables.
- Visual Data Dictionary provided as an Excel spreadsheet. Makes it easy to search and find what you are looking for.
LESSON 2 – Basic Report Design
- Required Tools
- Report Design
- Basic Queries: 1 and 2 tables
LESSON 3 – Training Wheels Are Off
- Creating More Complex Reports
- Adding More Tables
- Using More Functions
LESSON 4 – Elite Performance
- Working with Existing Queries.
- Keeping Your Data Clean with Audits. We will give you 20 predefined queries that you can link to your database.
- Enhancing Queries with Excel Functions
LESSON 5 – More Power
- Multiple criteria
- Outer Joins
- Excel summary & lookup functions to beef up your query results
Sign Up for the On Demand Course Below
Course Instructor
One Time Tuition Fee CAD
$997.00
6 months of access
This is an extensive and well-detailed step-by-step course that will push your Visual ERP skills to the next level.
Lesson 1 – Foundation
Lesson 2 – Basics Report Design
Lesson 3 – More Tables & Functions
Lesson 4 – Existing Queries & Audits
Using Excel Pivot Tables to Enhance Reports