Afiniti courses

...Tables · Create A Table · Working With Tables Queries · Create A Query Forms · Using And Creating Forms · Displaying And Linking Images Reports · Creating...

...Core Topics Introduction To Microsoft Access 2003 · What Is Access? · Creating Files · Opening And Closing A Database File The Database Window · The Database...

...SQL Queries · Writing SQL Subqueries · Writing SQL Joins · Inserting Data · Updating Data · Deleting Data · Writing SQL Queries In Access 2003 Working...

...Excel To Create Reports Placing Conditions on Queries · Most Commonly Used Operators · Parameters · Wildcards · Logical Operators · Refreshing Queries...

...· Combining Data From Multiple Queries · Combining Different Types Of Data Advance Queries · Creating Cross Tab Queries · Using Predefined Conditions ·...

...data sources and understand how to integrate Crystal Reports with Visual Basic. Suitable for: new users of Crystal Reports new users of Crystal Reports...

...By the end of the course delegates will have developed the necessary skills to create advanced reports that include linking, formulas, sub reports and report distribution...

...concepts and build on them using the powerful features of Excel including the entry and formatting of data and text, and the creation of simple calculations...

...· Adding Pictures · Layering Objects · Grouping And Ungrouping Objects Excel 2003 and other Applications · Converting Files From Other Applications · Copying...

...Data · What-If Analysis · Goal Seek · Data Tables · Scenario Manager · Solver · Using Pivot Tables Macros and Custom controls · Working With Macros · Running...

...charts & chart types • Editing & deleting charts • Formatting charts • Copying and moving charts between workbooks Customizing Excel • Modifying basic...

...& Named Ranges • Paste Special • Transposing rows and columns • Importing text and text delimiters • Named ranges in cells • Using names ranges in formulae...

...Autofilters • Advanced Filters • Working With Filtered Data • Using Data Forms Charts • Chart Wizard • Chart Toolbar • Working with Charts • Formatting...

...a basic understanding of how to develop a website. Suitable for: new users of Microsoft FrontPage new users of Microsoft FrontPage Core Topics Introduction...

...Navigation Pane The Toolbars · The Standard Toolbar · The Outlook Today Toolbar · The Message Toolbars · The Advanced Toolbar Mail · Creating Messages...

...• Creating, editing & deleting contact • Creating a distribution list • Editing Distribution Lists Organising Mail • Searching for 1 or more messages •...

...Formatting and Editing Text · Adding Text To A Slide · Formatting Text · Using Undo And Redo · Using Find And Replace · Using Spell Check · Using The Clipboard... Learn about: PowerPoint 2003...

...new skills and apply them effectively existing users of PowerPoint who want to learn new skills and apply them effectively Core Topics Creating a Photo... Learn about: PowerPoint 2003...

...The aim of this course is to provide delegates with practical experience of Microsoft PowerPoint 2007. By the end of the course delegates will be... Learn about: PowerPoint 2007...

...be able to integrate photos, diagrams, animation and movies with their presentations. Suitable for: existing users of PowerPoint who want to learn... Learn about: PowerPoint 2007...