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

...using Office 2003 or Office 2007 INTRODUCTION TO MICROSOFT WORD What Is Word? Create A New Document Opening Saving Quitting And Closing Word Interface... Learn about: Microsoft Office...

...Adding a Calculation Moving and Resizing Objects Understanding Properties of a Form SIMPLE REPORTS What is a Report Why use a Report Creating a Report...

...This course takes you deeper into each of the Access objects. You learn about table relationships, queries that perform an action, and look a little...

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

...(or Switchboard), and learn how to use macros in Access. Please note that macros are not VBA. DESCRIPTION This course looks at setting databases up for other people to...

...This course offers delegates an introduction to the design and programming of relational database systems. In particular, the course covers ER (entity-relationship)...

...additional issues to be considered in a multi-user environment. PREREQUISITES Intermediate MS Access experience, or intermediate experience of a similar database application...

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

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

...Manager Using the Business Contact Manager Dashboard Using the Business Contact Manager Menu Using the Business Contact Manager Toolbar Removing a Database...

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

...PREREQUISITES You need to be comfortable with Excel basics, including using sum functions and typical navigation around a spreadsheet. VIEWING WORKSHEETS...

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

...Code to your Macro Adding Comments to VBA Code Declaring Variables Prompting for User Input Iteration over a Range Using IF Then Else Statements EXPERT...

...Using AutoFormat Applying your own Style Setting Table Options Grand totals for columns and rows AutoFormat table Subtotal hidden Page items Merged Labels...

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

...Editing text Aligning text Creating bulleted lists Adding paragraphs COLOURS Selecting colours Using the More Colours dialog box Using the Colour dialog...

...Workspace Managing Your Groove Contacts Adding New Contacts Working with Identities Setting Online Presence Preferences Listing Yourself in Directories...