(1) To master Azure
To improve the original Access system without using AZD.
- Master the use of Azure SQL Database.
- Make changes directly to the system after upsizing.
- Please note that when upsizing with AZD again, the changes will be overwritten.
In this case, it is necessary to have a thorough understanding of Azure SQL Database, such as mastering SQL statements.
But you must study that thoroughly, in other words, it's chance to start an engineering career.
If you are interested in learning about databases in earnest, please give this a try!
If you would like to hire an outside professional company and ask them to operate the database in the future as well, please use this method.
(2) Use Access as a hybrid
When using the original Access system to improve functionality
- Please make a copy of the file before upsizing and improving it.
- When improving tables, please make the same improvements directly on the Azure side.
- AZD also allows you to select individual objects for upsizing. For queries, forms, reports, macros, and modules, select only the objects that have been modified and upsize them by overwriting them.
* The latest data of the table will be overwritten if it is upsized as is. When upsizing again, do not use AZD, and modify the table directly on the Azure side.
* If you make any modifications on the Azure side, they will be overwritten, so please be careful not to select the modified objects.
In the case of (1), you will need to learn to write SQL statements directly on the Azure side. But, in the case of method (2), it is not necessary.
However, Access is very efficient in developing queries, forms, and reports.
Feel free to use AZD Express (free version)!