Видео 30
Просмотров 823

11:16

Loading & Hiding Forms - Access Expert

10:03

Event Driven Data Access Macros - Access Expert

11:35

Passing Values - Access Intermediate

17:08

Creating a Workflow - SharePoint Site Admin

19:06

16:13

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

Видео

11:16

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

10:03

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

11:35

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

17:08

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

19:06

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

16:13

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

14:37

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

11:39

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

11:30

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...

8:11

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:19

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

8:13

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

12:23

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

8:54

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