NFE113 – NetForum Enterprise MS Reporting Services Training

In this one-day course you will learn the introductory concepts of report design and using stored procedures that extract NetForum data.

This course covers basic formatting, grouping, expression-building, and various aspects of Microsoft SQL Reporting Services that are pertinent to operation of the formats from NetForum. Students will also learn how to set up reports in NetForum, including instruction on dropdown lists for prompted parameters.

Course Level: Intermediate
Instructional Method: Group Live
Duration: One-Day Class

Prerequisites:
In order to benefit from this course, the student should have previously taken NetForum Data Model Training and also have a working knowledge of Transact SQL.

Class is held from 9:00 am – 5:00 pm.

NFE112 – NetForum Enterprise Advanced Toolkit for NetForum Enterprise 2017

This one day course is intended for students that have previously taken NetForum Toolkit training and will introduce the basics of the new NetForum UI designer. It coves basic foundational concepts and students will perform hands-on exercises to build a new profile form, add different types of widgets to the profile form, interacting with classic pop-up forms, and switching between classic and new UI.

Course Level: Advanced
Instructional Method: Group Live
Duration: One-Day Class

Prerequisites:

  • NFE101 – NetForum Enterprise Data Model and NFE102 – NetForum Enterprise Developer Toolkit are prerequisites for this course.
  • Understanding of relational databases is needed.
  • Understanding of toolkit (façade object, classic form designer, child forms, profile forms, etc.) is essential.

Desired but not required Skills:

  • Understanding of Transact SQL is helpful but not absolutely essential.
  • C# programming is not required, but helpful.

Class is held from 9:00 am – 5:00 pm.

NFE101 – NetForum Enterprise Data Model

The NetForum Enterprise Data Model class will cover database basics, NetForum database principles, and exercises using SQL (Structured Query Language) which is used to communicate with the database. This one-day class is designed to help you find and extract the data you need from NetForum Enterprise.

The morning of the class will be spent on an overview of general netFORUM database principles, mixed in with beginner SQL principles. The afternoon will have a greater focus on the netFORUM database, taking a closer look at the specific tables. Learn Transact SQL basics, gain a thorough understanding on the netFORUM database architecture, and take a close look at netFORUM’s core modules, table by table. Students will write a series of SQL queries to learn more about netFORUM’s database tables to help you find and extract the data you need.

Course Level: Intermediate
Instructional Method: Group Live
Duration: One-Day

Class Prerequisites: Understanding of relational database management systems and Transact SQL language is required. If you are not familiar with relational databases and if you do not have a working knowledge of Transact SQL, then you will not get the full benefits from this course.

If you are not familiar with SQL, then we encourage you to take an SQL course first.

If you are not handy with Transact SQL, but you understand relational databases in general, you can still take the course and it will greatly improve your overall knowledge of how netFORUM is put together. You can skip the hands-on exercises and just listen and learn.

If you want to get an idea of the kind of SQL skills this course assumes you have, see this course at SQL Programming Language: A Comprehensive Hands-On Introduction at https://www.learningtree.com/. If you can do what’s described in this course, then you will have the background to get the most out of Data Model Training.

Note: We do not do database design in this course; we only query the database, but it helps to know how a database is put together.

Class is held from 9:00 am – 5:00 pm.

NFE102 – NetForum Enterprise Developer Toolkit

This two-day course teaches the student the basics of the NetForum’s Developer Toolkit. Working your way through a series of hands-on exercises, you will build NetForum Objects, Forms, and eWeb pages. You will create new database tables and extender columns.

Students will both build new functionality and learn best practices on how to modify and extend baseline functionality. The instructor will explain and perform each step, and you will follow along and do the work yourself, on your own set of tables.

Please Note: this class does NOT cover new 2017 MVC features.

Course Level: Advanced
Instructional Method: Group Live
Duration: Two-Day Class

Prerequisites: Data Model Training is co-requisite for this course. If you take Toolkit Training, then you should take Data Model Training as well. It does not matter which order you take the courses in.

Understanding of relational databases is needed.

Understanding of Transact SQL is helpful but not absolutely essential.

You will write some basic T-SQL Select statements in this training. The more you know about NetForum from the user perspective, the better, but even a NetForum beginner can still take this course. HTML knowledge is helpful but not essential.

Class is held from 9:00 am – 5:00 pm.

NFE103 – NetForum Enterprise CMS

In this one-day course you will learn how iWeb and its counterpart eWeb are two unique, counter-facing applications, designed as the interfaces to your NetForum database. iWeb is the internal administrative web application and eWeb is the public or client- facing website. This public facing eWeb website is built and managed through the CMSmodule (Content Management System) in iWeb.

In this training, we will learn how to harness both applications to create powerful websites with dynamically driven content. This class includes a brief overview of the theory and architecture of an eWeb site followed by practical exercises designed to teach how to build a basic eWeb site, including pages, sections, and links. In addition, we will learn to extend the functionality of NetForum’s CMS through controls, web postings, and visibility SQL.

Course Level: Intermediate
Instructional Method: Group Live
Duration: One-Day Class

Prerequisites:
Understanding of basic Web design concepts, HTML, CSS. Knowledge of Transact SQL is useful for creating dynamic page templates. The exercises for this course have been designed to accommodate all levels of technical skills for a member of an organization, however, students will find that at least a basic familiarity with both SQL and HTML will greatly benefit them.

Class is held from 9:00 am – 5:00 pm.

NFE105 – NetForum Enterprise xWeb

In this one-day course, students will write some C# code for the demo ASP.NET web application using Visual Studio .NET 2.0. This web application will consume xWeb web services covered throughout the course. Students will be able to see how data entry pages, search pages, search result pages and xWeb are being used. The emphasis will be on xWeb and not .NET programming. You do NOT need to be a C# expert for this, although experience with other programming languages (PHP, Java, Ruby, VB.NET, etc.) is essential.

By the end of the training, the student will have a good understanding of how xWeb works and should have a strategy for how to integrate their applications with NetForum through xWeb. The demo application source code will be provided with working web method calls to serve as a working template to start their own applications.

Course Level: Advanced
Instructional Method: Group Live
Duration: One-Day Class

Prerequisites:
Students should be IT professionals and be familiar with web services and XML. Ideally the student will be familiar with NetForum’s data model although this is not essential for the training. Depending on how deeply you will need to mine NetForum’s data, you may eventually want to take the NetForum Data Model Training course to gain a better understanding on the NetForum database.

A student who will eventually develop an application that works with xWeb will need to know how to develop applications in .NET, PHP, or other programming languages. These languages are not taught in this course.

Class is held from 9:00 am – 5:00 pm.

FA102 – MIP Fund Accounting Administration & Financial Reporting Workshop

Course Level: Intermediate

Prerequisites: FA101 – MIP Fund Accounting Core Workshop or at least six months experience working with transactions and reports.

Instructional Method: Group Live

Recommended CPE Credits: 14
Two-Day Class

Building on the topics discussed in the Core Accounting workshop, this advanced 2-day course is ideal for Controllers or Chief Financial Officers responsible for high level administrative tasks and advanced financial reporting. Topics discussed in this course include: accounting administration, general ledger, and general reporting, a deep dive into financial statements, and advanced financial statement features, and fiscal year closing activities.

To get the most from this course we recommend that customers first take the FA101 – MIP Fund Accounting Core Workshop or have at least six months experience working with a variety of transactions and creating custom reports.

Class is held:
Thursday 8:30 a.m. – 5:00 p.m. and
Friday 8:30 a.m. – 3:00 p.m.

FA101 – MIP Fund Accounting Core Workshop

Course Level: Basic
Prerequisites: We recommend a general understanding of product navigation.

Instructional Method: Group Live
Recommended CPE Credits: 20
Two and One-Half Day Class

This intensive 2.5 day course focuses on primary financial activities, providing a strong foundation for new customers and a broad understanding for more experienced customers. This course is ideal for accounts payable professionals, staff accountants, and the hands-on Chief Financial Officer.

You will learn core features of the general ledger, accounts payable, bank reconciliation, budget, and reporting modules. Study topics include creating and maintaining chart of account codes, processing and correcting accounts payable and general ledger transactions, creating and monitoring budgets, and reconciling bank accounts. You will also learn how to use the powerful built-in reporting tools to create reports and perform analysis.

Class is held Monday from 1:00 – 5:00 p.m.
plus Tuesday and Wednesday, 8:30 a.m. – 5:00 p.m.