![Alpha One Media](/img/default-banner.jpg)
- Видео 30
- Просмотров 823
Alpha One Media
Добавлен 14 дек 2015
Hello everyone, my name is Robin...and I have converted all my instructor led courses into instructional videos for you Power Platform nerds out there along and how to integrate them with your SharePoint Online site.
If learning at your own pace is preferred, then you can access all my course videos that I teach on my subscription based platform - www.WhatDoYouWantToLearnToday.ca. Here you can still get great instructional content, the custom designed manual and learn at your own time and pace.
On my You Tube channel i will be posting some of the topics from all the courses I teach and from the content I make. From the Power Platform products such as Power BI, DAX, Power Apps, Power Automate and Power Pages along with SharePoint Online and MS Access 365.
If learning at your own pace is preferred, then you can access all my course videos that I teach on my subscription based platform - www.WhatDoYouWantToLearnToday.ca. Here you can still get great instructional content, the custom designed manual and learn at your own time and pace.
On my You Tube channel i will be posting some of the topics from all the courses I teach and from the content I make. From the Power Platform products such as Power BI, DAX, Power Apps, Power Automate and Power Pages along with SharePoint Online and MS Access 365.
Forms & Data Cards - Power Apps
In this short video we will investigate the use of Forms & Data Cards. You need to know these as that is what your APPS are built upon. In short, you Form is what will hold your dataset while your data cards will hold a specific record. You also need to remember when using Forms and Data Cards, you are not obligated to show all fields for each record and one reason for that is that you are pulling all that data over the wire, so the point of this course is to show you how to build a lean efficient app for a better user experience.
Full Course @ www.WhatDoYouWantToLearnToday.ca
Full Course @ www.WhatDoYouWantToLearnToday.ca
Просмотров: 18
Видео
Date Time Functions - Power BI DAX
Просмотров 10Год назад
In this short video we will review the Date & Time Functions. We will look at the standard Day, Month Year Functions, as well as the DateDiff caculation while using the feature in the PQE to determine your oldest date, newest date and the age of your data! Full Course @ www.WhatDoYouWantToLearnToday.ca
Loading & Hiding Forms - Access Expert
Просмотров 23Год назад
If network speed Is an issue, then you may want to preload forms and hide them from your users, so they are ready to go when needed. This short video will show you how to do just that all while keeping your speed of your database where it needs to be so users are not waiting for forms to load. Full Course @ www.WhatDoYouWantToLearnToday.ca
Event Driven Data Access Macros - Access Expert
Просмотров 78Год назад
A little hidden gem resides within your tables that I bring into this course is all - Event Driven Data Access Macros. In this short video will show you how you can have fields calculate on a certain field after a record gets entered or modified. This is all done at the table level, and it has been sitting their on the tab system for decades. Full Course @ www.WhatDoYouWantToLearnToday.ca
Passing Values - Access Intermediate
Просмотров 16Год назад
At the end of the day, we want our users to have a great experience when using our database forms. And one way we do that is to have things auto populate for them or use what is on their screen to generate a query. In this short video I will show you how to pass values between a form and a query, so when the user returns to a particular form, a field is already filled in for them based on where...
Creating a Workflow - SharePoint Site Admin
Просмотров 17Год назад
If you have taken one of my Power Automate classes you know what I am going to talk about. This short video will show you how to step into the Power Automate Environment and create an automated workflow then return to your SharePoint site and trigger it from a document library. This is the video you all been waiting for! Full Course @ www.WhatDoYouWantToLearnToday.ca
Login Dialog Box - Access Expert
Просмотров 18Год назад
One level of security you can put on your database is a Login Dialog box. In this video I will show you how to create such a login dialog box and then that way you can add the various users that you will allow to use your database. Just remember not to lose your password! Full Course @ www.WhatDoYouWantToLearnToday.ca
Using SQL to Pull Reports - Access Intermediate
Просмотров 24Год назад
Although SQL is not required when using Access, you can still use it. In this video, I will use some SQL Code to generate a list of access reports for me and then put the results in a form that the user can select from and run the report. Since we are using SQL it will automatically add to the report list if a new report has been created by the designer and therefor will always be current. Full...
Dates in Calculations - Access Intermediate
Просмотров 15Год назад
One thing you cannot get away from when working with database is Calculations and Dates. In this short video I show you how to calculated with date fields. This is good for those who want to simply know the records that are 90 days overdue or those records that need to renew their memberships. Full Course @ www.WhatDoYouWantToLearnToday.ca
Creating a Mult-table Query - Access Foundations
Просмотров 8Год назад
Now that your tables are built, relationships set, you are now ready to query or question that data. In this video we will show you how to create a basic query that references multiple tables to get a new record set. Querying more than one table is common practice is Access as this is a relational database where your data exists over multiple tables, so knowing how to do this effectively is ext...
Issue Tracking - SharePoint Site Owner
Просмотров 177Год назад
Did you know that SharePoint comes with its own support ticketing system? A lot of people did not and its called Issue Tracking. This short video will guide you thru adding the Issue Tracking webpart, customize its settings and even add custom columns so that your users can submit support tickets thru this system instead of sending you direct emails. Full Course @ www.WhatDoYouWantToLearnToday.ca
Removing Edit in Grid - SharePoint Site Admin
Просмотров 4Год назад
All document libraries come with the ability to Edit in Grid view for your users, which is handy when they need to do a massive amount of field updates quickly. However, that can also be dangerous and in this short video we will show you how to turn that feature off! Full Course @ www.WhatDoYouWantToLearnToday.ca
Combining Queries - Power BI
Просмотров 46Год назад
In this topic I show you how to Append and Merge two data tables. I will discuss with you the pros and cons of each scenario, and why I actually use the Merge query to find any orphans and widows. This is all done in the Power Query Editor, as I like to call it the PQE. Full Course @ www.WhatDoYouWantToLearnToday.ca
Error Handling & Scope - Power Automate
Просмотров 67Год назад
In this short video we will look at how to handle errors and the scope of those errors. By default, users will not see errors, so therefore when they click a submit button there may be an error but the user may be unaware of it and assume all is ok. So by learning how to handle an error if one is created, we can send a notification to the user or users letting them know they need to re-submit t...
Understanding Connectors - Power Automate
Просмотров 6Год назад
In this short video, I will review your Power Automate Environment with you and get you set up in yours, so you are ready to start building your workflows. If you are a first-time user to Power Automate, then this video will get you at ease with the environment that you will be developing in. Full Course @ www.WhatDoYouWantToLearnToday.ca
Creating a SharePoint Site - SharePoint Site Owner
Просмотров 10Год назад
Creating a SharePoint Site - SharePoint Site Owner
Importing & Exporting Data - Access Intermediate
Просмотров 9Год назад
Importing & Exporting Data - Access Intermediate
Adding Criteria to Queries - Access Foundations
Просмотров 1Год назад
Adding Criteria to Queries - Access Foundations
List Attachments - SharePoint Site Administrator
Просмотров 2Год назад
List Attachments - SharePoint Site Administrator
Settting Permissions - SharePoint Site Owner
Просмотров 14Год назад
Settting Permissions - SharePoint Site Owner
thanks! that was great. can it extract the user email and id instead of the user manually writing it down?