Progressive Training & Development courses

...along with getting an introduction to SQL (Structured Query Language), a look at some other Query types and options, and create forms from scratch...

...This course looks at setting databases up for other people to use. You will learn how to automate the flow of your database using a start up screen...

...Modules Writing your Functions Using functions in Queries and Forms Form-Event Procedures Using Form Events Code Behind Forms Changing Form Properties...

...of the more powerful facilities of MS Access made available by VBA. This course explores the VBA language introducing features and functionality that will encourage confidence...

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

...proxy An introduction to Particle playground A guide to effects in After Effects 3D channel effects Using sound in After Effects Adding and previewing...

...Keylight keyer DAY TWO Compiling your project Optimising project settings Rendering the composition Filters and transitions An in-depth look at After Effects filters including...

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

...ads Websites Designing With Type Type (& Life) Concord Conflict Contrast Categories of Type Oldstyle Modern...

...This course gives photographers a thorough introduction to the theory and practice of digital photography. You will also get hands-on experience with Adobe Photoshop...

...Creating forms Creating a form Form processing Setting focus on a form Adding JavaScript Form validation in Dreamweaver Testing, maintenance and uploading Checking accessibility...

...PREREQUISITES Basic PC knowledge required INTRODUCTION TO MICROSOFT EXCEL What Is Excel? Excel File Types Excel Environment Toolbars Office Assistant WORKBOOKS...

...AND FUNCTIONS Using The Series Command Using The Insert Function Wizard Using The Excel Function Categories Most Recently Used Functions Financial Functions...

...AND CONSOLIDATION Sharing Workbooks Sending Workbooks Consolidation...

...PREREQUISITES You need to have basic knowledge of MS Excel 2003. It would help if you have used Pivot Tables in the past, but this is not essential PIVOT...

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

...USING VBA TO CREATE PIVOT TABLES Introduction to VBA Tricks of the trade Versions Build a Pivot Table in Excel VBA Revenue by Model for a Product...

...sheets Inserting three more sheets and naming them Running an Advanced Filter Inserting a Logo Exporting a Sheet to text Create a Pivot Table Protect...

...left, right, mid, instr) Working out what kind of value is residing in a cell (isnumeric, isstring, isdate... etc) Creating your own Functions A value...

...Adding Buttons Customising the buttons Resetting all in-built toolbars Preventing any design changes to your toolbar Creating a Menu using VBA Creating...