Uploaded July 2026 | Updated September 2026, 2 weeks ago
In this lesson, we will explore how to use Microsoft Power Apps to build a simple mobile front end for your existing Microsoft Access database by moving your data into SQL Server. We will discuss different methods for accessing Access data remotely, reasons for choosing SQL Server over SharePoint or Dataverse, and walk through setting up a Power Apps canvas app connected to your SQL Server database. I will show you how to start a new phone-size canvas app in Power Apps and connect it to your SQL Server tables, preparing your app to view and edit data on mobile devices.
CHAPTERS:
00:00 Introduction
02:01 Remote Access Options for Microsoft Access
03:27 Cloud Storage Options: SharePoint, SQL Server, and Dataverse
05:30 Making Your Data Mobile: Web Apps vs Power Apps
07:42 Power Apps Limitations and Ideal Use Cases
08:36 Lesson Overview and Game Plan
09:57 The Value of SQL Server as a Central Database
10:13 Prerequisites
12:14 Getting Started with Microsoft Power Apps
14:19 Creating Your First Power Apps Canvas App
15:00 Connecting Your Power App to SQL Server
18:39 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Power Apps: 599cd.com/PowerApps
LINKS:
Access Online: 599cd.com/AccessOnline
File Sharing: 599cd.com/FileSharing
Access SharePoint Seminar: 599cd.com/SharePoint
SQL Server Courses: 599cd.com/SQL
Access SQL Server Online: 599cd.com/SQLOnline
Access Database Cloud: 599cd.com/ADC
ASP Courses: 599cd.com/ASPCourses
UP NEXT:
Power Apps, Part 2: 599cd.com/PowerApps2
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Power Apps, SQL Server, connect Access to SQL Server, mobile database app, Power Apps mobile, Access SQL migration, Power Apps SQL connector, Access web app, Power Platform, Dataverse, cloud database, database front end, remote database access
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
In this lesson, we will explore how to use Microsoft Power Apps to build a simple mobile front end for your existing Microsoft Access database by moving your data into SQL Server. We will discuss different methods for accessing Access data remotely, reasons for choosing SQL Server over SharePoint or Dataverse, and walk through setting up a Power Apps canvas app connected to your SQL Server database. I will show you how to start a new phone-size canvas app in Power Apps and connect it to your SQL Server tables, preparing your app to view and edit data on mobile devices.
CHAPTERS:
00:00 Introduction
02:01 Remote Access Options for Microsoft Access
03:27 Cloud Storage Options: SharePoint, SQL Server, and Dataverse
05:30 Making Your Data Mobile: Web Apps vs Power Apps
07:42 Power Apps Limitations and Ideal Use Cases
08:36 Lesson Overview and Game Plan
09:57 The Value of SQL Server as a Central Database
10:13 Prerequisites
12:14 Getting Started with Microsoft Power Apps
14:19 Creating Your First Power Apps Canvas App
15:00 Connecting Your Power App to SQL Server
18:39 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Power Apps: 599cd.com/PowerApps
LINKS:
Access Online: 599cd.com/AccessOnline
File Sharing: 599cd.com/FileSharing
Access SharePoint Seminar: 599cd.com/SharePoint
SQL Server Courses: 599cd.com/SQL
Access SQL Server Online: 599cd.com/SQLOnline
Access Database Cloud: 599cd.com/ADC
ASP Courses: 599cd.com/ASPCourses
UP NEXT:
Power Apps, Part 2: 599cd.com/PowerApps2
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Power Apps, SQL Server, connect Access to SQL Server, mobile database app, Power Apps mobile, Access SQL migration, Power Apps SQL connector, Access web app, Power Platform, Dataverse, cloud database, database front end, remote database access
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
