Progressive Training & Development courses

...them The new file formats - XML WORD 2007 Word 2007 new features The tab system Toolbars and ribbons Building blocks WorkFlows EXCEL 2007 Excel 2007...

...such as letters, faxes, etc. Excel is for spreadsheet work where you may be number crunching or wanting to analyse data. PowerPoint is a presentations application... Learn about: Microsoft Office...

...This course provides an introduction to using Microsoft Access for database creation, focussing mostly on table design and select queries. Forms and Reports...

...Conditional formatting Creating multi-table forms REPORTS Using the wizard to create grouped reports Understanding the design Manually changing grouping...

...Using Text Functions Forms Creating from scratch Using Combo Boxes and List Boxes Changing the source of a text box Adding in a company logo Creating...

...PREREQUISITES Must be a fairly confident Access user. You've created databases a few times and know about relating tables. You are familiar with the concepts...

...and the use of query languages such as SQL. The first two sections are supplemented with many practical exercises. The delegate will have the opportunity...

...Aggregate Functions Additional Functions Additional Clauses Data Records Maintenance Database Maintenance UPDATE / INSERT / DELETE Database Structural...

...control and creative use of MS Access. The course is aimed at those with little or no previous programming background, although experienced programmers...

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

...DESCRIPTION Business Contact Manageris a product first released with Office 2003. It works with Outlook, adding customer and sales management tools...

...Using the format painter PRINTING Using Page Setup Margins Headers And Footers Printing A Spreadsheet CHARTS Chart Wizard Chart Toolbar Working With Charts...

...This course takes the beginner into more of the time saving features of Excel, exploring many different types of built in functions. It also introduces...

...Text Files Using Microsoft Query Querying Data From The Web Refreshing Data TEMPLATES AND STYLES Working With Templates Working With Styles ANALYSING...

...Client Software Using IRM Opening an IRM Protected Document Digital Signatures What is a Digital Signature? Obtaining a Digital Signature Attaching...

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

...Dynamic Pivot Table Reporting Systems Pivot Table data options LEVERAGING THE POWER OF OLAP CUBES Defining OLAP Benefits of OLAP Cubes Introduction...

...or at least have some programming experience so that you are aware of basic programming techniques. ENHANCING YOUR PIVOT TABLE REPORTS WITH MACROS...

...box Removing custom colours IMAGES Adding images Removing images Resizing images Using .jpg files Using .gif files LINKS Using Hyperlinks Using E-mail...

...work remotely, or work offline. Working in Groove workspaces saves time, increases productivity, and strengthens the quality of team deliverables Office...