Instructor Led Table Training - Training Resources

5th Business Process Innovation Conference This conference will tackle three complementary management disciplines in a blended approach: - Execution and improvement of your business processes through Business Process Management (BPM) - Selection and implementation of the necessary improvement initiatives through Enterprise Project Management (EPM) - Knowledge discovery & management on both current performance as future improvement  more...

Microsoft Access 2007 Database Design Learn to identify the components of a database, open a table & find information stored in it, create & customize table designs, enter data & validate using input validation formulas, create relationships between tables to ensure data accuracy...  more...

Microsoft Access Level 1 Intro This course will consist of the following lessons: Starting Out Using the Access Interface Getting Help Creating a Database Records Creating a Table Formatting Text Formatting Controls Creating Forms Creating Queries and more!  more...

JavaScript Advanced Scripting - eliquo Take your JavaScript to the next level by creating reusable functions & storing information in browser cookies. We ll show you how to easily alternate table row background colours, rotate banners, &control your CSS to create dynamic layouts as well.  more...

Excel Upgrade to 2007 - 1 Day Topics include: the brand new user-interface, changes in spreadsheet limits, themes and styles, conditional formatting, improved formula writing, improved sorting and filtering, table enhancements, the new look of charts, improved pivot tables and more  more...

Adobe InDesign CS4 Styles and Multipage Documents Now that you can create, import and modify your content in InDesign, ita ™s time to create styled, multipage documents. Wea ™ll show you how to save time and create consistency using libraries and object, text and table styles. Master Pages will help you add headers, footers and pagination to your multipage documents. Wea ™ll also show you some advanced text options such as bullets  more...

Microsoft Word 2007 Level 3 UOA This course is intended for students with intermediate to advanced experience in Word. This course is designed for those students who manage long documents using tools such as master documents, indexes, table of contents, SmartArt, and Charts.  more...

Adobe InDesign CS4 Large Scale Publishing Learn how to produce large-scale publishing projects using the industry-standard desktop publishing software Adobe InDesign CS4. This course will introduce you to large-scale publishing techniques such as libraries, books, table of contents, indexes...  more...

Microsoft Word 2003 Intermediate - compuease Upon completion you will be comfortable using the Mail Merge function with different data sources; able to apply various Styles, Templates and Forms that ensure document consistency; learn how to generate a Table of Contents and Indexes.  more...

Access 2003 Foundation - CIT This course provides competency in database fundamentals, working with Access objects, creating databases & tables, working with table data &structure, working with related tables, using select queries & advanced query features, creating advanced queries  more...

Microsoft Access 2007 Level 1 - Data Entry and Reports Upon completion, students will: Identify & work with the components of a database; Open a table, find information & enter data; Create several query types, edit & run queries, use action & calculation queries; Create several report type, enhance reports.  more...

Microsoft Word 20022003 Level 3 - on track Topics included in this 1 day course are : Styles and templates, online forms, bullets and numbering, outline, indexes and table of contents, macros, text boxes, graphics, drawing in word and more.  more...

Word 2007 Intermediate - cdouglas Topics included in this 1 day instructor-led course: Using word's table feature; Formatting text; Using graphics including: boxes, lines and shading, office art and clip gallery; Using Word's merge feature, creating labels/ envelopes and more.  more...

Microsoft Access 2007 Level 1 Database Design Topics included in this 2 day course: The basics, table data, table design, data entry, relationships, creating & using forms, queries, reports, importing & Exporting data, printing and more  more...

Word 2007 Advanced - computer help Topics include: fields, bookmarks, styles, autoformat, combining documents, tracking changes, inserting objects, linking, document map, splitting a document, advanced outline numbering, table of contents, forms, templates, customizing word, and macros.  more...

MS Excel 2003 Level 2 - 1 Day HBI Description: Upon successful completion of this course, students will be able to: calculate with advanced formulas. organize worksheet and table data using various techniques. create and modify charts. analyze data using PivotTables and PivotCharts. insert graphic objects. customize and enhance workbooks and the Microsoft Office Excel environment.  more...

Access Training Intermediate Level- Compuease Upon completion of this course, participants will be familiar with advanced Table Design. They will also be more comfortable using complex queries, forms and reports. Participants will also receive a certificate of completion.  more...

Microsoft Excel 2000 2003 Level 3 Data List Management - nexient Who should attend? This course is intended for participants who are familiar with Excel 2000/ 2002/ 2003. Performance Objectives Upon completion of the course, participants will be able to accomplish the following: Add, edit, search for, and delete records in a data list using a form, look up data Sort records in a data list using a variety of methods Filter data in a list using a  more...

Access 2003 Introduction 2 Days This course provides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Microsoft Word 2002 - 2003 Level 3 - on track Topics included in this 1 day course are : Styles and templates, online forms, bullets and numbering, outline, indexes and table of contents, macros, text boxes, graphics, drawing in word and more.  more...

Microsoft Office FrontPage 2003 Level 2 ...ponents to your site, including search, image maps, and a table of contents. - create Web forms and save collected data to a file and a database. - add dynamic content to Web pages. - manage workgroup-based development of FrontPage webs. - maintain a site with FrontPage tools. Course Content Lesson 1: Laying Out a Page with Frames Topic 1A: Create Frames Pages Topic 1B: Add  more...

Access 2003 Queries 2 Days- Last Minute Training Topics covered: query types (select, append, update, delete, make-table and crosstab), basic and advanced criteria, totals, union & parameter queries, referencing forms, properties, expression columns, and writing simple SQL statements.  more...

Excel 2007 Upgrade 1 Day This course is a must if you want to get up to speed quickly with the many changes and improvements in Excel version 2007. Topics include: the brand new user-interface, changes in spreadsheet limits, themes and styles, conditional formatting, improved formula writing, improved sorting and filtering, table enhancements, the new look of charts, improved pivot tables, new file formats, changes in  more...

Access 2007 Introduction 2 Days This course provides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Access 2003 - Level 2 1 Day ... a simple database. - create a new database with related tables. - control data entry by modifying the design of a table to streamline data entry and maintain data integrity. - find and retrieve desired data by using filters and joins between tables and within a single table. - create flexible queries to display specified records; allow for user-determined query criteria; and add,  more...

Excel Datalist Management 2007 Upon completion of the course, participants will be able to accomplish the following: * Add, edit, search for, and delete records in a data list using a form, as well as look up data * Sort records in a data list using a variety of methods * Filter data in a list using a variety of methods, as well as work with filtered data * Create and work with subtotalled lists, as well  more...

MS Access 2007 Level 1 - 2 Day - HBI Upon successful completion of this course, students will be able to: examine the basic database concepts and explore the Microsoft Office Access 2007 environment. design a simple database. build a new database with related tables. manage data in a table. query a database using different methods. design forms. generate reports.  more...

Microsoft Access 2000 - 2003 Level 1 Database Design - nexient ...ts of a database, and work with those components Open a table, find information stored there, and enter data Create a table design from a template, and customize it Enter data into tables, and ensure its accuracy by using input masks and input validation formulas Create relationships between tables to ensure data accuracy and to deploy referential integrity Create forms for entering  more...

Microsoft Access 2000 - 2003 Level 1 Database Design nexient ...ts of a database, and work with those components Open a table, find information stored there, and enter data Create a table design from a template, and customize it Enter data into tables, and ensure its accuracy by using input masks and input validation formulas Create relationships between tables to ensure data accuracy and to deploy referential integrity Create forms for entering  more...

Microsoft Access 2003 XP Level I II Mon Wed This course covers table creation, relationships, extracting information using queries, designing forms and creating reports.  more...

Microsoft Office Access 2007 Foundation ... Step-By-Step Skill Sharpener Create Ribbon Tables Forms Reports Other Step-By-Step Skill Sharpener External Data Ribbon Import Export Collect and Data SharePoint Lists Step-By-Step Skill Sharpener Database Tools Ribbon Macro Show/ Hide Analyze Move Data Database Tools  more...

Advanced Access This Access course is designed for users who are comfortable with basic Access features including creating tables, reports and queries. In the course, participants will create a multi-table database with queries, reports and a customized startup screen.  more...

Excel 2003 Analyzing Summarizing Data with Pivot Tables Do you want learn why and when you can use a pivot table or pivot chart to analyze and summarize data. This workout covers creating and modifying pivot tables, filtering and formatting data, customizing pivot table options, and creating pivot charts.  more...

Access 2003 Working with Table Relationships When data in your database displays in more than one table, do you know how the information is related? Do you know how to properly modify the relationships when necessary?  more...

Access 2003 Making the Most of Tables Do you want to manipulate and customize your tables to make them more effective? Do you want to learn to customize data properties, import data into a table, and link tables to another database or to an Excel spreadsheet?  more...

Excel 2007 Analyzing and Summarizing Data with Pivot Tables Do you need to analyze data? Learn why and when you can use a pivot table or pivot chart to analyze and summarize data. This workout covers creating and modifying pivot tables, filtering and formatting data, customizing pivot table options, and creating pivot charts.  more...

Access 2007 Working with Table Relationships When data in your database displays in more than one table, do you know how the information is related? Do you know how to properly modify the relationships when necessary?  more...

MS Access 2007 Level 1 - 1 Day Upon successful completion of this course, students will be able to: * examine the basic database concepts and explore the Microsoft Office Access 2007 environment. * design a simple database. * build a new database with related tables. * manage data in a table. * query a database using different methods. * design forms. * generate reports.  more...

Access 2003 Foundation Access Basics Database Terminology What Is A Table? What Is A Record? What Is A Form? What Is A Report? What Is A Query?  more...

Microsoft Word 2000 Level 2 ...e 1: Working with Autoformat | Module 2: Working With Tables| | Module 3: Editing A Table | Module 4: Applying Borders And Shading | Module 5: Working With Drawing Objects | Module 6: Inserting Graphics | Module 7: Using Charts And Diagrams | Module 9: Using Autotext | Module 10: Using Find And Replace | Module 11: Using The Thesaurus | Module 12:  more...

Microsoft Access 2007 Level 1 Objectives * Opening and Modifying Database Objects * Working with Multiple Windows * Adding, Editing, and Deleting Records * Tour of a Form, Query, or a Report * Planning and Creating a Database * Create a Table Using the Table Wizard * Create a Report Using the Report Wizard * Create a Form Using the Form Wizard * Database Object Management *  more...

Excel Datalist Management Upon completion of the course, participants will be able to accomplish the following: * Add, edit, search for, and delete records in a data list using a form, as well as look up data * Sort records in a data list using a variety of methods * Filter data in a list using a variety of methods, as well as work with filtered data * Create and work with subtotalled lists, as well  more...

PowerPoint 2007 Upgrade 1 Day PowerPoint version 2007 has a completely new look and many changes and improvements. During this course wea ll take a look at these differences, including, the new fluent interface, themes and quick styles, custom slide layouts, designer-quality SmartArt graphics, new and improved effects, new text options, table and chart enhancements, proofing tools, presenter view, sharing information, new  more...

Microsoft Access 2003 XP Level I II This course covers table creation, relationships, extracting information using queries, designing forms and creating reports. Advanced queries including action queries, advanced forms and reports including sub forms and sub reports, import/ export, and macros will also be covered.  more...

Microsoft Word Training - Intermediate Upon completion you will be comfortable using the Mail Merge function with different data sources; able to apply various Styles, Templates and Forms that ensure document consistency; learn how to generate a Table of Contents and Indexes.  more...

Access Introduction - Level 1 This course provides competency in database fundamentals, working with Access objects, creating databases and tables, working with table data and structure, locating information, working with related tables, using select queries and advanced query features, and creating advanced queries.  more...

Microsoft Frontpage Introduction Students will be able to create a new FrontPage web; create links between and within web pages; apply formatting to characters and paragraphs and apply themes; insert, size, align, and link images; create, modify, and enhance a table; perform basic web page management techniques.  more...

Microsoft Access Introduction (2 Days) Microsoft Access is a relational database management system from Microsoft which combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a member of the Microsoft Office system. In this 2-day introductory course for Microsoft Access, users will learn: The Basics Table Data Table Design Data Entry Relationships Creating  more...

Word 2003 Tables Merge 1 Day This course looks at two very powerful features in Word: Tables and Merge. Each topic is covered extensively during this one day course. You will leave with a complete understanding of creating basic and advanced tables, as well knowing exactly what the merge feature is capable of doing. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Microsoft Access XP 2003 Level 1 Objectives * Opening and Modifying Database Objects * Working with Multiple Windows * Adding, Editing, and Deleting Records * Tour of a Form, Query, or a Report * Planning and Creating a Database * Create a Table Using the Table Wizard * Create a Report Using the Report Wizard * Create a Form Using the Form Wizard * Database Object Management *  more...

Microsoft Access XP 2003 Level 3 Objectives: * Explain 3 steps to normalize a database * Explain 3 types of database relationships * Use the Table Analyzer Wizard * Explain query join properties * Create command buttons on a form and attach macros * Create action queries * And much, much more...  more...

Budget and Cost Planning For managers in todays business world, its essential to have a working knowledge of finance. We all play a role in our organizations finances, whether we realize it or not. For those who dont have training or a background in finance, you may be at a disadvantage as you sit around the management table. Understanding the cycle of finance will help you figure out where you fit into your companys  more...

MS Access Level 1 Training Seminar This course will provide you with the skills necessary to begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other applications, modify table design to control data entry, find data, filters, queries, customize forms and  more...

Negotiation Skills The focus of this workshop is creating win, win, win sales scenarios in which your client, your company and you all walk away from the negotiation table feeling satisfied with the final outcome. Learn how to make negotiation easy, enjoyable and fun by attending this presentation! Anyone who is new to professional selling and looking for the tools, techniques and advantages that will get them off  more...

Microsoft Word Training - Intermediate (French Instructions, French Language) Upon completion you will be comfortable using the Mail Merge function with different data sources; able to apply various Styles, Templates and Forms that ensure document consistency; learn how to generate a Table of Contents and Indexes.  more...

Microsoft Access 2007 - Module 1 Basic 2 Days Objectives * Understand data base architecture and its components * Opening, closing data base and handling objects * Knowledge about table structure * Creating single queries * Creating single form and report  more...

Microsoft Access - Module 2 - Multi Table queries and relations This course is the second of seven modules (levels) that we have to offer for Microsoft Access 2000/2002/2003. Objectives * Fundamental Principles of data base * Creating multi tables queries * Working with formula and functions * Knowledge about relations * Applying referential Integrity  more...

Microsoft Access - Module 1 Basic 2 Days Objectives * Understand data base architecture and its components * Opening, closing data base and handling objects * Knowledge about table structure * Creating single queries * Creating single form and report  more...

Adobe InDesign Introduction (French Instruction, English Software) Location: Ottawa Date: 2008-05-12 List Price: $320 Offered Price: $256.00 Seats Available: 2 In this course to Adobe InDesign, we will introduce many features that are available and teach you the basics including: Managing the InDesign environment; Designing Documents; Managing Text; Utilizing Colours, Swatches, and Gradients; Utilizing Table; Creating Acrobat PDF Files; and much much more. For  more...

Microsoft Access Level 1 Training Seminar (2 Days) ... Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other applications, modify table design to control data entry, find data, filters, queries, customize forms and reports, and create data access pages. For more information please  more...

Microsoft Word 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-03-17 List Price: $199 Offered Price: $139.00 Seats Available: 2 By the end of this course, participants will know how to: * Create and Use a Document Template * Create and Apply Paragraph Styles and a Character Style * Drawing on Your Documents * Inserting and Formatting Pictures * Performing a Mail Merge * Accepting and Rejecting  more...

Microsoft Excel 2003 Level 3 ...: $160.00 Seats Available: 1 Outline Section 1 - Pivot Tables What is a Pivot Table? Creating a Simple Pivot Table Changing the Layout of a Pivot Table Creating a Spreadsheet for each Page of thePivot Table Multiple Field Headings on Page Axis Refreshing a Pivot Table Structured Selection Formatting a Pivot Table Adding or Removing Fields Renaming Fields Sorting Field Items  more...

Microsoft Word 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-02-08 List Price: $199 Offered Price: $139.00 Seats Available: 2 Objectives Create and Use a Document Template Create and Apply Paragraph Styles and a Character Style Drawing on Your Documents Inserting and Formatting Pictures Performing a Mail Merge Accepting and Rejecting Revisions Protecting a Document Viewing, Modifying, and Numbering an Outline  more...

Microsoft Access 2003 Level 1 (1 Day) Location: Vancouver Date: 2008-02-04 List Price: $279 Offered Price: $195.00 Seats Available: 2 Objectives Opening and Modifying Database Objects Working with Multiple Windows Adding, Editing, and Deleting Records Tour of a Form, Query, or a Report Planning and Creating a Database Create a Table Using the Table Wizard Create a Report Using the Report Wizard Create a Form Using the Form  more...

Microsoft Word 2003 Level 3 - Bilingual ... Merging Mailing Labels And Directories Module 2: Sorting Table Data Module 3: Using Formulas In Tables Module 4: Importing Excel Worksheets Module 5: Working with Lists Module 6: Using Macros Module 7: Using Forms Module 8: Tracking Revisions Module 9: Formatting Long Documents Module 10: Creating A Table Of Contents Module 11: Creating An Index Module 12: Using Bookmarks Module 13: Using  more...

Microsoft Excel 2003 Level 3 ...ed Price: $160.00 Seats Available: 2 Section 1 - Pivot Tables What is a Pivot Table? Creating a Simple Pivot Table Changing the Layout of a Pivot Table Creating a Spreadsheet for each Page of thePivot Table Multiple Field Headings on Page Axis Refreshing a Pivot Table Structured Selection Formatting a Pivot Table Adding or Removing Fields Renaming Fields Sorting Field Items  more...

MS Access Level 1 Training Seminar Location: City of Mississauga Date: 2007-07-16 List Price: $495 Offered Price: $346.00 Seats Available: 2 This course will provide you with the skills necessary to begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other  more...

Access Introduction-2 Days Location: Toronto Date: 2007-07-05 List Price: $550 Offered Price: $350.00 Seats Available: 2 This course provides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided.  more...

Adobe InDesign Introduction ...Apply Transparency Flattener Presets Lesson 6: Utilizing Tables Topic 6A: Create a Table Topic 6B: Modify a Table Topic 6C: Format a Table Lesson 7: Preparing for Handoff to a Service Provider Topic 7A: Check Documents for Problems Topic 7B: Print a Document Topic 7C: Package Files Topic 7D: Preview Output Lesson 8: Creating Acrobat PDF Files Topic 8A: Prepare PDF Files for Web Distribution  more...

InDesign CS3 Large-Scale Publishing ...g documents synchronizing books printing/exporting books table of contents review document styles creating TOC entry styles generating the TOC saving the general TOC style updating the TOC TOC with books indexes creating index items modifying/deleting index items generating the index file indexes with books working with XML XML basics importing XML files linking/updating XML files viewing  more...

MS Access Level 1 Training Seminar Location: City of Mississauga Date: 2007-04-25 List Price: $495 Offered Price: $346.00 Seats Available: 2 This course will provide you with the skills necessary to begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other  more...

Microsoft Access 2002 (XP) Level I Location: Toronto Date: 2007-04-16 List Price: $80 Offered Price: $56.00 Seats Available: 2 This course covers table creation, relationships, extracting information using queries, designing forms and creating reports.  more...

Access Introduction-2 Days April 2-3, 2007 9:00am to 4:00pm This course provides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided. This course is classroom style instruction: Instructor-led,  more...

Access Introduction-2 Days April 9-10, 2007 9:00am-4:00pm This course provides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided.  more...

Word Level 2 Intermediate level one day instructor led course on Microsoft Word. Topics include: Working with Sections, Managing Tables and Table Data, Using Mail Merge, Styles and AutoText, Introduction to Templates, Introduction to Macros, The Internet and the Web. The prerequisite for this course is Word Level 1 or equivalent knowledge. The next course in the series is Word Level 3.  more...

Access Level 2 Intermediate level one day hands-on instructor led course on Microsoft Access. Topics include: The Principles of Table Design, The Principles of Table Relationships, Table Design Techniques, Designing Select Queries, Customising Form Designs, Working with Data Access Pages, Customising Reports. The prerequisite for this course is Access Level 1 or equivalent knowledge.  more...

Oracle warehouse Builder Developer Track The course will be aimed at providing "hands on training for developing the OWB ETL tasks. This instructor-led course provides the skills and knowledge to beginners and practioners, to be able to successfully carry out OWB Development. In addition to gaining tremendous insight into the administration activities, students will be exposed to useful tasks expected in Real time projects. This is  more...

Finance Budgeting for HR Practitioners ...ted assumptions). Also required, as Ulrich puts it as "table stakes", are the skills of the "Business Ally" - they know how the business makes money, and have an understanding of the various parts of the business: Finance, Marketing, Research & Development and Engineering (to name but a few) and in so doing assist the organisation to succeed. This workshop is designed to provide modern  more...

Microsoft Access 2003 - Introduction / Intermediate ...tion. Manage the data in a database. Examine existing table relationships. Query the database. Design simple forms. Create and modify Access reports. SEE DAY 2 FOR MORE TOPICS Welcome to Sonic Training!. (http://www.sonictraining.com 877-760-0078) Macromedia (Dreamweaver, Flash, Fireworks), Adobe (Photoshop, InDesign, Illustrator), Database (SQL, Access, Filemaker Pro, Goldmine),  more...

Foundation Course 1. Foundation Course Project Jewelry Box Cost R 2460-00 Introduction to Woodworking - six Modules of 4 hours each. We cover the cutlist; differentiate between man made boards, soft and hard wood. Student works with the following ,sufacers, thicknessers, table saw, sliding compound miter saws as well as compound miter saws, router and router tables, sanding machines, sanding, clamp, glue as  more...

SQL Server 2008 Administration ...DTS utility *Using DTS to export and import SQL Server table data SQL Server Security management *Windows security management for the server *Windows authentication mode *SQL Server rights and role management SQL Server Backup & Recovery *Overview of SQL Server backup & recovery *Incremental backups *Restoring a SQL Server database *Standby database overview *Shipping SQL  more...

My SQL ...didate will be : Creating Database, Create and Manage Tables, Use privileges in table, Create Index, Optimize a table, Work with Stored Procedures. Job Possibilities : Web Application Developers / Software Engineer / Business Intelligence Developer / Database DesignersForms Developer / Portal Developer / Support Engineer Duration :: 32 Hrs Introduction MySql * Overview  more...

Onsite Protecting Casino Table Games This program trains investigators in game protection procedures, methods of detecting cheating and advantage play at all of the common table games. On-site training is tailored to the needs of the client casino. The training is also provided in open enrollment seminars, at specific locations and times as advertised on the website.  more...

Java Foundation Classes Swing ...ayout managers, basic controls, bounded range components, table control, menu bar and toolbar, purpose and usage of JOptionPane, JFileChooser, JColorChooser and JDialog dialogs, Pluggable Look and Feel mechanism, JTabbedPane and JScrollPane, Graphics class features and functionality, JComponent graphics enhancements, Graphics2D class and Java 2D imaging support. Audience:Java Developers  more...

DB2 -- Performance and Tuning ...s, and how to write effective SQL predicates. ' Explain ' tables and tools are covered in detail as well as additional performance tools. The optimizer is studied along with RUNSTATS to understand why index methods are chosen by the access plan. Then MQT ' s, database partitions and table partitions are explored and their relationships. Finally, monitoring with admin views is covered along with  more...

Get on Track with MS Access Intermediate Students will learn how to set table relationships, work with Lookup fields and subdatasheets, create join queries, create PivotTables and PivotCharts, and use hyperlink fields and data access pages.  more...

Mastering: Microsoft Excel PivotTables ...most neglected. Many people have never even heard of PivotTables and those who have have often seen only the most basic features of the tool. This class devotes an entire day to exploring all of the most useful and powerful aspects of Excel's PivotTables. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with  more...