• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

250 Microsoft AZ-700 courses

Azure - Azure Active Directory

By iStudy UK

Azure Active Directory (Azure AD) is Microsoft's multi-tenant, cloud-based directory, and identity management service that combines core directory services, application access management, and identity protection into a single solution.  Through this Azure - Azure Active Directory you will receive an understanding of directory service options, how to use a custom domain, how to manage users and groups, as well as how to use multi-factor authentication. You will also learn how to work with application access, how to add and access applications, and how to use a hybrid Azure Active Directory. You will also explore how to extend and deploy AD to the cloud, how to prepare for synchronization, install Azure AD Connect, and manage directory synchronization. In addition, you will understand ADFS, learn how to install AFDS, and how to convert a domain to Federated. Finally, you will understand about Azure AD Federation and learn how to convert a domain to Federated. What Will I Learn? Get an Understanding of Active Directory Understand Hybrid Azure AD Understand Azure AD Federation Requirements Recommenced Pre-Requisite = Azure Introduction Introduction Introduction FREE 00:04:00 Azure Active Directory Directory Service Options 00:03:00 Custom Domains 00:05:00 Managing Users and Groups in the Portal 00:04:00 Managing Users and Groups in the Powershell 00:07:00 Multi-Factor Authentication 00:08:00 Multiple Directories 00:04:00 Application Access 00:02:00 Adding and Accessing Applications 00:06:00 Azure AD Versions 00:03:00 Hybrid Azure AD Hybrid Active Directory 00:03:00 Deploying DC to Azure 00:04:00 Directory Synchronization Pre Reqs 00:05:00 Installing and Configuring Azure AD Connect 00:13:00 Modifying Directory Sync 00:05:00 Active Directory Federation Services Understanding Identity Federation 00:02:00 ADFS Authentication with Online Services 00:03:00 ADFS Pre-reqs 00:03:00 Installing ADFS 00:04:00 Installing ADFS Proxy 00:06:00 Converting Domains to Federated 00:05:00 Pass-through Authentication Pass-through Authentication 00:02:00 Seamless Single Sign-on 00:01:00 Configuring Pass-Through 00:04:00 Conclusion Course Recap 00:06:00 Course Certification

Azure - Azure Active Directory
Delivered Online On Demand1 hour 52 minutes
£25

Access 2016 Advanced

By iStudy UK

If you have already done with the basic functions of Microsoft Office Access 2016, then now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Access is Microsoft's flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user. This Access 2016 Advanced is intended to help all users get up to speed on the different features of Access and to become familiar with its more advanced features. The course covers how to complete advanced form design tasks, add field and record validation, create and manage macros, conduct advanced database management, distribute and secure a database, and manage switchboards. What Will I Learn? Improve the Structure of a Database Maintain a Database Work with Access Switchboards Configure Access for Multiple Users Automate Processed with VBA Use Table Events Requirements Access Introduction and Intermediate courses or equivalent experience. Who is the target audience? Students who wish to learn the more advanced capabilities of Access. Introduction Introduction FREE 00:01:00 Improving the Structure of a Database Using the Table Analyzer Wizard 00:05:00 Append Querying to Normalize a Table 00:09:00 Creating a Junction Table 00:06:00 Maintaining a Database Backing Up a Database 00:02:00 Using the Compact and Repair Database Tool 00:03:00 Using the Object Dependencies Tool 00:02:00 Using the Database Documenter Too 00:02:00 Using the Performance Analyzer Tool 00:02:00 Working with Access Switchboards Understanding the Access Switchboard 00:03:00 Using The Switchboard Manager 00:09:00 Modifying a Switchboard 00:05:00 Setting the Startup Options 00:04:00 Configuring Access for Multiple Users Using the database Splitter 00:04:00 Configuring Trusted Locations 00:02:00 Password Protecting a Database 00:03:00 Password Protecting Modules 00:01:00 Converting a Database to an ACCDE file 00:02:00 Automating Processes with VBA Understanding VBA Basics 00:06:00 Exploring Variables and Control Flow Statements 00:10:00 Exporting a Table or Query with VBA 00:06:00 Converting a Macro to VBA 00:02:00 Using Table Events Understanding Table Events 00:02:00 Using the Before Change Event Command 00:04:00 Using the After Change Event Command 00:04:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Advanced 00:00:00 Course Certification

Access 2016 Advanced
Delivered Online On Demand1 hour 40 minutes
£25

Access 365 Advanced

By iStudy UK

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

Access 365 Advanced
Delivered Online On Demand2 hours 1 minutes
£25

Accredited Microsoft Access 2007 Professional

By iStudy UK

Microsoft Access is the most powerful and well-known software for creating databases. This course is the advanced version of Microsoft Access 2007 beginner's level, as it will drive you to the advanced level of Microsoft Access 2007. Learn about the advanced features and functions of access 2007. Explore the advanced database tool and how can they be used. At the end of this course, you will be able to create databases as professionals. In this course you will learn the necessary skills, knowledge and information of Microsoft Access.  Course Highlights Accredited Microsoft Access 2007 Professional 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 Access 2007 Professional 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 11 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 Access 2007 Professional 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 Access 2007 Professional 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 Access 2007 Professional 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 - 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 Activities - Microsoft Access 2007 Advanced Level 00:00:00 Mock Exam Final Exam

Accredited Microsoft Access 2007 Professional
Delivered Online On Demand11 hours
£25

Azure - Networking

By iStudy UK

Azure Virtual Network gives you an isolated and highly-secure environment to run your virtual machines and applications. Use your private IP addresses and define subnets, access control policies, and more. Use Virtual Network to treat Azure the same as you would your own datacenter. The Azure - Networking is designed to introduce to virtual network configuration through the Microsoft Azure Portal and network configuration files. You'll also see how to use network services to configure and load balance network traffic using tools such as Azure DNS. Load Balancer, Azure Traffic Manager, and Application Gateway. And because this is about the cloud, you'll see how to connect your on-premises computers to Azure virtual networks as well as establishing connectivity between sites. The course guides you to configure a Point to Site VPN and a Site to Site VPN. On completion this course, you will look at Azure Vnet peering, and how peering between Vnets can reduce the need to build Vnet-to-Vnet VPN gateways. What Will I Learn? Create a Vnet Configure a Point to Site VPN Understand Vnet Peering Understand DNS in Azure Vnets Who is the target audience? People interested in learning Networking Basics in Azure Requirements Some prior knowledge in Azure is required, or the completion of Introduction to Azure course Introduction Introduction FREE 00:02:00 Virtual Networks Virtual Network Overview 00:02:00 IP Address Space 00:03:00 DNS in Azure Vnets 00:03:00 Creating a VNet 00:03:00 VPNs with VNets 00:04:00 Configuring a Point to Site VPN 00:12:00 Configure Site to Site VPN 00:05:00 Azure Vnet Peering 00:02:00 Conclusion Course Recap 00:04:00 Course Certification

Azure - Networking
Delivered Online On Demand40 minutes
£25

Microsoft Windows 7 - Complete Video Training

4.3(43)

By John Academy

Description: Microsoft Windows 7 is the world's leading Operating System for Personal Computer. You will hardly find any business corporation that does not use the Operating System. The course provides you with the basic to advanced features of Microsoft Windows 7 so that you can work proficiently. The course is divided into three parts- basic, advanced and new features. In the basic section, you will be introduced with the fundamental elements of Microsoft Windows 7 focusing Windows 7 Desktop features, Windows Help and Support, folder and file system, Managing Content, using Internet Explorer, etc. In the advanced section, you will learn about the advanced techniques of the operating system such as file management, protection techniques, user accounts, installing devices and printers etc. Finally, in the new features part, you will learn the newly added options of Windows 7 for example file organisation and management, printers and devices, file protection and troubleshooting, and the new features of Internet Explorer 8. In short, people who have prior knowledge or do not have any experience can get benefited from the video bundles course. 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 Windows 7 - Complete Video 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 Microsoft Windows 7 - Complete Video Training 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. The Windows 7 Environment The Windows 7 Desktop FREE 00:14:00 The Start Menu and Taskbar 00:04:00 Window Management 00:07:00 Customizing the Environment Customizing the Taskbar and Start Menu 00:13:00 Working with Gadgets 00:08:00 Libraries, Folders, and Content Folders and Libraries 00:13:00 Working with Windows Explorer 00:08:00 Searching for Content 00:02:00 Device Stage Devices and Printers 00:18:00 File Protection and Troubleshooting File Protection 00:13:00 Troubleshooting 00:10:00 Internet Explorer 8 Internet Explorer Security and Privacy 00:19:00 The Windows 7 Environment The Windows 7 Desktop FREE 00:13:00 The Taskbar and Start Menu 00:01:00 Window Management 00:11:00 Windows Help and Support 00:04:00 Files, Folders, and Libraries Folders and Libraries 00:08:00 Working with Files 00:06:00 Managing Content Working with Windows Explorer 00:04:00 Searching for Content 00:02:00 Customizing the Environment Icons and Shortcuts 00:05:00 Gadgets 00:02:00 System Settings 00:06:00 Internet Explorer 8 Web Browsing 00:09:00 Tabbed Browsing 00:02:00 Web Searching 00:02:00 Customization 00:01:00 Multimedia Content 00:01:00 User Accounts Account Management FREE 00:09:00 Password Management 00:04:00 Devices and Printers Devices 00:04:00 Printers 00:02:00 File Management and Protection File and Folder Management 00:03:00 File Protection 00:06:00 Programs and Utilities Disk Maintenance 00:04:00 System Restore 00:02:00 Troubleshooting 00:05:00 Networks and Mobile Computing Networks 00:14:00 File and Printer Sharing 00:05:00 Offline Files 00:02:00 Remote Assistance 00:01:00 Power Settings and Plans 00:06:00 Security User Account Control 00:03:00 Windows Firewall 00:03:00 Windows Update 00:02:00 Malware Protection 00:05:00 Internet Explorer Security and Privacy 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Windows 7 - Complete Video Training
Delivered Online On Demand4 hours 54 minutes
£22

70-646 - Windows Server 2008 Administration

4.3(43)

By John Academy

Description: The 70-646 - Windows Server 2008 Administration course will prepare you for Exam 70-646: Pro: Windows Server 2008, Server Administrator. Throughout the course, you will learn everything that you need to know about passing the exam. The course starts with the installation system of Windows 2008. After that, the course will teach you how to configure the change plan and how to prepare the server for 2008 migration. The course will teach you the ways of monitoring Windows server, the Windows Server Security, Server backup and restore, Maintenance Plan and Windows Server Troubleshooting. In short, the course will teach about the planning for server deployment and management, application and data provisioning, business continuity and high availability, and monitoring and maintain servers. 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-646 - Windows Server 2008 Administration 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-646 - Windows Server 2008 Administration 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. Preparing for Windows 2008 Installation Overview of Windows Server 2008 Deployment FREE 00:15:00 Making a Deployment Plan for Windows 2008 Server 00:08:00 Planning Migration 00:08:00 Configuration Change Plan Developing a Change Control Process 00:17:00 Developing Configuration Changes 00:13:00 Reviewing Configuration Changes 00:07:00 Preparing for Server 2008 Migration Server Migration 00:16:00 How to Plan for the Server Decommissioning Process 00:14:00 Planning an Example of Commissioning a Windows Server 2008 File Server 00:32:00 Server Migration and Planning for Roles Planning for Windows Server 2008 Hardware 00:15:00 Planning for Windows Server 2008 Core 00:19:00 Combining Windows Server 2008 Server Roles 00:19:00 Planning for Windows Server 2008 File Servers 00:15:00 Understanding Application Server Role Requirements 00:11:00 Overview of the Application Server Role Components 00:06:00 Supporting the .NET Framework 00:07:00 Distributed File System What's Required for DFS 00:08:00 Planning for High Availability in DFS 00:13:00 Managing DFS 00:20:00 Windows Server 2008 High Availability Network Load Balancing 00:13:00 Understanding Failover Clustering in Windows Server 2008 00:11:00 Creating Clusters in Windows Server 2008 00:05:00 Monitoring Windows Server Setting Up Monitoring 00:18:00 Measuring Performance Objects 00:04:00 Calculating a Server Baseline 00:12:00 Which Monitoring Tools to Use 00:07:00 Planning Notification Methods 00:25:00 Windows Server Security Designing a Multi-Layer Defense 00:22:00 Network-Based Security for Windows Server 2008 00:42:00 Host-Based Security for Windows Server 2008 00:20:00 Windows Server Backup and Restore Backup Strategies with Windows Server 2008 00:48:00 Planning a Server Restore Policy 00:16:00 Verifying Restored Data 00:16:00 Planning an EFS Restore Policy 00:07:00 Windows Server Maintenance Plan Planning for Security Update Management 00:22:00 Basic Windows Server 2008 Management Tasks 00:20:00 Automating Windows Server 2008 Maintenance 00:08:00 Planning for Business Continuity Planning for Business Continuity 00:20:00 Reviewing Core Operating System Components 00:07:00 Reviewing Log Files 00:04:00 Evaluating Security Issues 00:10:00 Windows Server Troubleshooting Discovering Hardware Support Issues 00:12:00 Handling Device Driver Failures 00:07:00 Handling Hardware Component Failures 00:05:00 Determining the Scale of Network Issues 00:13:00 Name Resolution in Windows Server 2008 00:12:00 Fixing IP Connectivity Issues 00:09:00 Mock Exam Mock Exam- 70-646 - Windows Server 2008 Administration 00:20:00 Final Exam Final Exam- 70-646 - Windows Server 2008 Administration 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

70-646 - Windows Server 2008 Administration
Delivered Online On Demand11 hours 58 minutes
£24

Microsoft Office 2007 PowerPoint Advanced - Complete Video Course

4.3(43)

By John Academy

Description: Microsoft PowerPoint is a program that helps you create, edit and show presentations. These presentations could be for work, school or any occasions. This Microsoft Office 2007 PowerPoint Advanced - Complete Video Course will expand your basic knowledge of Microsoft PowerPoint 2007 and learn more advanced concepts such as customization and SmartArt Tools. This advanced level will help you make presentations creatively. You will learn how to use the Pictures, Textbox, Table, and Drawing Tools tab and know how to do advanced drawing tasks. Know how to use the Research Task Pane and notes to slides. All of these advanced skills in PowerPoint will help you maximize the potentials of the program. In this course you will learn the necessary skills, knowledge and information of Microsoft PowerPoint. Before joining this course you should keep the basic knowledge of Microsoft PowerPoint. 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 2007 PowerPoint Advanced - 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 2007 PowerPoint Advanced - 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. Custom Presentation Options Application Settings FREE 00:11:00 Custom Themes 00:03:00 Custom Templates 00:08:00 Advanced Slide Master Techniques 00:08:00 Graphic and Multimedia Content Modifying Clip Art 00:07:00 Media Clips 00:05:00 Animations 00:10:00 Photo Albums 00:07:00 Customizing SmartArt Graphics and Tables SmartArt Graphics 00:11:00 Customizing Tables 00:13:00 Action Buttons and Custom Slide Shows Interactive Elements 00:07:00 Custom Slide Shows 00:04:00 Distributing a Presentation Comments 00:08:00 Finishing a Presentation 00:08:00 Distributing a Presentation 00:08:00 Publish as a Web Page 00:04:00 Integrating Microsoft Office Files Build Slides from a Word Outline 00:04:00 Embed and Link Content 00:11:00 Documents Linked with Hyperlinks 00:04:00 Mock Exam Mock Exam- Microsoft Office 2007 PowerPoint Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 PowerPoint Advanced - Complete Video Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2007 PowerPoint Advanced - Complete Video Course
Delivered Online On Demand3 hours 1 minutes
£21

Microsoft Excel 2010 Advanced Level

4.3(43)

By John Academy

Description: In this course, you will learn the advanced features and functions of Microsoft Excel 2010. You will learn how to plan your worksheet and be clear on your objectives and the importance of saving as much as possible. You will know how to use macros to automate repetitive tasks, What If Analysis and how to outline to quickly manage detail data. You will also know the guided exercises provided in this course to refresh your skills. Who is the course for? Professionals who want to learn about the advanced features of Microsoft Excel 2010. People who have an interest in knowing all the functions in Microsoft Excel 2010. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 a cost of £39 or in PDF format at a 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 recognised 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: The Microsoft Excel 2010 Advanced Level course is a useful qualification to possess and would be beneficial for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager. Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 01:00:00 Module Seven - Macros 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 00:30:00 Module Eleven - Grouping and Outlining Data 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2010 Advanced Level 00:00:00 Mock Exam Mock Exam-Microsoft Excel 2010 Advanced Level 00:20:00 Final Exam Final Exam-Microsoft Excel 2010 Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Excel 2010 Advanced Level
Delivered Online On Demand10 hours 40 minutes
£21

Microsoft Access Intermediate Level

4.3(43)

By John Academy

Description: Microsoft Access is a database management system (DBMS) from Microsoft. This software combines the relational Jet Database Engine with a graphical user interface and software-development tools. Microsoft Access is one of the Microsoft Office suites of applications. In this application, users can create tables, queries, forms and reports, and connect them together with macros. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Access 2013 needed for any users and for any professionals. Who is the course for? Professionals who want to learn about the Access. People who have an interest in the more functions and features of Access. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 recognised 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: The Microsoft Access Intermediate Level course is a useful qualification to possess and would be beneficial for following careers: Software Engineer Technical Support Technical Sales Business Analyst Web Developer Software Tester. Microsoft Access Intermediate Level Module One - Getting Started 00:30:00 Module Two - Creating a Custom App 01:00:00 Module Three - Customizing App Actions 01:00:00 Module Four - Customizing Your App Views with Macros 01:00:00 Module Five - Working with Validation Rules and Messages 01:00:00 Module Six - Working with Macros 01:00:00 Module Seven - Advanced Query Tasks 01:00:00 Module Eight - Designing Forms 01:00:00 Module Nine - Advanced Reporting Tasks 01:00:00 Module Ten - Advanced Database Tools 01:00:00 Module Eleven - Working with the Access Environment 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Microsoft Access Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Access Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft Access Intermediate Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Access Intermediate Level
Delivered Online On Demand11 hours 40 minutes
£21