Using Microsoft Access with Dataverse for Cloud and Mobile Apps

Launch Microsoft Access and open the desktop database you wish to integrate with Dataverse.

Navigate to the 'External Data' tab on the ribbon, select 'Dataverse', and choose whether to export your tables or link them directly to the Dataverse environment.

Once the tables are linked, create or modify your Access forms. Use queries to join tables so that readable data (like customer or order names) is displayed instead of raw table GUIDs.

If you require heavy mobile customization and a highly specific user interface for phone-sized applications, opt for Canvas apps.

For simple, standardized business applications or complex relational data entries that are better suited for a tablet, choose Model-driven apps.

Configure your chosen app to support offline synchronization, allowing mobile data entry at job sites, warehouses, or customer locations without an active network connection.

If offline synchronization for mobile apps is a critical requirement for your field workers, select Dataverse, as it handles offline data caching natively and efficiently.

If you are managing a highly complex traditional relational system with massive transaction volumes, SQL Server or Azure SQL may be the preferable backend.

If you plan to heavily utilize Power Apps and Power Automate alongside your database, Dataverse provides the most seamless out-of-the-box integration.