Hi all I'am a beginner in programming and I have a question about Access and MYSQL What is the best solution between using a database in access and using a database in MYSQL and the difference between both ?
Let's be serious, Access is surely considered as a relational database (however most IT guys say it's not because they consider it not reliable and doesn't have capabilities other have), but its main aim is to serve local applications and it does well. If you are to deal with your personal account on your local computer, then Access will help you to stay simple (no administration required, easy to operate...). Access will fit perfectly for Windows based programming, local and mono-users applications. MySql, on the contrary, is made to serve server applications, with many simultaneous users. It is widespeadly used with PHP since the trio Apache/PHP/Mysql is often installed on hosts server, and will naturally be used by most programmer in PHP. If you install something like UniformServer on your local machine, it comes already with everything integrated and ready to work.
A (somewhat) more reasonable comparison would be between SQLite and Access. Since this is in the PHP section, I am assuming you are saying you are a beginning PHP programmer, in which case it would be more beneficial for you to learn MySQL than access.