The difference between MS Access and MySQL

Microsoft Access:
Microsoft Access is a database program, it uses unique ID numbers and an editable list of data to store details on large amounts of items, i.e., you could use this program to store large amount of data.

• Access is designed to have multiple users working in the same DB files along with the various safety precautions items to help protect the data such as record level locking.
• The database created in Access is saved with a .mdb extension.
• Data is stored in tables.
• Each field of a table can be associated with certain constraints like only allowing an alphanumeric value or different datatypes.
• Like any other relational database, it works on the principles of tables, fields, and relationships. It supports different kinds of datatypes – numbers, dates, texts, etc.

MySQL:

MySQL is an open-source relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications.

• Data is stored in tables.
• Each field of a table can be associated with certain constraints like only allowing an alphanumeric value or different datatypes.
• Like any other relational database, it works on the principles of tables, fields, and relationships. It supports different kinds of datatypes – numbers, dates, texts, etc.
• MySQL is easy to use.
• It is secure.
• Client/ Server Architecture.
• Free to download.
• It is scalable.
• High speed.
• High Flexibility.

MS Access	MySQL
Microsoft Access is an application that acts as a database program. Access deal with database program by collecting, sorting, and manipulating data.	MySQL is an open-source relational database management system based on SQL
It is used for storing and manipulating large amounts of information.   Access do not perform what-if analysis.	The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications.
Microsoft access is quite hard to learn.   Access that needs programming knowledge for some part.	MySQL is easy to use.
The storage capacity is more since access is mainly built for storing, sorting, and manipulating databases.	MySQL stores data in files in your hard disk. The maximum size of MySQL table is 65536 terabytes.
Access has more flexibility as compared to excel.	High Flexibility.
It works on the model of multiple relational tables and sheets.	MySQL is a Relational Database Management System (RDBMS). The logical model, with objects such as databases, tables, views, rows, and columns, offers a flexible programming environment.
It locks data at the record level.	MySQL uses table-level locking in all storage engines except InnoDB meaning that table-level locking is used for tables running the MyISAM, MEMORY and MERGE storage engines, permitting only one session to update tables at a time.
Access is good for long term solutions and large-scale projects.	MySQL is ideal for storing application data, specifically web application data. As MySQL is a relational database, it’s a good fit for applications that rely heavily on multi-row transactions.
Microsoft Product	Oracle Product