Progressive Training & Development courses

...Baffled by Office 2007? This course is aimed at demystifying Microsoft Office 2007 and getting you up to speed quickly. Your experienced trainer will point...

...Worksheets Working With Cells Navigating Within A Worksheet Navigating The Workbook Understanding Dates Inserting and deleting rows, columns... Learn about: Microsoft Office...

...using the wizard Making simple formatting changes Moving and Resizing Objects Understanding Properties of a...

...Relating Tables Join Types Deleting Relationships Enforcing Relationships QUERIES Querying multiple tables Parameter Queries Totals Queries Delete Queries...

...You also look at exporting Reports. PREREQUISITES Must have attended Access Level 1-2, or be confident with what tables, queries, forms and reports...

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

...What is a database Database tables Table Relationships Using Queries Using Forms Stages in Database Design Tables/Entities Determining Attributes / Columns...

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

...wishing to learn VBA will find it a quick and valuable introduction to the language. Throughout the course the theme of adopting good programming practices...

...The course is aimed at those with little or no previous. DESCRIPTION This course has been designed for the advanced Access user who wishes to make...

...the Business Projects and Project Tasks Folders Editing Business Tasks and Projects Viewing Business Tasks and Projects Communications History and Linking...

...If you have some Excel knowledge, or no Excel knowledge, this course takes you quickly from basic knowledge to a greater understanding of Excel's features...

...Databases Creating And Editing A Database Sorting A Database Using Autofilters Advanced Filters Working With Filtered Data Using Data Forms CHARTS Chart...

...WhatIf Analysis Goal Seek Data Tables Scenario Manager Solver Using Pivot Tables MACROS AND CUSTOM CONTROLS Working With Macros Running Macros Adding Custom...

...Add-ins Using the Trust Center Add-Ins Information Rights Management What is IRM? Requirements for IRM Downloading and Installing the Rights Management...

...Numeric Formats in Data Fields Changing Summary Calculations Adding and Removing Subtotals Using Running Total Options FORMATTING YOUR PIVOT TABLE REPORT...

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

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

...custom link bar Creating thumbnails PUBLISHING Previewing the web site Trouble-Shooting Using a server or disk-based web sites Using web servers HTTP publishing...

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