The full version of Microsoft Access can be downloaded from www.microsoft.com and is included in the Microsoft 365 subscription.
Yes, there's Access Runtime, but you will only be able to run or execute an MS Access database that someone has already developed.
No, Access as a database file, does not run in the cloud, but there are methods of storing your data in the cloud which can then be accessed by your local copy of Access.
Yes, try out the Northwind online template, that will give you a good idea what Access can basically do.
Access Runtime is free to download and install, but you will only be able to run or execute an MS Access database that someone has already developed for you. Access Runtime does not allow you to make changes or develop your own database.
Yes, it's data can be exported to an SQL or MySQL server. The forms, queries, reports and code will remain in an Access file on your PC.
Allowing the use of blanks or empty fields needs to be carefully considered since Null, Zero and empty are not the same thing, and can have an effect on your reports.
No, MS Access only runs on Windows and Mac PC's. Access also does not run on Linux.
Yes, there are a few ways to achieve this.
No, it's not a database, even though it stores data. Technically, it's a flat file database, not a relational database.
Yes, there are many tutorials to be found online, including some from Microsoft.
Start with deciding on how a database should benefit your business, analyse your existing data and draw up your database schema.
Yes, export your existing data to an online MySQL server and connect your users with an ODBC connection; while still using Microsoft Access locally on each PC.