Progressive Training & Development courses

...a report to Excel Database Maintenance Compacting a database Converting to a different Access version Setting a database password...

...Macros Open a form read only Open a form for data entry only Export a table to Excel Send a report via Email Copy table to another database Print a Report...

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

...those encountered in a business database application; focusing in particular on triggering VBA from objects such as queries and forms. PREREQUISITES...

...Applications Create a PDF Document Using Acrobat Navigating to Specific Content in a PDF Document Conduct a Simple Search Use Bookmarks Work with Links...

...DAY ONE Overview of features Optimising your system Finding ways to speed up previews Using different resolutions Using Adobe Clip Notes Advanced layer...

...and refine designs Working with text Customising text presets Animating text Antialiased text Using text layers Working with key frames Animating graphic...

...Opportunities Opening the Opportunities Folder Creating an Opportunity Editing an Opportunity Opportunity Views Business Projects and Project Tasks Opening...

...you can eliminate design gremlins from your work. PREREQUISITES None Design Principals The Joshua Tree Epiphany Proximity The basic purpose How to...

...The course will give you a good understanding of the techniques needed to achieve high quality images that will be output from digital files. DESCRIPTION...

...to enable you to master. DESCRIPTION Adobe Dreamweaver CS4 is the worldwide tool of choice for those who need to design, build and manage professional websites...

...The Workbook Understanding Dates Inserting and deleting rows, columns, cells Cutting, Copying, And Pasting Using Find And Replace Using Undo And Redo Spell...

...Pictures Layering Objects Grouping And Ungrouping Objects EXCEL 2003 AND OTHER APPLICATIONS Converting Files From Other Applications Copying Data...

...Controls SECURITY AND PROOFING Security Features Protecting Excel Files Worksheet Protection Working With Digital Signatures Checking Spelling Using...

...your Data Source CUSTOMIZING FIELDS IN A PIVOT TABLE The Need to Customize Displaying the Pivot Table Field Dialog box Customising Field Names Applying...

...A further look at the power of Pivot tables and Pivot Charts, introducing getting your data from multiple sources, and opening the door to OLAP Cubes!...

...An introduction to automating Pivot Tables using Visual basic for Applications (VBA) DESCRIPTION An introduction to automating Pivot Tables using Visual...

...Explorer Project Properties The Code Window The Immediate Window Finding Macros Export and Import VBA Modules Add and Remove a module ANALYSING VBA Understanding...

...a browse for a file box Providing a GetSaveAsFileName box to save a file Using Select Case vs using If statement Expanding on Conditional Formatting limitations...

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