Instructor Led Automate Training in United Kingdom

CL Programming ...d running Control Language (CL) programs and to use CL to automate your daily tasks. This class introduces several topics as well as various hands-on labs which consist of declaring variables, retrieving job attributes and system values, character string expressions, testing conditions, data areas, passing parameters, monitoring for messages, concatenation, substring functions, command  more...

CL Programming - Intermediate ...d running Control Language (CL) programs and to use CL to automate your daily tasks. This class introduces how CL has been enhanced over the last couple of Operating System releases to include different variable types and their use, structured programming topics as well as sub-routines and multiple file handling. Learn how to control program flow, as well as many other modern programming  more...

Unix Shell Programming Training ... shell command line. Thus, shell scripts provide a way to automate commonly executed groups of commands - but shell scripts can do much more than this. Although many simple tasks are automated with small scripts, large scripts hundreds of lines long are very common. These larger scripts are written by system administrators, database administrators, testers, utility programmers, and others to  more...

Microsoft Excel 2003 Advanced ...sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. In this course, you will do all of these things. This would be run as a private course. We can run private courses at your offices, and supply the laptops and  more...

Microsoft Word 2007 Intermediate ...e. During this course you will learn how to customize and automate the way Microsoft Word works for you. You will learn how to work with lists, tables and charts including performing a mail merge. The quality of your work will improve greatly as you create and modify complex documents and create personalized efficiency tools. This would be run as a private course. We can run private  more...

Access Level 3 Advanced level one day hands-on instructor led course on Microsoft Access. Topics include: Parameter and Action Queries, Query Joins and Crosstab Queries, Using Advanced Form Techniques, Creating Basic Macros to Automate Forms, Using Macros to Provide User Interaction and Automate Tasks, Using Advanced Report Techniques, Web Capabilities and Data Integration. The prerequisite for this course is  more...

Microsoft Access 2010 Level 3 ...Using a Condition a Validate Data Using a Macro a Automate Data Entry Using a Macro Creating Effective Reports a Include a Chart in a Report a Print Data in Columns a Cancel Printing of a Blank Report a Publish Reports as PDF Maintaining an Access Database a Link Tables to External Data Sources a Manage a Database a Determine Object Dependency a  more...

Microsoft Word 2010 Level 2 ... using Quick Parts Control text flow Use templates to automate document creation Use the mail merge function Use macros to automate common tasks Target Audience This course is designed for students who are able to create and modify standard business documents in Microsoft Word 2010 but need to know how to create or modify complex business documents and customised Word efficiency  more...

Microsoft PowerPoint 2007 Level 1 Course Benefits PowerPoint is a powerful presentations application, which allows the user to create intuitive presentations for paper, screen or web output. Users will learn how to enhance presentations by formatting, use the drawing tools to create and edit logos and pictures, insert objects, apply Slide design, set up presentations for printing purposes, create and automate screen shows.  more...

Enterprise Architect for Power Users Course Overview This course is aimed at experienced users of Enterprise Architect and covers advanced code generation features and design concepts. What will I learn? As the course is aimed at experienced users it will not cover any of the diagrams but instead will focus on making the user more proficient in the advanced use of the tool. At the end of the course the delegate will have a  more...

Microsoft Access Advanced Aspect Traininga s Microsoft Access Advanced Training course is designed for those users who wish to step their current knowledge of Access to take advantage of the more complex features. On completion delegates will understand relational databases and be able to work with related tables. They will learn how to generate much more complicated queries and create more advanced forms and reports  more...

Microsoft Access Introduction Intermediate On Aspect Traininga s Microsoft Access Introduction Training Course you will explore database basics and build tables and reports that corral your data Access has undergone an extreme makeover! Whether you've used one of the older versions or this is your first exposure to Access, Aspect Traininga s Microsoft Access Introduction Training Course is where you'll find the essentials you need to  more...

Microsoft Access VBA Aspect Traininga s Microsoft Office Access VBA training course builds on the skills youa ve already developed in creating database applications learn on our previous Microsoft Access courses and helps you take them to the next levela using Visual Basic for Applications (VBA) to accomplish things you once performed manually. To facilitate this lofty goal, Access includes the VBA programming  more...

Microsoft PowerPoint VBA ... not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Microsoft PowerPoint with Aspect Training's Microsoft PowerPoint VBA Course. Youa ll jump right into the basics of recording and running macros with Officea s built-in Macro Recorder, before quickly moving to the essentials of VBA syntax, using loops and functions, building effective  more...