ODBC Data Mining

Overview:

ProfitKey’s ODBC Data Mining Course is a one-day, comprehensive hands-on seminar for the beginning Microsoft Access user. The course has hands-on use of Microsoft Access and ODBC links to ProfitKey data, building several examples of queries, gaining complexity along the way.

Users will have hands-on exercises, and wrap up the day with the chance to build a query and report they may wish to take home and utilize on their own ProfitKey system.

An optional second day of advanced training is also offered.

Who Should Attend:

ProfitKey users wishing to get ProfitKey data into a Microsoft Access database for reporting purposes.

Note: Version 5.6.x of ProfitKey DOES NOTsupport ODBC data transfer.

Location:

ProfitKey’s Training Facility
Salem, New Hampshire

Optional on-site training available at ProfitKey’s standard on-site rate provided that proper training facilities are available at customer site.

Major Topics Covered:

Cost:

$450.00 per person, per day

Agenda

Day 1:

Beginning Access

Day 2:

The Advanced ODBC Data Mining Course will cover ODBC security, the query development process of multiple tables, multiple queries, reports, sub-reports, as well as multiple "parent-child" files, "sibling" searches, the IF….THEN….ELSE… conditions, and mixing of local tables with linked table data. It will utilize extensive Microsoft Access examples to demonstrate the effects of these advanced techniques. Microsoft Excel and Seagate Crystal Reports will also be used to show their ability for ODBC data reporting.

Intermediate Access