Progressive Training & Development courses

...as well as introducing new features! PREREQUISITES This course is aimed at current experienced users of Office 2003, XP or 2000. It can be tailored...

...Formatting and Editing text Adding Text To A Slide Formatting Text Using Spell Check Slide Design Using Design Templates Applying Animation Schemes Drawings... Learn about: Microsoft Office...

...focussing mostly on table design and select queries. Forms and Reports are introduced mostly using the inbuilt wizards. PREREQUISITES Must be confident...

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

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

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

...In particular, the course covers ER (entity-relationship) approaches to data modelling, the relational model of relational database management systems (RBMS)...

...What is SQL An Introduction to ANSI Structured Query Language (SQL) SQL and Relational Databases Definitions Data Organisation What does SQL...

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

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

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

...It touches on Beginner, Intermediate and Advanced features. DESCRIPTION If you have some Excel knowledge, or no Excel knowledge, this course takes...

...Functions Correcting Formulas Using The Formula Error Checker Using The Formula Auditing Toolbar Using The Watch Window DATABASE AND LIST MANAGEMENT Using...

...This course takes Excel to its limits, introducing automated templates, the use of macros, using WhatIf Logic, and sharing spreadsheets. DESCRIPTION...

...Reference Macro Assigning a Keystroke to a Macro Copying a Macro from a Workbook or Template Visual Basic and Macros Opening the Visual Basic Editor Adding...

...Preserve Formatting Repeat Item Labels on Each Printed Page Mark Totals with * Page Layout For Error Values Show For Empty Cells Show Set Print Titles...

...About MS Query Analyze a dataset with more than 83,000 records with a Pivot Table Importing and Using External data without the PivotTable Wizard Creating...

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

...Creating a New Web File VIEWS Moving Around the Workspace Changing the Page Window TOOLBARS The Standard Toolbar The Formatting Toolbar TEXT Adding...

...Off From Your Groove Account Working with the Groove Launchbar Using Your Groove Account on a Second Computer Setting Account Preferences Setting...