Progressive Training & Development courses

...SubForm Creating a form with two Subforms Creating nested Subforms Deleing a Subform Reports Creating a SubReport Exporting a report to Snapshot Exporting...

...You will learn how to automate the flow of your database using a start up screen (or Switchboard), and learn how to use macros in Access. Please note that macros are not...

...Syntax and Code Compilation VBA Coding Variables and expressions Branching and Looping Comments and Indents Deciding on Code location Public Modules Private...

...This course has been designed for the advanced Access user who wishes to make use of the more powerful facilities of MS Access made available by...

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

...Why expressions are useful Creating expressions to slave other layers Expressions vs Parent and Child Transferring properties in equations Rendering comps...

...Creating custom rendering templates Setting field rendering order Creating PDF video files Saving your work for film, video, multimedia, mobile devices...

...DataGenerating Reports Creating a Campaign through Word Creating a Campaign through Publisher Editing Lists in a Form Editing Lists Outside a Form Working...

...CMYK vs RGB; print vs web Extra Tips & Tricks Creating a package Business cards Letterheads and envelopes Flyers Newsletters Brochures Postcards Newspaper...

...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...

...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...

...to lock cell references (Absolute referencing) Creating Named Ranges to use in formulas FORMATTING AND CUSTOMISING DATA Selecting Items In Excel Formatting...

...Date & Time Functions Math & Trig Functions Statistical Functions Lookup & Reference Functions Database Functions Text Functions Logical Functions Information...

...PREREQUISITES You need to have some exposure to charts and formulae such as sum or average. IMPORTING DATA Importing Data From External Sources Importing...

...An introduction to the power of Pivot Tables in MS Excel 2003. DESCRIPTION An introduction to the power of Pivot Tables in MS Excel 2003. PREREQUISITES...

...Data Warehouses and OLAP Cubes Connecting to an OLAP Cube Working with an OLAP Pivot Table Comparing OLAP Cube' Pivot Tables to Excel Data Other Considerations...

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

...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...

...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...