My Hybrid Shopping List -- "Interim" Collections and Persisted Tables- Revised
During final prepping of the previous version, I botched part of the video. Corrected in this version.
====
This video is Part Four of a four-part series:
Part Four explores two functions needed to make the Shopping List work:
-- Persisted tables in the SQL Azure database to retain the current shopping cart between sessions
and
-- The Patch() command for both data insertion and data update.
We wrap up with a look at the final step: moving purchased items from the shopping cart to the permanent database tables in Access.
Part One introduces the concept of Hybrid Access/PowerApps applications and explains why Access developers need to learn more about this approach.
Part Two lets you experience the PowerApps interface, running in a browser. It explains the concept of PowerApps collections -- which can be compared to temporary, in-memory tables.
In Part Two, the emphasis is on using a collection to retrieve a mirror image of a table in the SQL Azure database to improve performance with large recordsets and minimize calls to the server for data.
Part Three explores Filtering and Searching a Collection to return the minimum number of records from that collection to the Items in a Gallery. The final step is Sorting the remaining, filtered set of records for the Gallery. Two approaches to filtering are shown and compared for verbosity and performance.
-
13:34
Grover Park George On Access
1 year agoMy Hybrid Shopping List - AI Powered!
6 -
14:18
Grover Park George On Access
1 year agoMy Hybrid Shopping List -- Intro to Hybrid Access/PowerApps Application concepts
4 -
11:47
Pharos Technology
11 months ago $0.01 earnedSubqueries: Streamlining Your Database Processes
9 -
2:00:47
Los Angeles Data Platform
1 year agoOCT 2022 - Tame Your Unruly Data With Constraints by Rob Volk (@sql_r)
10 -
1:04:10
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: Query Tuning for Data Manipulation by Jeff Iannucci | @SentryOne Room
2 -
1:15:09
Los Angeles Data Platform
1 year agoNOV 2022 - Modernize your Data wrangling approach for Datalakes by Dan King (@SQLSWAGG)
12 -
1:13
TexasQA
10 months agoRevolutionizing Data Management for Efficiency: Streamlining Records with TQA System
-
5:19
Pharos Technology
1 year agoThe Rules That Determine Whether Query Data is Updateable in Microsoft Access
-
7:37
Pharos Technology
1 year agoUnderstanding and Troubleshooting Append Queries in Access
-
11:02
Pharos Technology
1 year agoUnderstanding SQL Fundamentals in Microsoft Access
4