17100 Other courses in Armthorpe delivered Online

Learning Objectives Introduction , Designing Tables for Better Data Entry , Sharing Data with Other Applications , Working with Action Queries , Advanced Query Techniques , Automating Processes with Macros , Advanced Form Techniques , Advanced Report Techniques , Conclusion   Pre-Requisites Access 365 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.   Module 1: Design Tables for Better Data Entry Reviewing Table Design Principles 00:11:00 Setting Field Size, Formats, and Captions 00:11:00 Setting Default Values and Required Fields 00:05:00 Restricting Data Entry-Validation Rules 00:07:00 Restricting Data Entry-Input Masks 00:09:00 Module 2: Share Data with Other Apps Exporting Tables and Queries to Excel 00:05:00 Exporting Data to a SharePoint List 00:02:00 Importing Data from Excel 00:06:00 Importing Data from a SharePoint List 00:02:00 Linking External Data Sources 00:05:00 Using Word Merge 00:06:00 Module 3: Work with Action Queries What are Action Queries 00:04:00 Creating an Update Query 00:06:00 Creating an Append Query 00:04:00 Creating a Delete Query 00:04:00 Creating a Make Table Query 00:04:00 Changing Start Number of an Auto Number Field 00:04:00 Module 4: Advanced Query Techniques Modifying Query Joins 00:06:00 Using Self Joins to Combine Data 00:06:00 Creating Find Unmatched and Find Duplicate Queries 00:09:00 Creating Parameter Queries 00:05:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:06:00 Summarizing Query Data with Totals 00:04:00 Creating Crosstab Queries 00:06:00 Module 5: Automate Processes with Macros Understanding Macro Basics 00:14:00 Creating Macros to Open Forms by Record 00:09:00 Validating Data Entry with Macros 00:10:00 Creating a Macro to Automate Data Entry 00:08:00 Advanced Data Entry Using Macros and DLOOKUP 00:11:00 Module 6: Advanced Form Techniques Using Conditional Formatting 00:04:00 Working with the New Label Name Property 00:03:00 Organizing Form Fields with Tab Controls 00:09:00 Creating an Option Group Control 00:06:00 Creating a Combo Box Control 00:04:00 Configuring a Combo Box Control to Show Search Results 00:04:00 Using a Subform to Show Data From a Related Table 00:06:00 Module 7: Advanced Report Techniques Inserting a Chart on a Report 00:07:00 Showing Data in Columns 00:07:00 Inserting a Subreport 00:05:00 Configuring Reports with Parameter Queries 00:03:00 Sending Reports 00:03:00 Resource Resource - Access 365 Intermediate 00:00:00 Final Exam Final Exam - Access 365 Intermediate 00:20:00

The Power of Market-Creating Innovation Innovation is a commonly used buzzword, but it has lost a lot of value because of its ubiquity. What do we mean by innovation? What types of innovation are there? How can understanding the different types of innovation help us do better work? Market-creating innovations transform complicated and expensive products into products that are simple and affordable so that many more people in society can have access to them. In doing so, these innovations create a new market because they target non-consumers. Efosa Ojomo explains the critical role of market-creating innovations in not only serving as new growth engines for companies, but also as a foundation for sustained economic development of a region. Using theories and models developed by Professor Clayton Christensen and his team, Ojomo demonstrates how innovations that create new markets impact peoples' lives, and challenges us to change how we think about innovation in our organizations. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies.

Blockchain - Coming to a Transaction Near You Blockchain is a technology for enabling and managing transactions and data sharing, bringing a level of security, transparency, and efficiency never before possible. Given how fundamental transactions are to how we function as a society, this evolution will have a transformative effect not just on business, but to how we live. Hyperledger is the fastest growing initiative in Linux Foundation history and Hyperledger Fabric, the work Mark has led, includes over 159 engineers from 28 organizations around the world. Project Management will need to understand the implications for business processes and how working with an open source community might be leveraged within the PM discipline. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

What's New in Microsoft Project 2016? What's New in Microsoft Project 2016? What's new in Microsoft Project 2016? Project 2016 has all the functionality and features you're used to, and some added enhancements and new features. We will provide you an explanation and demonstrations of top new features you'll find in Project 2016, including: More flexible timelines, which allows you to leverage multiple timelines to illustrate different phases or categories of work. You can also set the start and end dates for each timeline separately. We will preview the Resource Engagement that allows for better control over resource scheduling (Note this will only work if you're using Project Professional 2016 connected to Project Online). We will explain how to do things quickly with Tell Me, which is a text field where you can enter words and phrases related to what you want to do next and quickly get to features you want to use or actions you want to perform. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies.

Ten Essential Scaling Patterns We Can (Probably) All Agree On It seems like everyone is scaling Agile these days. And why not? What enterprise wouldn't want to enjoy the business and personal benefits of self-organization, higher quality and productivity, and the intrinsic motivation of effective Agile teams? It is the how that is the question, and on that there are many opinions. In this interactive tutorial, Dean Leffingwell describes the ten essential patterns for effectively implementing Lean-Agile development at enterprise scale. As part of the tutorial, attendees will be invited to rate the importance of each pattern, and privately rate how effectively your enterprise applies them. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Why Passionate Leadership Matters Innovation is a commonly used buzzword, but it has lost a lot of value because of its ubiquity. What do we mean by innovation? What types of innovation are there? How can understanding the different types of innovation help us do better work? Market-creating innovations transform complicated and expensive products into products that are simple and affordable so that many more people in society can have access to them. In doing so, these innovations create a new market because they target non-consumers. Efosa Ojomo explains the critical role of market-creating innovations in not only serving as new growth engines for companies, but also as a foundation for sustained economic development of a region. Using theories and models developed by Professor Clayton Christensen and his team, Ojomo demonstrates how innovations that create new markets impact peoples' lives, and challenges us to change how we think about innovation in our organizations. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies.

Why Passionate Leadership Matters Innovation is a commonly used buzzword, but it has lost a lot of value because of its ubiquity. What do we mean by innovation? What types of innovation are there? How can understanding the different types of innovation help us do better work? Market-creating innovations transform complicated and expensive products into products that are simple and affordable so that many more people in society can have access to them. In doing so, these innovations create a new market because they target non-consumers. Efosa Ojomo explains the critical role of market-creating innovations in not only serving as new growth engines for companies, but also as a foundation for sustained economic development of a region. Using theories and models developed by Professor Clayton Christensen and his team, Ojomo demonstrates how innovations that create new markets impact peoples' lives, and challenges us to change how we think about innovation in our organizations. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies.

Nurturing an Innovative Team Do you have an innovative team? Unfortunately, for many leaders, their initial answer may be 'no.' For some reason, they aren't getting the levels of innovation they want from their team and it can be difficult to figure out why this is happening. This talk introduces the 3 actions you must take if you are looking to nurture an innovative team: Embrace diversity within your team Leverage cross-functional working groups Avoid hierarchies and bottlenecks Participants will come away with an immediate understanding of how embracing diversity and establishing cross-functional groups will help break down organizational silos and encourage innovation. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Strategic Initiative Project Management: Using Projects to Create Business Value The business side of projects has grown significantly. Project management is used on projects related to strategic planning, and project managers are reporting to the senior-most levels of management and even into corporate boardrooms. Traditional project management practices that have existed for decades may not be appropriate for strategic initiative projects. Project managers must learn how to use a new family of metrics capable of measuring business value, creativity and innovation. Executives that sit on project governance committees or are part of the Portfolio Project Management Office must understand how to use these new metrics to make informed decisions. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Strategic Initiative Project Management: Using Projects to Create Business Value The business side of projects has grown significantly. Project management is used on projects related to strategic planning, and project managers are reporting to the senior-most levels of management and even into corporate boardrooms. Traditional project management practices that have existed for decades may not be appropriate for strategic initiative projects. Project managers must learn how to use a new family of metrics capable of measuring business value, creativity and innovation. Executives that sit on project governance committees or are part of the Portfolio Project Management Office must understand how to use these new metrics to make informed decisions. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.