683 Microsoft Certification courses delivered On Demand

Advanced Level Course on Microsoft Office 2007 Looking to learn everything there is about all the Microsoft Office programs? This course will give you exactly what you are looking for. Learn all there is about Microsoft Word, Excel, Outlook, PowerPoint, OneNote, Access, Publisher, Project, InfoPath, SharePoint Designer and Visio. Office 2007 introduces a new graphical interface user called the Fluent User Interface, which uses ribbons and an Office menu instead of menu bars and toolbars. Office 2007 also introduced Office Open XML file formats as the default file formats in Excel, PowerPoint, and Word. Office 2007 also introduces a feature called 'Live Preview', which temporarily applies formatting on the focused text or object, when any formatting button is moused-over. This Course is designed to make you learn everything about all the Microsoft Office tools of 2007 and all of its new features. Learning all the office softwares increases your credibility in today's competitive job market. So what are you waiting for? This is the course for you. Course Highlights Accredited Microsoft Office 2007 Advanced Level is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Microsoft Office 2007 Advanced Level into 65 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 2 days, 8 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Microsoft Office 2007 Advanced Level Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Microsoft Office 2007 Advanced Level is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Accredited Microsoft Office 2007 Advanced Level is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Word 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with the Word Window 01:00:00 Module Three - Adding Pictures 01:00:00 Module Four - Adding Smart Art 01:00:00 Module Five - Adding Tables 01:00:00 Module Six - Advanced Table Tasks 01:00:00 Module Seven - Inserting Special Objects 01:00:00 Module Eight - Adding In-Document References 01:00:00 Module Nine - Advanced Research Tasks 01:00:00 Module Ten - Reviewing a Document 01:00:00 Module Eleven - Customizing Word 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Accredited Microsoft Word 2007 Advanced Level 00:00:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 Advanced Level CPD & IAO Accredited- CPD Accredited 00:00:00 Microsoft PowerPoint 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Adding Pictures 01:00:00 Module Three - Working with Text Boxes 01:00:00 Module Four - Adding SmartArt 01:00:00 Module Five - Adding Tables 01:00:00 Module Six - Inserting Advanced Objects 01:00:00 Module Seven - Advanced Drawing Tasks 01:00:00 Module Eight - PowerPoint's Research Tools 01:00:00 Module Nine - Creating Notes and Handouts 01:00:00 Module Ten - Using Slide Masters 01:00:00 Module Eleven - Advanced Presentation Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Selling Microsoft PowerPoint 2007 Professional 00:00:00 Microsoft Access 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Advanced Table Tasks 01:00:00 Module Three - Advanced Form Tasks 01:00:00 Module Four - Advanced Reporting Tasks 01:00:00 Module Five - Understanding Relationships 01:00:00 Module Six - Advanced Query Tasks 01:00:00 Module Seven - Working with SQL 01:00:00 Module Eight - Linking Data 01:00:00 Module Nine - Importing Data 01:00:00 Module Ten - Exporting Data 01:00:00 Module Eleven - Advanced Database Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities- Microsoft Access 2007 Advanced Level 00:00:00 Microsoft Outlook 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Customizing Outlook 01:00:00 Module Three - Adding Word Elements to an E-mail 01:00:00 Module Four - Customizing Your Profile 01:00:00 Module Five - Advanced E-Mail Tasks 01:00:00 Module Six - Advanced Calendar Tasks 01:00:00 Module Seven - Doing More with Tasks 01:00:00 Module Eight - Using Notes 01:00:00 Module Nine - Viewing RSS Feeds 01:00:00 Module Ten - Managing Outlook Data, Part One 01:00:00 Module Eleven - Managing Outlook Data, Part Two 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities- Microsoft Outlook 2007 Advanced CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Accredited Microsoft Office 2007 Advanced Level 00:30:00 Final Exam Final Exam- Accredited Microsoft Office 2007 Advanced Level 00:30:00

This Microsoft Outlook course builds on core competencies in Outlook and guides you on how to work with some of the further advanced features of Outlook. This course is designed for students who have core competencies in Microsoft Outlook and want to learn essential level skills or students who want to learn the topics covered in this course in the 2016 interface. After enrolling in this course, you will be able to work with advanced features of outlook such as tasks and notes, Work with signatures and themes, handle the inbox including filtering, to create search folders, to archive and Work with multiple accounts. Course Highlights Accredited Microsoft Outlook Advanced is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Microsoft Outlook Advanced into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 12 hours, 10 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Microsoft Outlook Advanced Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Microsoft Outlook Advanced is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Accredited Microsoft Outlook Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - Working with Messages 01:00:00 Module Three - Customizing Your Profile 01:00:00 Module Four - Advanced Email Tasks 01:00:00 Module Five - Managing Junk Mail 01:00:00 Module Six - Advanced Calendar Tasks 01:00:00 Module Seven - Doing More With Tasks 01:00:00 Module Eight - Using Notes 01:00:00 Module Nine - Viewing RSS Feeds 01:00:00 Module Ten - Printing 01:00:00 Module Eleven - Managing Outlook Data 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities- Accredited Microsoft Outlook Advanced 00:00:00 Mock Exam Mock Exam- Accredited Microsoft Outlook Advanced 00:20:00 Final Exam Final Exam- Accredited Microsoft Outlook Advanced 00:20:00

Description: If you already have the basic skills and knowledge of Microsoft Word 2010 and you are able to create, edit, and print word documents on Windows then this [course_tite] is designed for you. This series builds on the skills and concepts taught in Word 2010 Basic. You will learn advanced formatting, use Word's drawing tools, create and manage tables, and work with column layouts. Here, you will work with styles, sections, and columns and will use the Navigation pane to work with outlines. By this course, you will learn to use Word's advanced editing tools, work with images, including placing and sizing images, wrapping text around images, and using borders and effects, how to adjust page orientation an layout, how to work with columns and with page and section breaks, and more. This intermediate level will pull up your basic knowledge and skills so don't delay to try this. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2010 Word Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2010 Word Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Styles and Outlines Examining Formatting FREE 00:07:00 Creating Styles 00:17:00 Modifying Styles 00:11:00 Working with Outlines 00:13:00 Sections and Columns Creating and Formatting Sections 00:13:00 Working with Columns 00:08:00 Formatting Tables Table Formatting Basics 00:09:00 Borders and Shading 00:06:00 Table Data 00:10:00 Table Styles 00:09:00 Printing Labels and Envelopes Labels 00:06:00 Envelopes 00:05:00 Templates and Building Blocks Template Basics 00:11:00 Building Blocks 00:02:00 Document Properties 00:14:00 Graphics Creating Diagrams 00:02:00 Using the Drawing Tools 00:13:00 Formatting Text Graphically 00:06:00 Managing Document Revisions Tracking Changes 00:21:00 Working with Comments 00:02:00 Web Features Web Pages 00:03:00 Hyperlinks 00:10:00 Mock Exam Mock Exam- Microsoft Office 2010 Word Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Word Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on Hewlett Packard Application Life Cycle Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Hewlett Packard Application Life Cycle Management comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Hewlett Packard Application Life Cycle Management. It is available to all students, of all academic backgrounds. Requirements Our Hewlett Packard Application Life Cycle Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 8 lectures • 03:51:00 total length •Module 01: Introduction on HP Application Life Cycle Management (HP ALM): 00:35:00 •Module 02: Requirements Module: 00:34:00 •Module 03: Test Plan Module: 00:47:00 •Module 04: Test Lab Module: 00:49:00 •Module 05: Defects Module: 00:31:00 •Module 06: Uploading Test cases using MS Excel: 00:18:00 •Module 07: Using Reports in HP ALM: 00:17:00 •Assignment - Hewlett Packard Application Life Cycle Management: 00:00:00

Description: Learning is a process and you should do everything in hand to make this process easy, systematic and uninterrupted. When you get ready for a certification exam, you learn much better and more intensively than when you learn something with no purpose. With this Level 2 certificate in C++ programming course, enhance your learning experience even more. Equip yourself with the fundamental knowledge necessary to gain recognition for your programming expertise. If all that sounds appealing to you, you'll definitely want to sign up and join the community of C++ coders. Keep learning and take your career to the next level! Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Level 2 Certificate in C++ Programming is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Level 2 Certificate in C++ Programming is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 01 Introduction FREE 00:29:00 Starter Examples 00:33:00 Learning C Concepts 00:13:00 Module 02 Data Types and Inference 00:20:00 Sizeof and IEEE 754 00:33:00 Constants L and R Values 00:11:00 Operators and Precedence 00:25:00 Literals 00:26:00 Mock Exam Mock Exam- Level 2 Certificate in C++ Programming 00:20:00 Final Exam Final Exam- Level 2 Certificate in C++ Programming 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Windows 10 comes with different and effective features. But most often users get in trouble. Don't worry. Our Windows 10 End User course will assist you to learn all the difficulties in very easy ways. The Windows 10 End User course incorporates some basic issues of Microsoft Windows 10 operating methods to make you acquainted with its functions. The course assists you to know how to customize, personalize, and execute different areas of Windows 10. It teaches you also how to explore files, maps, operate mail, calendar, and weather features. It also teaches how to update, install, and find out troubleshoot from the applications. He makes you familiar with different programs like Microsoft Word, Excel, and PowerPoint etc. it teaches you internet browsing and other effective relevant features. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Windows 10 End User is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Windows 10 End User is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module: 01 Introduction FREE 00:01:00 Logging In 00:02:00 The Startup Screen 00:03:00 Exploring the Desktop 00:02:00 General Navigation 00:04:00 Introducing the Action Center and Control Panel 00:02:00 Launching Applications 00:03:00 Interacting with Windows 00:06:00 Quitting Applications 00:04:00 Pinning Applications 00:03:00 Customizing the Start Menu 00:03:00 Module: 02 Customizing the Task Bar 00:02:00 Multitasking to Switch Between Multiple Applications 00:03:00 Managing several deskstops Using Task View 00:03:00 Overview of the drive and folder structure 00:04:00 Using Navigation Pane, Details Pane, Preview Pane 00:04:00 Menus and Ribbons 00:03:00 Viewing and Editing File Properties_Revised 00:04:00 Creating Files 00:06:00 Selecting, Moving, and Copying Files_Revised 00:06:00 Renaming Files and Folders 00:03:00 Deleting and Restoring from the Recycle Bin 00:05:00 Module: 03 Create and use shortcuts_Revised 00:05:00 Zip and Unzip 00:07:00 Changing the Sort and Group by 00:06:00 Add Columns to the Explorer View 00:04:00 Creating and Using a Library 00:07:00 Pin Frequent Places Customizing File Explorer 00:04:00 Configuring Files and Explore Options 00:03:00 Logging In or Setting Up OneDrive 00:02:00 Storing and acessing files on OneDrive 00:03:00 Sharing Files Through OneDrive 00:05:00 Syncing Files on OneDrive 00:03:00 Module: 04 Browsing the Web 00:02:00 Customize Top Sites 00:02:00 Using Tabs 00:03:00 Add and Use Favorites 00:03:00 Organize Favorites with Folders 00:02:00 Background Settings 00:04:00 Lock Screen 00:02:00 Change Windows Themes 00:02:00 Personalize Start 00:04:00 Change Screen Resolution 00:02:00 Module: 05 Adjust Notifications and Actions 00:02:00 Course Recap Complete 00:01:00 Course Recap Complete 00:01:00 Mail Send a Message 00:04:00 Adding & Editing- Contacts & Accounts 00:05:00 People Search Link and Share Contacts 00:04:00 Calendar Configuring and Viewing 00:04:00 Calendar Changing Views Creating and Editing Events 00:07:00 Weather Add Favorite Locations and Viewing the Weather 00:04:00 Adjust Audio Settings 00:02:00 Managing Accounts and Sign In Options 00:03:00 Module: 06 Weather- Viewing Historical Data nad Weather Maps 00:03:00 Installing Applications from the Windows Store 00:03:00 Tablet Mode 00:03:00 Using Saving Sharing Web Notes 00:04:00 Downloading Files 00:02:00 Viewing and Clearing History 00:02:00 Cortana Setup 00:03:00 Using Cortana 00:03:00 Maps- Search Get Directions Choose View 00:04:00 Maps- Search Tips and Favorites 00:04:00 Module: 07 Maps- More Search Tips and Map Settings 00:03:00 Photos - Browsing_REVISED 00:05:00 Photos - Using Editing Tools_REVISED 00:04:00 Mail- Add Accounts 00:05:00 Mail- Personalizing and Configuring- 00:04:00 Installing Applications From the Web 00:03:00 Setting Application Defaults 00:03:00 Setting App Privacy and Permissions 00:02:00 Uninstalling Applications 00:01:00 Configure Windows Defender and Windows Updates 00:02:00 Module: 08 Backing Up and Restoring Files and Using Recover to Reset Your PC 00:07:00 Access Task Manage 00:02:00 Accessing the Action Center to View Messages 00:02:00 Manage Sleep and Screen Saver 00:03:00 Managing Devices 00:03:00 Change Type Settings 00:01:00 Adjust Mouse and Touchpad Settings 00:03:00 Adjust Autoplay Settings 00:02:00 Adding Files to a Library 00:09:00 Change Default Storage Locations 00:02:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Course Overview The database is a must for collecting, saving, sorting and finding out data of your website or software. An effective database can make your software more engaging and interactive. learn how to use Microsoft SQL Server from this Microsoft SQL Server Development course and boost the quality of your software. This Microsoft SQL Server Development course will teach you the functions of databases and querying from scratch. You will learn about Microsoft SQL Server, relational database management systems, various functions, tables and relationships from this course. You will be able to use the database for your software development and management. This course will also teach you the best practices for database development and management. Learning Outcomes Learn how to use Microsoft SQL management studio Familiarize with basic database design Learn how you can use select statements Be able to insert delete or update data into data tables Learn about the best practices for database development Create relationships among multiple tables Learn how you can use foreign keys Be able to create Complex database objects Understand how to backup and restore database Who is this course for? This course is helpful for anyone who wants to learn about the database management system and SQL servers. You will be able to understand the function of the database, logic and usability of the database for your Microsoft SQL server development. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Microsoft SQL Server Development is a useful qualification to possess and would be beneficial for any related profession or industry such as: Software Engineer Web Developers Data Security Officers Database Administrators Database Developers Introduction Introduction to SQL Server and Databases 00:04:00 Download and Install SQL Server Express 00:05:00 Manipulating Tables and Data Connect to Database Instance and Create a Database 00:06:00 Drop or Remove Database 00:04:00 What is a Database Table? 00:02:00 Create an SQL Database Table 00:32:00 Insert Data into the Table with SQL Script 00:15:00 Insert Data into the Table with Management Studio 00:05:00 Select Data from the Table with SQL Script 00:09:00 More Advanced Select Queries Part 1 00:18:00 Update Data in the Table 00:10:00 Update Data in the Table with Management Studio GUI 00:02:00 Delete Data from the Table with SQL Script 00:06:00 Delete Data from the Table with Management Studio GUI 00:01:00 Relationships and Foreign Keys What are Relationships, Foreign Keys and Normalization 00:11:00 Create a Relationship in SQL Server 00:19:00 Insert Records in Related Tables 00:13:00 Run Queries on Related Tables 00:19:00 Left, Right and Full Joins 00:11:00 Group By and Aggregate Functions Grouping Data using SQL GROUP BY Clause 00:12:00 SQL AVG Aggregate Function 00:11:00 SQL COUNT Aggregate Function 00:04:00 SQL MAX and MIN Aggregate Functions 00:04:00 SQL SUM Aggregate Function 00:04:00 Advanced SQL Server Objects and Concepts Create and Manage Views 00:23:00 Scalar Valued Functions 00:27:00 Inline Table Valued Functions 00:09:00 Multi Statement Table Valued Functions 00:12:00 Stored Procedures 00:28:00 Table Triggers 00:19:00 Database Scripting, Backup and Restore 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

  Computer Operating System and Troubleshooting Training Certificate is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Computer Operating System and Troubleshooting Training Certificate and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 3 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Operating System Fundamentals What is an Operating System 00:48:00 Configuring the Operating System 00:06:00 What is an Application 00:10:00 Using Control Panel 00:18:00 Computer and Network Terminology Hardware and Peripherals 00:07:00 Storage 00:12:00 Connectivity Devices 00:05:00 Network Components 00:09:00 Working with Software and the OS Software and Concepts 00:11:00 Licensing 00:06:00 Using Software 00:07:00 Software Tools 00:10:00 Troubleshooting Software 00:14:00 Hardware, Devices, and Peripherals 00:05:00 Backup and Restore 00:03:00

Overview Master Microsoft Visio 2016 and elevate your workflow by attending the Microsoft Visio 2016 - Complete Bundle course.In the comprehensive Microsoft Visio 2016 - Complete Bundle course, you'll learn about creating, shaping and connecting text in Microsoft Visio 2016. You'll learn how to add images to a diagram, precise object alignment, and other essentials, for effective data management. You'll also learn how to integrate hyperlinks into your work while collaborating with co-authors, and save your work in different formats to share your work in several platforms. Save time and grow your diagramming skills with Microsoft Visio 2016, by enrolling today! How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Visio 2016 - Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Visio 2016 - Complete Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 40 lectures • 16:10:00 total length •Navigate the Visio Environment: 00:15:00 •Create a Basic Drawing: 00:30:00 •Use the Help System: 00:15:00 •Use Drawing Components: 00:30:00 •Modify a Drawing: 00:15:00 •Work with Callouts and Groups: 00:15:00 •Create a Basic Organization Chart: 00:30:00 •Do More with Organization Charts: 00:15:00 •Make a Basic Floor Plan: 00:30:00 •Model a Room Layout: 00:15:00 •Create a Cross-Functional Flowchart: 00:30:00 •Modify a Cross-functional Flowchart: 00:15:00 •Create Network Diagrams: 00:15:00 •Use Shape Data: 00:15:00 •Use Layers: 00:30:00 •Work with Shape and Connector Styles: 00:15:00 •Work with Themes and Variants: 00:15:00 •Work with Containers: 00:15:00 •Work with Shape Styles: 00:30:00 •Use 3D Shapes: 00:30:00 •Apply Backgrounds, Borders, and Titles: 00:30:00 •Create Custom Stencils: 00:30:00 •Create Simple Custom Shapes: 00:30:00 •Create Master Shapes: 00:30:00 •Create Custom Templates: 00:30:00 •Generate a Pivot Diagram from an Excel Spreadsheet: 00:30:00 •Create a Chart from a Project File: 00:30:00 •Create a Timeline from a Project File: 00:30:00 •Connect to an Access Database: 00:30:00 •Create Macros: 00:30:00 •Modify ShapeSheets: 00:30:00 •Use Advanced Shape Tools: 00:30:00 •Save and Share Drawings with One Drive: 00:30:00 •Review Drawings: 00:30:00 •Insert Drawings into Other Office Files: 00:30:00 •Export Drawings: 00:30:00 •Print Drawings: 00:30:00 •Activities - Microsoft Visio 2016 - Complete Bundle: 00:00:00 •Mock Exam- Microsoft Visio 2016 - Complete Bundle: 00:20:00 •Final Exam- Microsoft Visio 2016 - Complete Bundle: 00:20:00

Overview This comprehensive course on The Complete Microsoft OneDrive Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This The Complete Microsoft OneDrive Course comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this The Complete Microsoft OneDrive Course. It is available to all students, of all academic backgrounds. Requirements Our The Complete Microsoft OneDrive Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 12 sections • 83 lectures • 05:21:00 total length •The Complete Microsoft OneDrive Course -Mastering OneDrive Promo: 00:01:00 •Quick Reminder - You Can Ask Me Anytime: 00:01:00 •Another Quick Reminder: You Facebook Group: 00:01:00 •Quick Win - Create a Folder and Rename It: 00:01:00 •Another Quick Quick Win - Share and Collaborate: 00:01:00 •What's OneDrive: 00:03:00 •OneDrive Free and Paid Plans: 00:04:00 •OneDrive Sign up: 00:05:00 •OneDrive Personal Vault: 00:02:00 •OneDrive PC folder Backup: 00:02:00 •OneDrive Desktop App Download and Installation: 00:02:00 •OneDrive Mobile App Download and Installation: 00:04:00 •Quick Win - Change the View of Displayed Files and Folder: 00:01:00 •Another Quick Win Create a New Album: 00:01:00 •Complete OneDrive Environment: 00:06:00 •Upload and Download in OneDrive: 00:03:00 •Creating New File and Folder in OneDrive: 00:02:00 •Selecting Files and Folder in OneDrive: 00:01:00 •Sharing and collaborating files and folder in OneDrive: 00:04:00 •Other options in top bar of the files and folder: 00:04:00 •Other options in top bar of the files and folder part 2: 00:08:00 •Picture options in OneDrive: 00:03:00 •Right Click options in OneDrive: 00:01:00 •Personals Valid in OneDrive: 00:02:00 •Personals Valid Options in OneDrive: 00:03:00 •Shared Folder in OneDrive: 00:02:00 •OneDrive Settings - Storage Management: 00:03:00 •OneDrive Settings (cont.): 00:04:00 •Microsoft OneDrive Mobile Version: 00:07:00 •Complete Microsoft Word Environment: 00:05:00 •Ribbon Guide: 00:01:00 •Menu and Groups Guide: 00:02:00 •Learn Functions and Options Then Projects: 00:01:00 •Microsoft Word Home Menu Tools: 00:17:00 •Microsoft Word Home Reviewing and Viewing Mode: 00:02:00 •Microsoft Word File Menu: 00:05:00 •Microsoft Word Insert Menu - Page Break and Table: 00:08:00 •Microsoft Word Insert Picture Menu: 00:05:00 •Microsoft Word Word Inserting Header and Footer, symbol and emoji: 00:05:00 •Microsoft Word Layout Menu: 00:02:00 •Microsoft OneDrive References Menu: 00:04:00 •Microsoft Word Review Menu: 00:04:00 •Microsoft Word View and Help: 00:02:00 •Timetable Making in Microsoft Word: 00:06:00 •Bill System in Microsoft Word: 00:06:00 •Microsoft Excel In OneDrive Environment: 00:03:00 •Microsoft Excel Home (Part 1): 00:11:00 •Microsoft Excel Number Formats: 00:03:00 •Microsoft Excel Conditional Format: 00:03:00 •Microsoft Excel Formatting a Table: 00:07:00 •Microsoft One Drive Insert: 00:06:00 •Microsoft Data, Review and View: 00:04:00 •Salary Table in Microsoft Excel: 00:06:00 •Salary Table in Microsoft Excel (cont.): 00:07:00 •Microsoft PowerPoint Environment: 00:02:00 •Microsoft PowerPoint Home and Insert Menu: 00:06:00 •Microsoft PowerPoint Insert and Design Menu: 00:05:00 •Microsoft Power Point Animation and Transition and More: 00:04:00 •Projects of PowerPoint: 00:12:00 •OneNote in OneDrive: 00:04:00 •Forms Survey in OneDrive: 00:03:00 •Plain Text in OneDrive: 00:01:00 •OneDrive Profile Management: 00:05:00 •Account OneDrive Settings: 00:03:00 •Quick Win - Create Unknown Password: 00:01:00 •Security Is Everything!!!: 00:01:00 •Quick Win - Insecurity Is Coming from You and Others: 00:01:00 •Understand Security Type or Category: 00:02:00 •Life Savers - You Should Know These: 00:04:00 •Have Proper Password - Start Securing You Now: 00:03:00 •Don't Use the Same Password Anymore: 00:02:00 •Should You Use Longer Password or Complicated!: 00:03:00 •The Best and Only Solution to Make and Keep Password Un-Crack-Able: 00:08:00 •Last-pass Setup and Configure: 00:10:00 •Last-Pass Options Part 1: 00:03:00 •Last-Pass Options Part 2: 00:04:00 •Last-Pass Option Part 3: 00:04:00 •2FA Makes You Even Stronger in Password: 00:05:00 •Last-Pass & Authy Mobile App: 00:02:00 •Security Is Everything, Keep Secured Your Devices: 00:07:00 •Security on Your Data and Privacy: 00:08:00 •Congratulations - You Are Now a Master of OneDrive: 00:01:00 •Assignment -The Complete Microsoft OneDrive Course: 00:00:00