303 Microsoft AZ-900 courses

Description: The 70-742 - Identity with Windows Server 2016 (MCSA) course will prepare you for the popular Microsoft 70-742 Exam. The most comprehensive course includes all the necessary information that you need to acquire for passing the exam. The course focuses on the identity functionality in Windows Server 2016. It describes the installation and configuration of Active Directory Domain Services (AD DS) including domain controllers, users, computers, groups, and OUs, in addition to Group Policy implementation for non-Nano Server environments. It also covers the Web Application proxy implementations. Throughout the course, you will learn how to work with Complex AD DS Infrastructures, or how to implement Group Policy. The course guide you to understand Microsoft Azure AD and Directory Synchronization, the procedures of monitoring and recovering AD DS, and the ways of implementing Active Directory Services, Active Directory Federations Services (AD FS), and Active Directory Rights Management Services. 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-742 - Identity with Windows Server 2016 (MCSA) 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-742 - Identity with Windows Server 2016 (MCSA) 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. Installing and Configuring Domain Controllers Overview of Active Directory Domain Services FREE 01:00:00 Overview of Domain Controllers 00:30:00 Deploying Domain Controllers 1 01:00:00 Managing Active Directory Objects Overview of AD DS Object Management 00:23:00 Managing User Accounts 01:07:00 Managing Groups 01:06:00 Managing Computer Accounts 00:20:00 Managing Organizational Units 00:41:00 Securing Active Directory Domain Services Securing Domain Controllers 00:33:00 Implementing Account Security 00:48:00 Auditing AD DS 00:26:00 Configuring Managed Service Accounts 00:14:00 Working with Complex AD DS Infrastructures Overview of Advanced AD DS Deployments 00:20:00 Deploying a Distributed AD DS Environment 00:45:00 Overview of AD DS Replication 00:12:00 Configuring AD DS Sites 00:38:00 Implementing Group Policy Overview of Group Policy 00:39:00 Creating and Configuring GPOs 00:56:00 Monitoring and Troubleshooting Group Policy 00:18:00 Security Management Using Group Policy 00:54:00 Managing User Environments 00:22:00 Understanding Microsoft Azure AD and Directory Synchronization Planning Directory Synchronization 00:24:00 Implementing Azure AD Connect 00:12:00 Managing Identities with Directory Synchronization 00:14:00 Monitoring and Recovering AD DS Monitoring AD DS 00:27:00 Database Management 00:07:00 Backup and Recovery in AD DS 00:21:00 Implementing Active Directory Certificate Services Overview of Public Key Infrastructure and AD CS 00:17:00 Deploying Certificate Authority Hierarchy 00:19:00 Administering Certificate Authorities 00:13:00 Deploying and Managing Certificates 00:26:00 Managing Revocation and Distribution 00:07:00 Configuring Certificate Recovery 00:08:00 Implementing Active Directory Federation Services (AD FS) Overview of AD FS 00:17:00 Planning and Deploying AD FS 00:35:00 Overview of Web Application Proxy 00:08:00 Implementing Active Directory Rights Management Services Overview of AD RMS 00:14:00 Deploying AD RMS 00:14:00 Protecting Content with AD RMS 00:09:00 Mock Exam Mock Exam- 70-742 - Identity with Windows Server 2016 (MCSA) 00:20:00 Final Exam Final Exam- 70-742 - Identity with Windows Server 2016 (MCSA) 00:20:00

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

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. Course Highlights Microsoft Access Intermediate Level Accredited Course 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 Microsoft Access Intermediate Level Accredited Course 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 Microsoft Access Intermediate Level Accredited Course 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? Microsoft Access Intermediate Level Accredited Course 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 Microsoft Access Intermediate Level Accredited 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 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 - 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 Accredited Course 00:00:00 Mock Exam Final Exam

Outlook helps you communicate faster with numerous ways to organise your professional email, meetings, and calendar. Discover about Outlook 2007 advanced features, support options, and techniques to help you get more out of your email. Are you ready for a more compelling inbox? This course is designed to provide you with everything you need to know about Microsoft Outlook 2007, which will not only help you organise your emails but it can also assist you in being more efficient and productive at work. Through this course, you will learn the skills, knowledge, and information needed to work with Microsoft Outlook 2007. Enroll now and find out how to organise your emails and files the way you want it. Course Highlights Microsoft Outlook 2007 Advanced is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Outlook 2007 Advanced into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Outlook 2007 Advanced Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Outlook 2007 Advanced is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Microsoft Outlook 2007 Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - Customizing Outlook 01:00:00 Module Three - Adding Word Elements to an E-mail 01:00:00 Module Four - Customizing Your Profile 01:00:00 Module Five - Advanced E-Mail Tasks 01:00:00 Module Six - Advanced Calendar Tasks 01:00:00 Module Seven - Doing More with Tasks 01:00:00 Module Eight - Using Notes 01:00:00 Module Nine - Viewing RSS Feeds 01:00:00 Module Ten - Managing Outlook Data, Part One 01:00:00 Module Eleven - Managing Outlook Data, Part Two 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities- Microsoft Outlook 2007 Advanced CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Microsoft Outlook 2007 Advanced 00:20:00 Final Exam Final Exam- Microsoft Outlook 2007 Advanced 00:20:00

Are you ready to learn all about Microsoft Excel 2007? In our online course, you'll learn how to classify and filter data along with creating formulas that link to other workbooks. You will also find out how to set up and modify advanced charts. Take your knowledge of this versatile application to the higher level with this advanced course. Our expert instructors will help you demystify some of the most challenging formulas and functions in Excel 2007 and explain to you how to put them to their best use. They will help you start with a review of the more primary, building-block functions, and some of the important keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. Course Highlights Microsoft Excel 2007 Advanced Level is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Excel 2007 Advanced Level 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, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Excel 2007 Advanced Level Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Excel 2007 Advanced Level is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Microsoft Excel 2007 Advanced Level is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2007 Advanced Level CPD & IAO Accredited- CPD Accredited 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Excel 2007 Advanced Level 00:20:00

Do you know the basics of Microsoft Word and want to improve your skill? Do you want to increase your current knowledge of Microsoft Word and want to take advantage of the more advanced features? Then this course is designed for you. The course will help you know the complex and advanced features of Microsoft Word. Course Description: Our Microsoft Word 2013 course is perfect for the people who have a basic working knowledge of Microsoft Word. The course focuses the advanced features and functionalities of Microsoft Word 2013 like the customization options in the Word Options dialogue box, he auto text, Quick Parts, and Building Blocks, etc. By the end of the course, you will be an expert user of Microsoft Word 2013. Course Highlights Accredited Microsoft Word Intermediate Level is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Microsoft Word Intermediate Level 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 17 hours, 10 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Microsoft Word Intermediate Level Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Microsoft Word Intermediate Level is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Accredited Microsoft Word 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 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 - Customizing Word 01:30:00 Module Three - Working with Reusable Content 01:30:00 Module Four - Working with Templates 01:30:00 Module Five - Working with Sections and Linked Content 01:30:00 Module Six - Managing Versions and Tracking Documents 01:30:00 Module Seven - Using Cross References 01:30:00 Module Eight - Creating Mail Merges and Labels 01:30:00 Module Nine - Working with Master Documents 01:30:00 Module Ten - Working with Macros 01:30:00 Module Eight - Creating Mail Merges and Labels 01:30:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities-Accredited Microsoft Word Intermediate Level - IAO & CPD certified 00:00:00 Mock Exam Mock Exam- Accredited Microsoft Word Intermediate Level - IAO & CPD certified 00:20:00 Final Exam Final Exam- Accredited Microsoft Word Intermediate Level - IAO & CPD certified 00:20:00

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

Microsoft Azure is an ever-expanding set of cloud services to help your organization meet your business challenges. It's the freedom to build, manage, and deploy applications on a massive, global network using your favorite tools and frameworks. If you are an administrator, developers, or database administrators then this Azure - Introduction will be beneficial for you. Learn the fundamentals of working in a Microsoft Azure environment to help improve your business. The Azure - Introduction will help you get started with Microsoft Azure technologies such as infrastructure, virtual machines, virtual networking, identity, and storage. You will learn how Microsoft Azure can help you build and manage your business's applications and cloud services and help improve overall business productivity. You will learn the procedures of managing Azure from the Classic, New Portal and Azure PowerShell. You will know the steps of authenticating Azure PowerShell. You will also learn various types of cloud services along with the Microsoft Azure. What Will I Learn? Understand the Cloud Learn about the different types of Cloud services Understand Azure services Learn about Azure PowerShell and authenticating Azure PowerShell Requirements This course is suggested for It-related professionals that possess limited/no knowledge of cloud technologies and would like to become familiar with Microsoft Azure. Basic computer skills are required. Basic computer skills are required. Familiarity with the concept of cloud computing and storage is helpful, but not required. Introduction Introduction FREE 00:03:00 Overview of Cloud Services What is the Cloud 00:03:00 Types of Cloud Services 00:04:00 Azure Data Centers 00:03:00 Setting up a Free Trial 00:04:00 Azure Service Overview Compute Services 00:02:00 Networking 00:02:00 Storage 00:02:00 Data and Analytics 00:02:00 Web and Mobile 00:03:00 Miscellaneous 00:02:00 Azure Deployment Models 00:06:00 Azure Management Interfaces 00:02:00 Azure Portal 00:06:00 Azure Powershell 00:07:00 Conclusion Course Recap 00:02:00 Course Certification

Microsoft Access is a database management system that has lots of features and functions to offer. To create mailing labels, work with SQL and publish a Web database in Microsoft Access, you need to learn at an advanced level. Through this course, you will learn the advanced skills, knowledge, and information about Microsoft Access 2010. You can then create and use the advanced forms and tasks to do even more in Access.In this course you will learn the necessary skills, knowledge and information of Microsoft Access 2010. Course Highlights Microsoft Access 2010 Advanced Level Accredited 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 Microsoft Access 2010 Advanced Level Accredited 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, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Access 2010 Advanced Level Accredited 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? Microsoft Access 2010 Advanced Level Accredited 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 Microsoft Access 2010 Advanced Level Accredited 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 2010 Advanced Level Accredited 00:00:00 Mock Exam Mock Exam-Microsoft Access 2010 Advanced Level Accredited 00:20:00 Final Exam Final Exam-Microsoft Access 2010 Advanced Level Accredited 00:20:00

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