IT, Computing, Telecommunications courses Southwark

...Fields Field Switches DOCUMENT TEMPLATES Introduction Creating and Using Templates FORM FIELDS Introduction Creating an on-line form Creating a form...

...Structures Looping Control Structures Performing Multiple Actions on an Object Non-Structured Statements Sub Procedures CONTROLS, DIALOG BOXES AND USER-DEFINED...

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

...Adding a Primary Key to a Table Indexing a Field Inserting, Deleting, and Moving Fields Importing a Table from another Source Formatting Tables Formatting... Learn about: Microsoft Access...

...Creating a Modal Dialog Box Adding Controls Setting Properties Formatting your Dialog Box ADVANCED FORM TASKS Using Subforms Creating a Subform Modifying... Learn about: Microsoft Access...

...What is an SQL Convention? What is SQL Syntax? Linking a Database to an SQL Server Using the SELECT Statement Selecting All Data Selecting Specific... Learn about: Microsoft Access...

...Copy, and Paste Multiple Cells and Items How to Use Paste Special How to Insert and Delete Cells, Rows, and Columns Using Undo, Redo, and Repeat Smart...

...Finding the Right Function Using Functions in Excel Inserting Functions Using the IF Function Working with Nested Functions Working with Names and Ranges...

...About PivotTables Modifying PivotTable Calculations Formatting a PivotTable Refreshing a PivotTable Charting a PivotTable Creating a PivotTable Based...

...main features of Outlook including e mailing, using the calendar, contacts, tasks, journal and notes PREREQUISITES Basic PC knowledge INTRODUCTION TO OUTLOOK...

...The Insert Tab The Design Tab The Animations Tab The Slide Show Tab The Review Tab EDITING SLIDES Placeholders Formatting a Slide Other Formatting Tools... Learn about: PowerPoint 2007...

...ADVANCED FILE TASKS Using My Computer within PowerPoint Saving Your Files Using Templates Navigating the Slide Show ADDING TABLES AND CHARTS Creating... Learn about: PowerPoint 2007...

...This course deals with using and sharing your presentations. You will link to information from other applications, explore adding narrations... Learn about: PowerPoint 2007...

...Justifying Text DOING MORE WITH TEXT Fonts on the Home Tab The Font Dialog Using Tabs Paragraph Options PRINTING AND VIEWING YOUR DOCUMENT Using Layouts... Learn about: Word 2007...

...Your Document Arranging Windows Comparing Documents Side-By-Side Splitting a Document Making Word Work Backwards Opening Documents in Word 97-2003 Format... Learn about: Word 2007...

...Tools Design Tab Using the Chart Tools Layout Tab Using the Chart Tools Format Tab Working with Charts Creating a Chart from an Existing Table Analyzing... Learn about: Word 2007...

...more effectively Managers who want to be able to analyse financial data Analysts Investors Outline What is Financial Modelling Who uses Financial Models...

...as a number Month by Name Days of the week Week of the year Week starting Date Functions Useful Date Hotkeys Advanced Filters Using Advanced Filters Removing...