3079 Microsoft courses in Cardiff delivered Online

Learning Objectives Introduction , Improving the Structure of a Database , Maintaining a Database , Working with Navigation Forms and Startup Options , Configuring Access for Multiple Users , Automating Processes , Using Table Events , Conclusion   Pre-Requisites Access Beginner and Intermediate courses or equivalent experience.   Description Access 365 Advanced will further build upon the topics covered in the Access 365 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create backups, create and modify Navigation Forms, set startup options, split a database, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), convert macros to VBA, and use Table Events. Module 1: Improving the Structure of a Database Using the Table Analyzer Wizard 00:09:00 Append Querying to Normalize a Table 00:10:00 Creating a Junction Table 00:06:00 Module 2: Maintaining a Database Backup Up a Database 00:03:00 Using the Compact and Repair Database Tool 00:03:00 Using the Object Dependencies Tool 00:03:00 Using the Database Documenter Tool 00:02:00 Using the Analyze Performance Tool 00:02:00 Module 3: Working with Navigation Forms and Startup Options Creating a Navigation Form 00:03:00 Modifying a Navigation Form 00:05:00 Setting the Startup Options 00:03:00 Module 4: Configuring Access for Multiple Users Using the Database Splitter 00:04:00 Configuring Trusted Locations 00:03:00 Password Protecting a Database 00:04:00 Password Protecting Modules 00:02:00 Converting a Database to an ACCDE File 00:02:00 Module 5: Automating Processes with VBA Understanding VBA Basics 00:03:00 Exploring Variables and Control Flow Statements 00:10:00 Exporting a Table or Query with VBA 00:09:00 Converting a Macro to VBA 00:02:00 Module 6: Using Table Events Understanding Table Events 00:02:00 Using the Before Change Event Command 00:07:00 Using the After Update Event Command 00:04:00 Resource Resource - Access 365 Advanced 00:00:00 Final Exam Final Exam - Access 365 Advanced 00:20:00

Look at some of the more advanced planning features available in Project. Course overview Duration: 1 day (6.5 hours) Our Project – Advanced Planning and Control course looks at advanced planning and resourcing techniques in Microsoft Project and how to customise your schedule to give better visibility and flexibility. The course is designed for experienced users of Project who have attended our Project Planning and Control introduction course or have equivalent knowledge. You must be confident using Project to build and resource schedules and create task dependencies. Objectives  By the end of the course you will be able to: Work with different types of task Amend resource load on a task Work with multiple resource rates Create custom tables Add custom fields Create calculated fields Add drop down lists in fields Filter and extract information Create new views Export information Content Advanced planning techniques Splitting tasks Task types Spreading work across activities Advanced resourcing techniques Resource types Assignment views Effective dates Work contours Overtime work Using multiple resource rates Creating custom tables Customising tables Adding fields Creating custom fields Adding text, number, date and time fields Using flag fields Defining pick lists Renaming custom fields Creating calculated fields Creating formulas Using graphical indicators Uploading and tracking progress Completing work Completing work per resource Updating tasks Updating the project Working with the status date Rescheduling work Viewing baseline against schedule Project overview statistics Working with filters Building standard filters Building interactive filters Task and resource filters Using highlight filters Creating custom views Creating customised views Customising text styles Using grouping techniques Exporting information Exporting to Excel

The Planner is a late addition to the Office 365 suite of productivity tools that makes it very easy for a team to work together more efficiently and productively. This Office 365 Planner course is perfect if you are looking forward to learning more about Office 365. By enrolling in this course, you'll equip with all the features and functionality of Planner. Following that, you'll learn how to create new plans, organize and assign tasks. Besides, you'll explore how to share files, chat, and get updates on project progress. In addition to that, you'll understand the interface of Planner, learn to create new plans, use Boards and Buckets to organize tasks. Creating and assigning tasks, adding new members, using notifications, and working with the different views also broadly explained in this course. Upon successful completion of this course, you'll be able to use Planner more confidently for organizing and managing tasks and projects related exercises. What Will I Learn? Get an Understanding of Planner Add and Edit Tasks Create a New Plan Work with Members in Planner Requirements Basic computer skills would be helpful Introduction Introduction 00:03:00 Working with Planner Overview of Planner 00:05:00 Creating a New Plan 00:05:00 Using Boards and Buckets 00:06:00 Working with Tasks 00:09:00 Working with Members 00:08:00 Editing Plan Settings 00:05:00 Changing Views 00:08:00 Exporting a Plan to Excel 00:04:00 Conclusion Course Recap 00:02:00 Course Certification

Welcome to this comprehensive video course on project finance, where we will delve into various aspects of transactions eligible for project finance. Throughout this course, we will explore real-world examples and dive deep into a captivating case study on Express Fiji. We will guide you through building a comprehensive balance sheet, incorporating all relevant assets, liabilities, and equity components.

Description: The purpose of 70-685 - Enterprise Desktop Support Technician for Windows 7 course is to teach you how to configure and deploy a private cloud with System Center 2012 R2. Throughout the course, you will know the ways of understanding and work with the cloud, the cloud components, including infrastructure and service catalog, and virtual applications. The course guides you how to use VMM or install VMM to deploy the cloud. You will also be introduced to host groups and security systems. After completing the course, you will be able to work with Private Cloud Infrastructures. You will also be able to learn dynamic application deployment, server application virtualization, web deployment packages, server App-V components and sequencing and deploying virtual apps. After that, the course will help you to understand the essential components of Private Cloud including SQL server profiles, OS profiles, application profiles, hardware profiles, VM templates and self-service user role. In the course, you will gain information about the Private Cloud computing, installing and configuring app controller and creating and managing services and service templates. Finally, you will know about server management, automation and security for the cloud. 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? 70-685 - Enterprise Desktop Support Technician for Windows 7 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 70-685 - Enterprise Desktop Support Technician for Windows 7 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. Identifying Cause and Resolving Desktop Application Issues Identifying Cause and Resolving Desktop Application Issues FREE 00:17:00 Problem Steps Recorder 00:31:00 Other Group Policy Settings 00:15:00 AppLocker Advantages 00:27:00 Windows Installer 00:16:00 WSUS 00:29:00 Browsing History 00:13:00 Operating System Troubleshooting and Support Operating System Troubleshooting and Support 01:03:00 Safe Mode Options 00:48:00 Event Forwarding 00:16:00 Windows 7 and Language Packs 00:21:00 Networking with Windows 7 Networking with Windows 7 00:52:00 Automatic Configuration 00:18:00 TCP IP Configuration 01:12:00 IPv6 00:28:00 IPSec 00:23:00 Configuring Security and Troubleshooting Issues Configuring Security and Troubleshooting Issues 00:51:00 Windows Firewall with Advanced Security 00:45:00 Protecting the PC Proactively 00:18:00 Supporting Mobile Users Supporting Mobile Users 00:36:00 Remote Assistance 00:22:00 Maintaining Hardware on Windows 7 Maintaining Hardware on Windows 7 00:21:00 Working with Hard Drive Issues 00:48:00 Common Components 00:21:00 Power Management 00:21:00 Centralizing Configurations Centralizing Configurations 00:16:00 Administrative Templates 00:22:00 User Login, Profiles and Access to Resources User Login, Profiles and Access to Resources 00:29:00 DHCP 00:41:00 Configuring Offline Files - Client Side 00:21:00 Mock Exam Mock Exam- 70-685 - Enterprise Desktop Support Technician for Windows 7 00:20:00 Final Exam Final Exam- 70-685 - Enterprise Desktop Support Technician for Windows 7 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: The 70-246 - Monitoring and Operating a Private Cloud with System Center 2012 R2 (MCSE) course teaches you how to monitor and operate a private cloud with System Center 2012 R2. Throughout the course, you will learn the basics of the cloud, the ways of working with the business cloud, cloud services, monitoring and automating responses. The course will teach you how to handle problems in the Private Cloud, and the procedures of Service Management in the Private Cloud. You will also be introduced to cloud protection, recovery, compliance, the use of SLAs, Dashboards and Widgets. The course shows you the real-time state using Visio, system centre analytics, service level tracking, viewing SSRS and Excel to view data, PerformancePoint and configuring and deploying widgets and dashboards. Finally, you will learn cleaning up system centre databases systems. After completing the course, you will understand how Operations Manager handles monitoring, Service Manager and App Controller facilitate self-service, and Orchestrator glues everything together. 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? 70-246 - Monitoring and Operating a Private Cloud with System Center 2012 R2 (MCSE) training 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 70-246 - Monitoring and Operating a Private Cloud with System Center 2012 R2 (MCSE) 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. System Center 2012 What is System Center 2012 FREE 00:30:00 Introducing the Cloud Discussion of Cloud Computing 00:19:00 Important Requirements 00:07:00 Working with System Center and the Infrastructure 00:05:00 Maintaining the Cloud Health 00:05:00 How Components are Integrated 00:06:00 Are You in Compliance 00:05:00 Working with the Business Cloud Examining SC 2012 VMM 00:17:00 Working with VMs with the VMM 00:11:00 Creating Clouds for Business 00:16:00 Cloud Services Looking at Service Templates and VMM Profiles 00:22:00 Web Deploy Packages 00:08:00 Server App V Introduction 00:05:00 The Data of the N Tier Application 00:05:00 What's New with VMM R2 00:07:00 Importing and Deploying the Stock trader Application 00:10:00 Installing SQL Server 00:10:00 Monitoring Overview of Operations Manager 00:20:00 Customize the Monitoring Operations 00:09:00 Monitoring Application Performance 00:14:00 Advanced Monitoring 00:04:00 Using Operations Manager for Applications 00:04:00 Using Operations Manager for the Network 00:11:00 Using Operations Manager for Distributed Applications 00:07:00 What's New in Operations Manager 2012 R2 00:09:00 Deploying an Agent 00:09:00 Configuration for Custom Monitoring 00:11:00 Configuring Basic Monitoring and Application Perfomance 00:12:00 Installing Operations Manager 00:05:00 Automating Responses Looking at Orchestrator 2012 00:08:00 Putting Orchestrator, Operations Manager, and Service Manager Together 00:15:00 What's New with Orchestrator 2012 R2 00:04:00 Managing Problems in the Private Cloud What is Problem Management 00:07:00 Using Custom Rules 00:08:00 Service Management in the Private Cloud Service Manager Introduction 00:10:00 Security Settings 00:09:00 Work Items 00:08:00 Incident Queues and Service Offerings 00:03:00 What's New with Service Manager 2012 R2 00:01:00 Configuring the Incident Template 00:10:00 Cloud Protection, Recovery, and Compliance Protecting and Recovering Data for the Private Cloud 00:29:00 Data Recovery 00:15:00 Overview of the Process Pack for IT GRC 00:14:00 Installing the Process Pack for IT GRC 00:06:00 Implementing an IT GRC Control Management Program 00:06:00 How to Maintain Compliance Through VMM Security Baselines with System Center 00:06:00 What's New with DPM 2012 R2 Advisor 00:03:00 Configuring Manual Protection 00:06:00 SLAs, Dashboards and Widgets Configuring and Deploying Widgets and Dashboards 00:12:00 Real-Time State Using Visio 00:10:00 System Center Analytics 00:12:00 Service Level Tracking 00:05:00 Viewing SSRS and Excel to View Data 00:04:00 PerformancePoint 00:04:00 Cleaning Up System Center Databases Service Manager Groom Settings 00:08:00 View and Purge Orchestrator Runbook Logs 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Corel WordPerfect 12 - Intermediate Level is necessary for you after finishing the foundation course. This course has several modules which will help you work on the foundation level skills that you have attained and improve on them. The basic elements of this course will expose you to slightly advanced stuff that is incorporated in the WordPerfect program. It will teach you all the tools and expertise necessary to operate during any work to become more efficient. This course will help you stand out among other workers or colleagues and further your cause to promote your career. Learning Outcomes: Utilizing the WordPerfect file dialog box and toolbar options Saving your files using file extensions, viewing file properties, backing up your documents, and saving different versions Using page setup through margins, layout options, page size and orientation Explore the various printing options in order to get printouts Creating, expanding and saving Master documents; also creating, editing and removing subdocuments Understanding reveal codes window and un-revealing codes Examining code - like modifying, deleting, hard vs. soft; working with specific codes - character, sentence and paragraphs, etc.; and finding and replacing codes Applying built-in style using the property bar, updating existing styles, and creating your own style using QuickStyles and dialog boxes Creating and using document styles; and managing styles through the adding, saving and settings options Inserting and creating different list styles, and managing these list styles Utilizing QuickFormat and other formatting tools like the Make-It-Fit command and more Creating headers and footers, using the property bar, placing, suppressing, and deleting headers and footers Formatting text into columns, commenting on documents and reviewing them as well How to create watermark or text boxes Moving, resizing, adding borders and fill, adding captions, and wrapping text in text boxes Understand the basics of custom graphics and how to edit them to meet your needs Creating hyperlink and speed link within your documents Working with bookmarks and quickmarks Create table of contents, setting it up, generating and re-generating it, and using the document map 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? Corel WordPerfect 12 - Intermediate Level 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 Corel WordPerfect 12 - Intermediate 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 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. MANAGING DOCUMENTS USING THE FILE DIALOG BOX 01:00:00 USING TOOLBARS 00:15:00 SAVING YOUR FILES 00:30:00 USING PAGE SETUP 00:30:00 PRINTING YOUR FILES 00:30:00 USING MASTER DOCUMENTS AND SUBDOCUMENTS 01:00:00 USING REVEAL CODES REVEALING CODES 00:30:00 EXAMINING CODE 00:30:00 SPECIFIC CODES 00:30:00 FINDING AND REPLACING CODES 00:30:00 FORMATTING USING STYLES APPLYING A BUILT-IN STYLE 00:30:00 CREATING A STYLE 00:30:00 USING DOCUMENT STYLES 00:30:00 MANAGING STYLES 00:30:00 USING LIST STYLES 01:00:00 MANAGING LIST STYLES 00:30:00 OTHER FORMATTING TOOLS USING QUICKFORMAT 01:00:00 OTHER FORMATTING TOOLS 01:00:00 CREATING HEADERS AND FOOTERS 00:30:00 FORMATTING TEXT INTO COLUMNS 01:00:00 COMMENTING ON A DOCUMENT 01:00:00 REVIEWING A DOCUMENT 01:00:00 TEXT AND GRAPHICS CREATING A WATERMARK 00:30:00 CREATING TEXT BOXES 00:30:00 JAZZING UP TEXT BOXES 01:00:00 THE BASICS OF CUSTOM GRAPHICS 00:30:00 EDITING CUSTOM GRAPHICS 01:00:00 LINKS AND REFERENCES CREATING LINKS TO OUTSIDE YOUR DOCUMENT 00:30:00 WORKING WITH BOOKMARKS 00:30:00 WORKING WITH QUICKMARKS 00:30:00 CREATING A TABLE OF CONTENTS 01:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Unlock the power of data with our comprehensive course on Business and Data Analysis with SQL. Learn essential SQL skills to extract meaningful insights, make data-driven decisions, and drive business success. Whether you're a beginner or looking to enhance your expertise, our course empowers you with the tools and knowledge needed to excel in the dynamic world of data analysis. Enroll now to master SQL for business intelligence and elevate your analytical skills to new heights.

Get familiarised with the features and functionality of Yammer in Office 365 with our most recommended Office 365 Yammer course. Yammer is a collaboration tool that's internally centred on your business, helps you connect and engage with the company. By taking this course, you'll understand the features and functionality of Yammer in Office 365. You'll overview the interface and learn about Yammer's features, navigate Yammer, and update your profile. In addition to that, learn to work with and manage conversations, post items and content, participate with groups, and connect to an external network. You'll also work with and manage messages, search for content in Yammer, learn to converse using Online Now, create polls for feedback, give praise, and make announcements. What Will I Learn? Navigate the interface and learn about Yammer Work with and manage conversations, and work with groups Create messages, chat using Online Now, and search Yammer Create polls, give praise, and make announcements Requirements Basic computer skills and experience navigating the Internet. Experience and understanding of social networking is helpful but not required. Who is the target audience? Students who will be utilizing Yammer to communicate and collaborate with co-workers. Introduction Introduction FREE 00:03:00 Working with Yammer in Office 365 Overview of Yammer 00:03:00 Navigating Yammer 00:04:00 Editing Your Yammer Profile 00:05:00 Working with Conversations 00:05:00 Managing Conversations 00:07:00 Working with Groups 00:08:00 Connecting to an External Newtork 00:08:00 Working with Messages 00:05:00 Managing Messages 00:07:00 Chatting with Online Now 00:08:00 Creating a Poll, Praise, or Announcment 00:08:00 Searching in Yammer 00:07:00 Conclusion Course Recap 00:03:00 Course Certification

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Azure Masterclass Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training employers seek in today's workplaces. The Azure Masterclass Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Azure Masterclass Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Azure Masterclass Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Azure Masterclass? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standards accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Azure Masterclass there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Azure Masterclass course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Azure Masterclass does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Azure Masterclass was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Azure Masterclass is a great way for you to gain multiple skills from the comfort of your home. Azure Masterclass Module 01: Introduction to DevOps Server 00:59:00 Module 02: Introduction on Wiki in Azure DevOps Server 00:24:00 Module 03: Creation of User Stories 00:28:00 Module 04: Creation of Tasks 00:19:00 Module 05: Creation and Execution of Test Cases 01:00:00 Module 06: Creation Bugs 00:27:00 Module 07: Queries and Creation of Charts 00:21:00 Assignment Assignment - Azure Masterclass 06:06:00 Order Your Certificate Order Your Certificate QLS