Progressive Training & Development courses

...features New formula features New chart features Themes and styles Instant conditional formatting POWERPOINT 2007 PowerPoint 2007 new features Ribbons...

...Entering Functions Percentages Formatting and Customising Data Selecting Items In Excel Formatting Text Formatting Numbers Manipulating Data Formatting... Learn about: Microsoft Office...

...in at least one other Microsoft Application, preferably Excel. INTRODUCTION Database Basic Concepts Database Object Overview USING TABLES Field Names...

...closely at some of the form and report functionalities. DESCRIPTION This course takes you deeper into each of the Access objects. You learn about table relationships...

...and create forms from scratch. You also look at exporting Reports. DESCRIPTION You learn about some maintenance features in Access, along with getting...

...with conditions Attaching Macros to a Form Attaching Macros to a Report Filtering Records Commenting Macros Macro Names Printing Macro Definitions Viewing...

...approaches to data modelling, the relational model of relational database management systems (RBMS) and the use of query languages such as...

...to write and test a range of SQL queries within MS Access. One of the sections adopts a more theoretical approach in attempting to raise awareness of...

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

...This course explores the VBA language introducing features and functionality that will encourage confidence, control and creative use of MS Access...

...It must be used with Microsoft Outlook; it cannot be launched on its own. PREREQUISITES Exposure to MS Outlook is mandatory. CONFIGURING BUSINESS CONTACT...

...quickly from basic knowledge to a greater understanding of Excel's features. It touches on Beginner, Intermediate and Advanced features. PREREQUISITES...

...Another Application Embedding And Linking Objects Hyperlinks Managing Links...

...Validation Documentation CUSTOMISING EXCEL 2003 Configuring Excel 2003 Options Customising The Excel Environment Working With Workspaces COLLABORATION...

...DESCRIPTION This course is designed for the Power Excel user who wants to use his Excel spreadsheets as applications in their own right. It introduces...

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

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

...Office Groove 2007 is a collaboration software program that helps teams work together dynamically and effectively, even if team members work for different organizations...