Cookies are small text files that are stored on your computer, phone, tablet or other web enabled device when you visit a website.
We use the following cookies linked to analytics:
_ga, __gat_gtag_UA_845645_1 and _gid
Our cookies do not store private data or data that can identify you personally.
This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.
This Access course enables delegates to progress from the one level databases associated with holding data in Microsoft Excel, to multiple table relational databases, covering all the basics including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.
This MySQL Database Administration course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands. The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, backing up and recovering data and optimising query performance. This MySQL Database Administration course also covers MySQL replication and its role in high availability and scalability. This course is also suitable for administrators of MySQL 5.6 and 5.7.
This three-day instructor-led course provides students who wish to develop and maintain SQL Server databases Additionally, it will be of use to individuals who administer applications that deliver content from SQL Server databases.
This 2 day course is designed to equip delegates with the knowledge and practical skills to either implement or enhance an existing Quality Management System (QMS). Discover the actions, tools and techniques required to implement or improve a QMS including procedural and process information.
Build the practical skills and knowledge you need to develop or enhance an Environmental Management System (EMS) with this training course. Discover the actions, tools and techniques required to implement or improve an inherited EMS, including procedural and process information.
Adobe Illustrator is a drawing and design package. This course will give you the experience you need to produce professional Graphics and illustrations, and will increase your levels of productivity and creativity within illustrator. Once you have completed this course you can move on to the Adobe Illustrator Advanced course.
Lightroom Classic is a great solution for image organisation and management, rapid editing and adjustment, and sharing and presentation. While Photoshop allows you to make incredibly complex edits to individual images, Lightroom offers a far simpler solution for photographers to manage their image catalogue, make bulk edits and adjustments, and rapidly output the final product. Our one day introduction course gets you up and running on this powerful application in no time at all. We teach you how to use the interface to manage your image catalogue, edit metadata, detect faces, make adjustments to exposure or colour temperature, crop, and make localised corrections.
This course covers the basics of Family Creation within Revit software, from profile and simple families through to nested fully parametric objects. Delegates are introduced to the process of creation and editing families and the tools utilised for parametric adaptions.
During this course delegates will learn about building information modelling and the tools for parametric MEP systems design and documentation using Autodesk Revit® MEP. Begin the three-day guide by learning the fundamental features of Autodesk Revit MEP, then progressing through schematic design, system analysis and construction documentation, and finishing with design visualisation.
This course covers the basics of Revit Structure, from schematic design through construction documentation. Students are introduced to the concepts of Building Information Modelling and the tools for parametric building design and documentation.
During this Crystal Reports course, delegates will learn the basics of report creation, from linking the report to the requisite data source, to distributing the report to others. Delegates will also learn about sorting, grouping, linking, basic formula creation and working with Crystal Report experts.
Delegates will learn how to create advanced formulas in Crystal Reports, format Crystal reports based on calculation results (conditional formatting), use multiple sections, insert sub reports and access data from sources other than PC databases.
The Introduction to MySQL course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced.
The Java Programming 2 course is closely aligned with the Oracle Java SE 8 Programmer II exam. This course focuses on the core language features and Application Programming Interfaces (APIs) you will use to design effective object-oriented and functional programming applications with the Java Standard Edition 8 Platform. This course will teach you how to design and develop robust Java code that is easy to test and maintain and can be integrated into multiple applications. The most important new topics introduced in Java SE 8 are covered, such as Functional Programming and Stream API, that allow you to use the most up to date techniques in your code. Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features.
The Oracle SQL Fundamentals course is designed to give delegates practical experience in writing Oracle SQL statements and scripts. A wide range of SQL functions and data manipulation statements are introduced.
Microsoft Publisher is an easy to use desktop publishing application that helps you create, customise, and publish materials such as newsletters, brochures, flyers and catalogues. In this Publisher course, delegates will create a publication from scratch as well as using some of the hundreds of business and personal designs available in Publisher. This course will enable delegates to create, design, and edit publications.
Python is an object oriented rapid development language deployed in many scenarios in the modern world. This Python Programming 1 course is designed to give delegates the knowledge to develop and maintain Python scripts using the current version (V3) of Python. There are many similarities between Python V2 and Python V3. The skills gained on this course will allow the delegate to develop their own skills further using Python V2 or V3 to support the development and maintenance of scripts. The Python Programming 1 course comprises sessions dealing with syntax, variables and data types, operators and expressions, conditions and loops, functions, objects, collections, modules and packages, strings, pattern matching, dates, exception handling, files, and databases. Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Visio provides a dedicated, familiar, Microsoft drawing environment, complete with a broad range of templates, shapes, and sophisticated tools designed to make creating a wide variety of business and technical diagrams easy, giving business and technical users the power to visualise and communicate ideas, information, and systems. Delegates will learn basic concepts for creating flowcharts, cross-functional flowcharts, and organisation charts. This includes learning the basics for using and creating shapes, printing drawings, creating custom stencils, and many time-saving shortcuts and techniques designed to increase user productivity.
Our online database design training courses can be attended from anywhere via Zoom or Micosoft Teams, depending on the course. We can provide a private online database design course, or you can choose to book on a public scheduled online database design course. We like to keep our tutor-led virtual online database design courses small, so we keep delegate numbers low, around 6-8 delegates per online course. If you would like further information on our online courses, please call us on 0191 377 8377, or click here to contact us online.
Which part of the course did you find particularly valuable
"I found all of the course valuable. Although I do use Excel on a daily basis I wasn't aware of some of the shortcuts that were shown to us today and these will certainly benefit me goung forward "
C.P. , Excel Level 2
Would it be possible to use your feedback in our marketing we only use your initials and organisation name
"My second Excel course it has made a huge difference to how I present data "
J.S. STC, Excel Level 2
"I found the VLOOKUP and flash field functions really useful. I also enjoyed learning all the additional uses of pivot tables. All of the training was very detailed whilst also being enjoyable! "
B.C. , Excel Level 3
Which part of the course did you find particularly valuable
"The work with formulas and 'If Statements' is particularly valuable and useful as is how to protect the data, and Data Validation "
J.S. Yorwaste, Excel Level 2
"Enjoyed it thank you "
W.K. TopSpec Equine Ltd, Word Essentials
"I will apply what I have learnt "
A.A. Merton, Word Essentials
"An all round great course, thanks once again. "
S.F. Nissan, Excel Level 2
Any other comments or recommendations
"Enjoyable 2 days, not overbearing and very informative "
J.G. Benfield Park Medical Group, Stepping up to Management
"All of the course gave me a wide insight into Excel and its capabilities. "
M.W. Litterboss Ground Control, Excel Level 1
"In the last four and a half years of regular training this is the best course Ive been on. The tutor Mark was great and I learned everything I wanted to and more from the course. I look forward to taking these new After Effects skills into client work. "
G.C. Drummond Central, Adobe After Effects Advanced
"Excellent course and trainer "
L.J. PX Group, Word Advanced Features
"Great course and the trainer was happy to answer questions and show examples to support learning "
P.B. Community Foundation, Word intermediate
Following this training what are you going to do differently
"Work more efficiently using shortcuts and saving time "
B.S. Egger UK Ltd, Excel Level 1
"Extremely useful with insights on why you use functions, not only how. "
E. , Excel Level 2
Virtual Training: What is it?
Watch the video:
Welcome to IT Training Solutions!Expert trainers, courses delivered online or in person, small class sizes, flexible content, course materials included and available via your personal training account or in printed form.
Established in 1992, IT Training Solutions Ltd began life as an on-site computer training company in
response to the business worlds growing demand for flexible, high-quality training at an affordable price.
Today, IT Training Solutions Ltd has grown in size and is one of the leading training providers in the
North East, providing training courses on a large number of IT and personal development subjects.
Online database design courses. With virtual database design training courses, you can attend your database design course from anywhere. Choose an online database design virtual course and attend from anywhere. This means you can attend your database design online virtual training from home, the office, or anywhere else.
In response to the nation-wide need for training amidst a pandemic, you can now attend your Database Design training virtually. Virtual Database Design training responds to the current need for social distancing whilst being trained efficiently and effectively.
Many people have found that attending an online course virtually has saved them time and money, as travel time and expenses were reduced or eliminated. Whilst virtual Database Design courses take place from the comfort of your desk or home, the course has exactly the same content as classroom Database Design training. You can call us to discuss your Database Design virtual training on 0191 377 8377, we will be happy to help you find the best option for your training.