156 Microsoft AZ-700 courses in Cardiff delivered On Demand

Description: Windows 7 is the seventh version of Microsoft's widely used Windows operating system. It includes many productivity features that will help users get organized and work smarter. This Intermediate level is intended to help both novice and experienced users become familiar with these productivity features of Windows 7. By this Microsoft Windows 7 Intermediate Operating System you will learn using Windows 7 file management features; working with applications like Windows Media center, Windows Media Player, Windows DVD Maker, and Windows Fax and Scan; and customizing the desktop. So, if you are thinking to brush up your skills, you should join this course now. Learning Outcomes: Get a review of the Windows 7 basics like keyboard shortcuts, Start Menu, Jump Lists, Recycle Bin and gadgets Discover the Windows 7 applications such as Windows Media Center, Windows Media Player, Windows DVD Maker, and Windows Fax and Scan Customize parts of the Windows desktop like the taskbar, Start menu, and desktop appearance Make use of the libraries and search options, which will essentially lead you to manage files and folders 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 Intermediate Operating System 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 Intermediate Operating System 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. Working with Windows 7 Windows 7 Basics 00:30:00 Working with Windows 7 00:30:00 Using the Recycle Bin 00:30:00 Using Gadgets 00:30:00 The Windows 7 Applications Windows Media Center 00:30:00 Windows Media Player 00:30:00 Windows DVD Maker 00:30:00 Windows Fax and Scan 00:30:00 Customizing Your Desktop Customizing the Taskbar 00:30:00 Advanced Taskbar Options 00:30:00 Customizing the Start Menu 00:30:00 Customizing the Desktop 00:30:00 Advanced File and Folder Tasks Using Search 00:30:00 Using Windows Explorer and Libraries 00:30:00 Managing Files and Folders 00:30:00 Advanced File Management 00:30:00 Mock Exam Mock Exam- Microsoft Windows 7 Intermediate Operating System 00:20:00 Final Exam Final Exam- Microsoft Windows 7 Intermediate Operating System 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Access 2016 is a software development and graphical user interface tool that assist you to collect, report, and analyze information for the reference. To become better at MS Access take a look at our well designed MS Access 2016 Advanced course. It will help you in understanding all you need to know about the MS Access. The course aims at the students' efficiency to improve their skill in the functions of an Access database. It teaches the learners how to form joint table and use table analyzer wizard effectively. The course incorporates the fundamental issues of MS Access such as automation process with the help of VBA, creation, and modification of switchboards, and function of table events. It enables the students to configure security and access for different environments providing knowledge with the multiple uses of tools and backup system. 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? MS Access 2016 Advanced 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 MS Access 2016 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 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. 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:08: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:01: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:04:00 Resources Resources - MS Access 2016 Advanced 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Windows 10 is the latest iteration of Microsoft's widely used Windows operating system. This new version of Windows incorporates hundreds of new features as well as improvements to existing ones. This Microsoft Windows 10 Transition from 8.1 will give you the knowledge of Windows 8.1 users become familiar with the many changes that have been made to Windows with release. It focuses on new and improved features in Windows 10, such as the return of the Start menu, the addition of Microsoft Edge, and more. If you are interested to increase your knowledge and skills, you can join this course now. Learning Outcomes: Learn to use desktop and Start menu, multitask using apps, and focus on the new Snap Assist feature Familiarize yourself with notifications, Action Center, Contana, search fields, and virtual desktops in the Windows 10 environment before learning how to connect devices to PC Customize the Window according to your needs using the Settings window and Control panel to modify Windows settings Further personalize the lock screen, desktop, and get introduced to OneDrive - a prominent feature of this version of Windows Work with 3 key productivity apps: Mail, Calendar and Camera Have fun with the entertainment side of Windows 10 by getting to know Groove Music, Movies &TV, and Xbox apps Browse the internet using Microsoft Edge 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 10 Transition from 8.1 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 10 Transition from 8.1 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. Navigating the Windows 10 Environment Navigate the Desktop 01:00:00 Explore the Start Menu 01:00:00 Multitask with Apps 00:15:00 Working with the Windows 10 Environment View Notifications 00:30:00 Search Your Computer 01:00:00 Work with Virtual Desktops 00:30:00 Connect Devices to Your PC 00:30:00 Customizing the Windows 10 Environment Change Basic Windows Settings 01:00:00 Customize the Lock Screen 00:30:00 Customize the Desktop 00:30:00 Store and Share Files with OneDrive 00:30:00 Working with Apps in Windows 10 Use Mail 01:00:00 Use Calendar 01:00:00 Use Camera 00:30:00 Having Fun in Windows 10 Use Groove Music 00:30:00 Use Movies & TV 00:30:00 Use Xbox 01:00:00 Using Microsoft Edge Navigate Microsoft Edge 00:30:00 Use Microsoft Edge 01:00:00 Manage Tabs 00:15:00 Modify Microsoft Edge Options 01:00:00 Mock Exam Mock Exam- Microsoft Windows 10 Transition from 8.1 00:20:00 Final Exam Final Exam- Microsoft Windows 10 Transition from 8.1 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Windows 10 is the latest iteration of the popular Windows operating system. By this Microsoft Windows 10 Standard you will have advanced from being novice computer users to a level where you will be comfortable with the Windows 10 interface, using Windows Store apps, work with the Windows 10 desktop, using Microsoft Edge, customizing the Windows 10 environment, using Windows 10 security features, and much more. If you want to improve your knowledge and skills on Microsoft Windows 10, you can join this course now. Learning Outcomes: Introduction to PC's and Windows 10 user interface, learn to sign in and navigate smoothly through the Start menu Familiarize yourself with the use of desktop and its components, create and modify files through desktop applications, and manage files and folders with File Explorer Explore the internet with Microsoft Edge and utilizing its tabs Discover best ways to use the Windows Store and Universal Apps Interact with Microsoft Cortana and store and/or share files with OneDrive Create new user accounts for the Windows and customize the Start menu Set up account passwords for users and use Windows Defender 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 10 Standard 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 10 Standard 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. Getting to Know PC's and the Windows 10 User Interface Identify Components of a Personal Computer 00:30:00 Start and Sign into Windows 10 00:45:00 Navigate the Start Menu 00:45:00 Working with Windows Desktop Using the Desktop 00:30:00 Elements of a Desktop Window 00:30:00 Manage Files and Folders with File Explorer 00:45:00 Create and Modify Files with Desktop Applications 00:30:00 Using Microsoft Edge Components of the Internet 00:30:00 Use Microsoft Edge 00:30:00 Manage Tabs in Microsoft Edge 00:30:00 Using Windows Store and Working with Universal Apps Using Windows Store 01:00:00 Universal Apps in Windows 10 00:30:00 Other Windows 10 Features Interact with Microsoft Cortana 01:30:00 Store and Share Files with OneDrive 00:30:00 Customizing the Windows 10 Environment Configure User Accounts Using the Settings Window 00:30:00 Personalize Windows 10 00:30:00 Using Windows 10 Security Features Account Passwords 00:30:00 Use Windows Defender 00:30:00 Mock Exam Mock Exam- Microsoft Windows 10 Standard 00:20:00 Final Exam Final Exam- Microsoft Windows 10 Standard 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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

Description: Windows 10 S is a streamlined version of Microsoft's Windows 10 operating system designed to improve performance by limiting the programs it can run. This Microsoft Windows 10 Professional Operating System will help you to become familiar with the many changes that have been made to Windows, including the return of the Start menu and new apps that you can use to complete various tasks. You will also learn how to be comfortable modifying Windows 10 settings, managing user accounts, working with default apps, managing devices, managing networks, and securing system data. If, you want to improve your knowledge and skills join this course now. Learning Outcomes: Get to know how to use Settings window, control panel, working with desktops and managing apps Utilize the Control Panel and Settings window to configure the user accounts, before moving onto family safety features Best ways to utilize key Windows 10 apps like Mail, Calendar, Groove Music, Movies & TV, Camera and Xbox Connect your PC to other devices and change their settings, further manage devices and printer through the Control Panel Learn more about networks and manage them, and share files and folders with Homegroup features Work with file history and data backups, recovering your PC, and configure security settings View system information, utilize the Task Manager, optimize power consumption and troubleshoot problems 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 10 Professional Operating System 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 10 Professional Operating System 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. Working with Windows 10 The Settings Window 00:30:00 The Control Panel 00:30:00 Work with Virtual Desktops 00:30:00 Manage Apps 00:30:00 Configuring User Accounts Configure User Accounts Using the Control Panel 00:30:00 Configure User Accounts Using the Settings Window 01:00:00 Use Family Safety Features 00:45:00 Working with Apps in Windows 10 Use Mail 00:45:00 Use Calendar 00:30:00 Use Groove Music 00:30:00 Use Movies & TV 00:30:00 Use Camera 00:30:00 Use Xbox 00:30:00 Working with Devices Connect Devices to Your PC 00:30:00 Modify Device Settings 00:30:00 Devices and Printers in the Control Panel 00:30:00 Managing Networks Overview of Networks 00:30:00 Share Files and Folders with a Homegroup 00:30:00 Manage Networks 00:30:00 Securing System Data File History 00:30:00 System Recovery 00:45:00 Configuring System Settings View System Information 00:30:00 Use the Task Manager 00:45:00 Optimize Power Consumption 00:30:00 Troubleshoot Problems 00:30:00 Mock Exam Mock Exam- Microsoft Windows 10 Professional Operating System 00:20:00 Final Exam Final Exam- Microsoft Windows 10 Professional Operating System 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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 advanced course 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 maximise the potentials of the program. In this course you will learn the necessary skills, knowledge and information of Microsoft PowerPoint. Who is the course for? Professionals who want to learn about Microsoft PowerPoint 2007 functions and features. People who have an interest in knowing advanced Microsoft PowerPoint 2007 aspects. 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 hard copy 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: The Microsoft PowerPoint 2007 Advanced Level course is a useful qualification to possess and would be beneficial for these professions or career which are: Admin Assistant PA Secretary Administrator Office Manager. 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 Activities-Microsoft PowerPoint 2007 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft PowerPoint 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft PowerPoint 2007 Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This particular course has multiple functions including working with templates, generating the baseline plans, monitoring and renovating projects, analysing the project statistics, coping with delays and conflicts, and overall, learning to customise projects. In fact, through executing the project server 2010, you will gain knowledge of communicating the project information as well as combining the project data with the other relevant office applications in general. Moreover, the learners who are basically the information workers and those who want to learn the elementary level of the Access 2010 skills properly match with the very design of the course. Apart from that,the Microsoft Office 2010 Access Intermediate- Complete Video Course is basically based on the skills and ideas learned from the Access 2010.This particular course helps you learn the items such as: the relational databases, related tables,complex queries, reports and printing, charts and pivot tables and also pivot charts. The fundamental topics that have been discussed in the particular course include: learning about querying with SQL, the advanced queries, Macros, the Advanced Macros and so on. 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 3 Diploma in Microsoft Access 2010 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 3 Diploma in Microsoft Access 2010 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: Beginner Getting Started Database Concepts FREE 00:04:00 Exploring the Access Environment 00:11:00 Getting Help 00:02:00 Databases and Tables Planning and Designing Databases 00:12:00 Exploring Tables 00:11:00 Creating Tables 00:33:00 Fields and Records Changing the Design of a Table 00:15:00 Finding and Editing Records 00:06:00 Organizing Records 00:16:00 Data Entry Rules Setting Field Properties 00:14:00 Working with Input Masks 00:07:00 Setting Validation Rules 00:06:00 Basic Queries Creating and Using Queries 00:13:00 Modifying Query Results and Queries 00:05:00 Performing Operations in Queries 00:17:00 Using Forms Creating Forms 00:11:00 Using Design View 00:14:00 Sorting and Filtering Records 00:04:00 Working with Reports Creating Reports 00:10:00 Modifying and Printing Reports 00:16:00 Module 02: Intermediate Relational Databases Database Normalization 00:14:00 Table Relationships 00:13:00 Referential Integrity 00:12:00 Related Tables Creating Lookup Fields 00:11:00 Modifying Lookup Fields 00:06:00 Using Subdatasheets 00:04:00 Complex Queries Joining Tables in Queries 00:26:00 Using Calculated Fields 00:09:00 Summarizing and Grouping Values 00:08:00 Advanced Form Design Adding Unbound Controls 00:08:00 Adding Graphics 00:04:00 Adding Calculated Values 00:06:00 Adding Combo Boxes 00:04:00 Advanced Form Types 00:10:00 Reports and Printing Customized Headers and Footers 00:17:00 Calculated Values 00:08:00 Calculated Values 00:08:00 Printing 00:03:00 Labels 00:05:00 Charts Charts in Forms 00:08:00 Charts in Reports 00:06:00 PivotTables and PivotCharts PivotTables 00:05:00 Modifying PivotTables 00:07:00 PivotCharts 00:04:00 PivotTable Forms 00:01:00 Module 03: Advanced Querying with SQL SQL and Access FREE 00:06:00 Writing SQL Statements 00:18:00 Attaching SQL Queries to Controls 00:06:00 Advanced Queries Creating Crosstab Queries 00:05:00 Creating Parameter Queries 00:11:00 Using Action Queries 00:17:00 Macros Creating, Running, and Modifying Macros 00:08:00 Attaching Macros to the Events of Database Objects 00:05:00 Advanced Macros Creating Macros to Provide User Interaction 00:20:00 Creating Macros that Require User Input 00:04:00 Creating AutoKeys and AutoExec Macros 00:07:00 Creating Macros for Data Transfer 00:07:00 Importing, Exporting, and Linking Importing Objects 00:14:00 Exporting Objects 00:06:00 Working with XML Documents 00:13:00 Linking Access Objects 00:13:00 Using Hyperlink Fields 00:06:00 Database Management Optimizing Resources 00:16:00 Protecting Databases 00:05:00 Setting Options and Properties 00:06:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Take your career to the next level by mastering new Excel functions. This The New functions in Microsoft Excel in 2021 course aims to provide you with a greater understanding of Excel's new formulas to boost your work output. Microsoft Excel is a widely used spreadsheet program in various organizations. It simplifies the process of calculation, analysis and visualization of data and information. Having Excel skills adds a considerable amount of weight to your resume. In this The New functions in Microsoft Excel in 2021 course, you will learn about the latest functions of Excel to simplify your Excel tasks. You will learn the principles behind dynamic arrays and explore how to create a table of random numbers or random dates with Randarray. It will teach you the new ways of dynamically sorting data with the sort by function. You will also delve into other functions such as XLOOKUP, SWITCH and CONCAT and determine how they work.  Learning Outcomes Familiarize with the new functions of Excel Understand how the FILTER function works Explore how the new UNIQUE, SORT and SORTBY Excel functions work Know how to use RANDARRAY function to randomly sort lists Be able to use DYNAMIC array formulas Understand how to use the new functions in reports Who is this course for? The New functions in Microsoft Excel in 2021 course is highly relevant for professionals who want to excel in their position with their Excel skills. Gaining the skills adds weight to the resume and provides tremendous career opportunities. 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 The New functions in Microsoft Excel in 2021 course provides useful skills to possess and would be beneficial for any related profession or industry such as: Office administrators Accounting officers Managers HR Project Supervisors Data analyst Teachers Sales Representatives The New functions in Microsoft Excel in 2021 Module 01: Introduction and Agenda 00:07:00 Module 02: RANDARRAY 00:04:00 Module 03: UNIQUE 00:05:00 Module 04: SEQUENCE 00:04:00 Module 05: SORT and SORTBY 00:09:00 Module 06: SORT A Practical Example 00:06:00 Module 07: FILTER 00:07:00 Module 08: FILTER A Practical Example 00:08:00 Module 09: Other Useful New Functions 00:15:00 Module 10: Using the New Functions in Reports 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Azure is a cloud computing service formerly known as Windows Azure. This cloud computing service is a big part of Microsoft's business, and it competes with similar services from Amazon and Google. With this diploma in Microsoft Azure 2017 course, get a chance to learn about the fundamentals of working in a Microsoft Azure environment to help improve your business. This course will help you get started with Microsoft Azure technologies such as virtual machines, networking, identity, storage and infrastructure. You will get to learn how Microsoft Azure can help you build and manage your business's applications and cloud services and help improve overall business productivity. So why wait? Join this course now! 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? Diploma in Microsoft Azure 2017 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 Diploma in Microsoft Azure 2017 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. Microsoft Azure 2017 Hello Azure FREE 00:23:00 Subscriptions 00:16:00 Management Portals 00:33:00 App Service 00:22:00 App Settings 00:12:00 Hosting Plans 00:19:00 Deployments 00:22:00 Monitoring 00:15:00 Application Insights 00:25:00 Debugging Part 00:23:00 Function Apps 00:37:00 DevOps 101 00:12:00 Work Backlog 00:19:00 Code 00:12:00 Build 00:10:00 Release 00:12:00 Testing 00:06:00 Mock Exam Mock Exam- Diploma in Microsoft Azure 2017 00:20:00 Final Exam Final Exam- Diploma in Microsoft Azure 2017 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00