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

...Standard Toolbar Formatting Toolbar Formats Formatting Font Formatting Paragraph Formatting Production Page Setup Features Headers And Footers Bullet Lists... Learn about: Microsoft Office...

...Forms and Reports are introduced mostly using the inbuilt wizards. DESCRIPTION This course provides an introduction to using Microsoft Access for database creation...

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

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

...This course looks at setting databases up for other people to use. You will learn how to automate the flow of your database using a start up screen...

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

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

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

...Manipulating Data through Data Access Objects Data Access Objects (DAO) ActiveX Data Objects (ADO) Handling Databases Database, Recordsets and Dynaset...

...Dashboard Information Management Tools Setting up the Product and Service Items List Using the Product and Service Items List Importing Data Exporting...

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

...AND FUNCTIONS Using The Series Command Using The Insert Function Wizard Using The Excel Function Categories Most Recently Used Functions Financial Functions...

...AND CONSOLIDATION Sharing Workbooks Sending Workbooks Consolidation...

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

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

...Sort Order Manually Sum, Average, Count, Min, Max and More Report percentages...

...Links Using Other Links TABLES AND CELLS Working with Tables Working with Cells WORKING WITH WEB PAGES Using text and graphics Linking pages Creating...

...a Workspace Member Changing Permissions Assigned to a Workspace Role Exploring a Groove Workspace Adding Files to the Files Tool Adding a Tool to a Standard...