Progressive Training & Development courses

...You also look at exporting Reports. PREREQUISITES Must have attended Access Level 1-2, or be confident with what tables, queries, forms and reports...

...Running a macro Stepping through a macro Modifying a macro Adding Conditions to Macros Using the Expression builder to create Conditions Running macros...

...versus Visual Basic for Applications Visual Basic for Applications Development Environment VBA Objects and the Browser VBA Procedures VBA Language...

...Manipulating Data through Data Access Objects Data Access Objects (DAO) ActiveX Data Objects (ADO) Handling Databases Database, Recordsets and Dynaset...

...Define Articles Modifying PDF Documents Manipulate PDF Document Pages Edit Content in a PDF Document Add Page Elements Extract Content from a PDF Document...

...Auto-tracing alpha channels Importing masks from Photoshop Creating Track mattes Using Keylight for Bluescreen and Greenscreen mattes Generating professional...

...elements Precisely controlling animations Synchronising actions Parent/child relationships Working with the z-axis Trimming layers Introduction to using...

...Sharing Your Database Managing Your Database Using the Dashboard Links Using the Help Menu USING BUSINESS CONTACT MANAGER Accounts Opening the Accounts...

...How to get it What to avoid Using Colour The amazing colour wheel Colour Relationships Shades and tints Watch the tones Warm colours vs Cool Colours How to begin to choose?...

...Lens focus length Chips Image Quality Digital file formats Pixels Compression What settings to use Mega-pixels needed for particular image sizes File fundamentals...

...pages with CSS Dreamweaver CSS templates Inserting DIV tags Using the rulers and guides Drawing layers to design your pages Adding CSS to a layer Working...

...It touches on Beginner, Intermediate and Advanced features. DESCRIPTION If you have some Excel knowledge, or no Excel knowledge, this course takes...

...It also introduces Excel as a possible database application. You look at graphically representing your data as well as improving its appeal with graphics...

...WhatIf Analysis Goal Seek Data Tables Scenario Manager Solver Using Pivot Tables MACROS AND CUSTOM CONTROLS Working With Macros Running Macros Adding Custom...

...Managing and maintaining your Pivot Table Calculations...

...Working with Disparate Data Sources Using Multiple Consolidation ranges The Anatomy of a Multiple Consolidation range Pivot table Creating a Pivot Table...

...Manager Handle Additional Annoyances Issues with Two or more Data Fields Summarize Date Fields with Grouping Advanced Pivot Table Techniques Control...

...the macro results Understanding Code Formatting (Indents, etc) Reading from and writing to a cell Absolute vs Relative Referencing Playing back VBA Stepping...

...common worksheet operations, convert worksheets into forms and understand Excel VBA code. PREREQUISITES Must least have had sufficient exposure to...

...exposure to the concepts covered in Levels 1 and 2. Revision of Level 2 Speeding up your macros Turning off screen updating Using the status bar to...