Progressive Training & Development courses

...at demystifying Microsoft Office 2007 and getting you up to speed quickly. Your experienced trainer will point out the main differences between versions of the software...

...Message Toolbars The Advanced Toolbar Mail Creating Messages Mail Customization Opening And Replying Contacts Tasks... Learn about: Microsoft Office...

...in at least one other Microsoft Application, preferably Excel. INTRODUCTION Database Basic Concepts Database Object Overview USING TABLES Field Names...

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

...the SQL behind queries The SQL Structure Creating a Union Query Queries Crosstab Queries Select Top 5 Records Using Date/Time functions Using Maths Functions...

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

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

...What is SQL An Introduction to ANSI Structured Query Language (SQL) SQL and Relational Databases Definitions Data Organisation What does SQL...

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

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

...Sharing Your Database Managing Your Database Using the Dashboard Links Using the Help Menu USING BUSINESS CONTACT MANAGER Accounts Opening the Accounts...

...Text Formatting Numbers Manipulating Data Formatting Columns And Rows Formatting With Colours And Patterns Adding And Editing Borders Using Autoformat...

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

...Validation Documentation CUSTOMISING EXCEL 2003 Configuring Excel 2003 Options Customising The Excel Environment Working With Workspaces COLLABORATION...

...VBA, AND EXCEL PROGRAMMING Macros Recording Macros Playing a Macro Macro Security More Macro Tasks Recording a Relative Reference Macro Running a Relative...

...the Scenes Limitations of Pivot Table Reports CREATING A BASIC PIVOT TABLE Preparing Your Data Creating a Basic Pivot Table Keeping up with Changes...

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

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

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

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