Optimizing Access Interfaces for Remote SQL Server/SQL Azure -- Limiting Selectable choices

In this video, I concentrate on limiting the number of choices offered to the user to improve start up responses. In the next, I'll concentrate on limiting the number of records returned for editing.
The goal of interface optimization is to retrieve the minimum number of records possible from the remote database to complete the current task. There are many ways to optimize Access with SQL Server, including things like properly indexing tables and leveraging views and stored procedures to move the more complex calculations onto the server.
I demonstrate one approach to interface design that attempts to minimize the amount of data moving back and forth from the server.
To learn more about the mobile interface for the Lander Trail Foundations Library, check out my PowerApps 4 Access Devs Playlist. • PowerApps 4 Access Devs
Limiting records for editing in the user interface.
• Optimizing Access Inte...