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

...Slides Formatting and Editing Slides Working With Slide Layouts Applying Backgrounds Modifying Slide Attributes Paragraph Settings Bullets And Numbering... Learn about: Microsoft Office...

...Records Navigating around a table Entering Data Deleting Records Modifying the datasheet Moving Columns (Fields) Hiding/Unhiding Fields Understanding Table...

...queries that perform an action, and look a little more closely at some of the form and report functionalities. PREREQUISITES Must have attended Access Level...

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

...file so users have to log-in to the database Working with macros (Not VBA) Understanding and Exploring Macros Using the Macro window Toolbar Creating...

.../ Fields Table Relationships Entity-Relationship (ER) model Primary and Foreign Keys Referential Integrity Data Integrity Data Normalisation Table indexing...

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

...This course has been designed for the advanced Access user who wishes to make use of the more powerful facilities of MS Access made available by...

...will be encouraged and advice will be given on planning applications systematically, efficiently and economically. The techniques covered are typical...

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

...to lock cell references (Absolute referencing) Creating Named Ranges to use in formulas FORMATTING AND CUSTOMISING DATA Selecting Items In Excel Formatting...

...It also introduces Excel as a possible database application. You look at graphically representing your data as well as improving its appeal with graphics...

...Text Files Using Microsoft Query Querying Data From The Web Refreshing Data TEMPLATES AND STYLES Working With Templates Working With Styles ANALYSING...

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

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

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

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

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